DSXchange

Hi All, I have a requirement where I have code for each column in source data table in a lookup table. While populating the target table , I have to look for code of each column and populate the code and related column data as a record into target table. Please let me know if anybody have any ideas ...

Hi , Devula Can you please explain it elaborately as to how to set this env variable as i gave the env variable as you said but the job is still aborting, yes we are using DB2 version 8 And Ray i checked with my DBA and she says the privileges are the same in both boxes. If anybody had a similar pr...

Is there any performance difference if we use a userdefined sql as a generated SQL???

Hi All, When I run a job in test box I get the following message as warning but the job runs successfully where as I get the same message in the prod box the job aborts, can anybody tell me what needs to be done. I am usng DB2 plugin stage. Error Message: [IBM][CLI Driver][DB2] SQL0471N Invocation ...

We recently upgraded the 6.0.1 jobs to 7.5.1. After the upgradation we are testing the jobs. In the process we are getting this error "ORA-01008: not all variables bound" . The design of the jobs is simple, with a source a oracle 9i lookup, loading to a target hash file. The error is basi...

We recently upgraded the 6.0.1 jobs to 7.5.1. After the upgradation we are testing the jobs. In the process we are getting this error "ORA-01008: not all variables bound" . The design of the jobs is simple, with a source a oracle 9i lookup, loading to a target hash file. The error is basic...

jayawant_hsbc wrote:Hi i am creating a job for history processing , and i need to to concatenate all the the non key columns as 1 single column( around 50 ) and at the end i need to split them in their respective values . do we have a ny stage to do.
Thanks

u can use row merger and row splitter

However, I have encountered another case Options: Add Checkpoints so sequence is restartable on failture (ON) Automatically handle activity that fail (ON) In my previous case, I have used "Exception Handler" and "Routine Activity" (call DSJobAbort) to force the sequence aborted ...

Thank you for that clarification. You can edit your current SDKSequences file to change the KeyValues to what ever you like or you might consider creating a simple DS Job that updates the SDKSequences file to the values you want. Yeah. Thats what I have done. Just wanted to confirm that migration c...

Hi all, I am not able to open the DataStage Manager. While attaching a project,DataStage repository interface pop-up window opens up and giving the following error: Failed to connect to host:<hostname> project:<project name> (The connection was refused or The RPC daemon is not running(81016)) can a...

Hi all, I am having this strange problem, since a couple of minutes ago. I am unable to open the properties page of the job activity state. The page where the parameters are set, the triggers can be etc. :cry: Anybody has any suggestion to fix this problem other than to reinstall my datastage clien...

You just add the Invocation ID to the end of the job name, putting a dot/period between the two. So, instead of running jobname you would run jobname.invocationid instead. Is that what you were looking for? $BIN_DIR/dsjob -run -param pathHash=$hash_dir -warn 1 $Proj $JOb so u mean to say i have to ...

We donot have sequences and we call the job from the shell script. Now we made the jobs multiple instance. How can we call the jobs with an invocation ID from the shell script????

Is there any way of disabling the Datastage Import/Export in the DataStage 6.0???

Hi all,

We are planning to install datastage 7.5 on Redhat 2.1 in our organisation and Later we are planning to upgrade OS to 3.0. I am not sure if we can install datastage 7.5 on Redhat 2.1?
Please let me know.

Thank you