dsjob
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 88
- Joined: Tue Nov 28, 2006 9:33 pm
dsjob
in dsjob when I get error in param how do i find the bug
Re: dsjob
What error do you get?kishoreramachandran wrote:in dsjob when I get error in param how do i find the bug
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
-
- Participant
- Posts: 88
- Joined: Tue Nov 28, 2006 9:33 pm
-
- Participant
- Posts: 88
- Joined: Tue Nov 28, 2006 9:33 pm
-
- Participant
- Posts: 88
- Joined: Tue Nov 28, 2006 9:33 pm
/bin/ksh
DSHOME=/usr/local/Ascential/DataStage/DSEngine
export DSHOME
. $DSHOME/dsenv
$DSHOME/bin/dsjob -run \
-mode RESET \
-warn 10000 MANC pa1
$DSHOME/bin/dsjob -run \
-param '$APT_CONFIG_FILE=/usr/local/Ascential/DataStage/Configurations/node1.apt' \
-param '$APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL=""' \
-param REMOTE_SERVER="MANC2P_MR" \
-param DB_USER="kishore" \
-param DB_PASSWORD="rama123" \
-param SOURCE_TABLE_NAME="price_order" \
-param PARTITION="P0122" \
-param TARGET_TABLE_NAME="aprice_order" \
-param NZ_DATA_SOURCE="NZSQL" \
-param NZ_DB="manc_ds" \
-param NZ_SERVER="50.1.11.18" \
-param NZ_USER="manc_d" \
-param NZ_PASSWORD="mancd" \
DSHOME=/usr/local/Ascential/DataStage/DSEngine
export DSHOME
. $DSHOME/dsenv
$DSHOME/bin/dsjob -run \
-mode RESET \
-warn 10000 MANC pa1
$DSHOME/bin/dsjob -run \
-param '$APT_CONFIG_FILE=/usr/local/Ascential/DataStage/Configurations/node1.apt' \
-param '$APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL=""' \
-param REMOTE_SERVER="MANC2P_MR" \
-param DB_USER="kishore" \
-param DB_PASSWORD="rama123" \
-param SOURCE_TABLE_NAME="price_order" \
-param PARTITION="P0122" \
-param TARGET_TABLE_NAME="aprice_order" \
-param NZ_DATA_SOURCE="NZSQL" \
-param NZ_DB="manc_ds" \
-param NZ_SERVER="50.1.11.18" \
-param NZ_USER="manc_d" \
-param NZ_PASSWORD="mancd" \
-
- Participant
- Posts: 88
- Joined: Tue Nov 28, 2006 9:33 pm
It makes it confusing, you should have edited your last post.....
MANC is your Project Name and pa1 your job name right?
Just curious if you run the dsjob (outside the script) along with the other details, do you still get the error mesages.
MANC is your Project Name and pa1 your job name right?
Just curious if you run the dsjob (outside the script) along with the other details, do you still get the error mesages.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
-
- Participant
- Posts: 88
- Joined: Tue Nov 28, 2006 9:33 pm
-
- Participant
- Posts: 88
- Joined: Tue Nov 28, 2006 9:33 pm
-
- Participant
- Posts: 88
- Joined: Tue Nov 28, 2006 9:33 pm
-
- Participant
- Posts: 88
- Joined: Tue Nov 28, 2006 9:33 pm