DSXchange

This is what I got in the log file

The output is ************The Parameter file creation process Started************* The command is : /opt/IBM/InformationServer/Server/DSEngine/bin/dsjob -secfile /opt/IBM/InformationServer/Server/DSEngine/secfile -run -wait -jobstatus -param business_date=2015-07-08 -param batch_id=1011 -param Jp_ba...

Hello, I am sorry for putting the wrong statement The Shell script command is Prcss_Strt_Ts=$(date +%Y%m%d%H%M%S) DSHOME=`cat /.dshome` . $DSHOME/dsenv ds_command=`echo "$DSHOME/bin/dsjob -secfile $DSHOME/secfile -run -wait -jobstatus -param business_date=$Bus_Dt -param batch_id=$Pgm_Batch_id -...

Hello, I am facing an issue with the multi-instance Sequncer. This sequncer calls a job which connects with Database and creatia a file. At one time, we have 4 instances running in parallel. Most of times there is no issue and all the instances are executed successfully. But sometime, the sequncer f...

The client is using Talend and during load of the file, the Job aborted stating that can't load float into Integer..

That means it is not going to work and we need another solution.

Hi,

We are planning to write a stored procedure instead of DataStage job which will create the Pipe delimeted files.

SED/AWK can be an option but It can impact the valid Zeros as for e.g. Date field which may start with Zero..

Regards
Neeraj

It is a RCP JOB.. How can I apply the conversion??

Hello, I have created a RCP Job which is reading the Oracle table and generating the files at runtime. The Job design is:- Oracle connector --> Modify --> Seq Modify stage is used to drop the unwanted columns. The issue we have defined the column as Integer which is read as Number(38,0) and causing ...

While browsing, I found that incase Datastage Login happens via Active directory then Username and password is not required.

Please guide me how can we I do that?

I have no issue in the authentication and sorry for bugging you all again. Let me try to explain it once again 1. I have DataStage on the same Unix box where I have logged in 2. The username and password of Unix and DataStage is same. 3. I have logged in to the Unix using my credential and try to ru...

Hi, I executed the below mentioned command id User1 The output is ---> uid=3842(User1) gid=1(staff) groups=209(dstage),213(cdcadmin) It seems the user which I am using to execute the dsjob command is having the dstage permission as well. Can you please suggest me some guide which I can refer to make...

Hi Ray,

I have tried with Auth file and it worked for me.

But here I am trying to identify what setting I need to make to run the DsJob command without passing credential either via -user or Authfile.

Regards
Neeraj

Hi, Thanks a lot for the reply. We have DataStage and Unix on the same box. In the previous project, we have skipped the domain authentication and not using the Username and password and comand looked something similar. ds_command=`echo "$DSHOME/bin/dsjob -server $ds_server -run -wait -jobstatu...

Hello, I am using the below mentioned command to run the DataStage Job. In the command, I am passing Username,password at runtime which is not encrypted and writing in the log files. The command is working fine and I am getting the expected results. ds_command=`echo "$DSHOME/bin/dsjob -server $...

Hello, I am trying to execute the Unix script from DataStage using Execute_Command Stage. THe Unix script is(test.ksh) :- #!/bin/ksh echo "Test" I have given full permission to this script. During execution I am getting below mentioned error Executed: sh /home/test.ksh Reply=127 Output fro...