DSXchange

Thanks guys for all your help. Yes, I also figured that it is the problem with the first SQL, the way the data is being pulled from the data base and it is being fixed.

Hi, I am fairly new to datastage and don't really know much, but I am supposed to do production support for few handful data stage jobs. I have a simple data stage job which has insert/update/delete logic. The data it deals with is in the order of few thousands only. But, It runs for more than an ho...

Hi, I am trying to run the dsjob command through unix script, as I don't wanna hard code userid and password, I want to use the -file parameter and the file contains the userid and passwaord details. somehow I am not able to get it to work. Any help? My dsjob command looks like below. $SCRIPTPATH/ds...

Thank you, it worked great by doing an nvl just before sending the key to the hash file.

Thanks again,
Kishor

Thanks.

But, is there anyway I can fix the warning itself rather than supressing it? Pls.let me know.

Kishor

Hi, I am new to datastage. I am assigned to run a datastage job. When I run it, at the end of it, I am getting a warning - "Attempted WRITE with NULL record ID" and this job is being called by a unix script. The script checks for the status code of the job and fails if the status code is n...