DSXchange

thanks Kenneth. But still my question stays unanswered. I have it as a rule of thumb and always design my jobs to have reject link as the last one out of the transformer.. but even if i put it in the second place.. still doesnt seem to matter and i started questioning my assumption and needed clarif...

If you dont want the sequence value to continue from previous load and if you want it to start from 1 for every load job run.. then maybe you could use @INROWNUM or @OUTROWNUM depending on your job design, rather than have to reset the keyMgmt value every time. My 2 cents

Usually we have the reject link as the last link from the transformer to ensure that it captures rejects of the EARLIER output stages.. I have a job that has 2 output OraOCI stages and a sequential file stage (which has the rEJECT row ticked) My goal is to have the same data coming out of the transf...

I tried this, but am getting the error message

DataStage/SQL: Table SDKSequences does not exist

What does this mean.. ? I have done these update many times before.. but on this new server i am getting this error.. any ideas on how to make this work.. thanks in advance

thanks Ray..

for multiple job compile from designer - goto Tools menu - option 'Multiple Job compile' - here you can select if you want to compile all server, parallel or sequencer jobs.. in the project

Guys, Usually, in pattern action language, we code for the tokens that we need to parse for the standardize stage.. for eg: if my job is to look for the token of DATE and then parse out the date value following the token, then we code for it accordingly.. but i have this problem where the tokens are...

thanks Ray, the ulimit has been set to unlimited for the user which is being used to run the DS job.. and when i mentioned that 'when i do a ulimit -a from unix prompt' i meant to say, that logging to unix with the same userid and executing the command ULIMIt... I contacted Ascential about this and ...

Hello Yamini, Were you able to solve this error.. i am having same problem on our AIX server.. when i do a ulimit -a from unix prompt i see that the file size limit is UNLIMITED.. but when i ran the command from a DS job, as suggested in above posts.. i see the 2GB limit.. can someone explain what h...

If there is a transformer stage before this ODBC stage, then you could wrap up this update SQL in a shell script and call it as an after-stage routine to the transformer stage..
this way it gets done before your SQL in your ODBC starts execution

kevin,

Actually, you might want to clear previous contents only on the first job that creates this hash file. The other two jobs that write to this hash file should insert data in append mode.

If you need just the hash file, and not the 3 individual sequential files, could you modify your 3 initial jobs to write to a hash file, rather than a sequential file ?? this way, all 3 jobs are writing to same hash file and when you are done with those, the next set of jobs can lookup on just this ...

Hi guys, Did any of you try to generate the output file name dynamically using a sequence. Basically, i want the output file to have the name as <sequence_number><'STRING'><timestamp>.txt The 'string' is a constant value, so no problem with that and no problem with timestamp, but generating the runn...

Assuming i can use a derivation to check if the column value satisfies check constraints.. (which is impractical, since i dont want to go to target table definition, see what are valid values and create derivations for all columns, which are about 10-20 minimum in each table).. how do u think i can ...

I have a simple parallel job which has a source oracle stage, a transformer and a target oracle stage (uses the upsert method). I want to be able to capture rejected records that dont get inserted into the target table due to violation of either referential integrity constraints or check constraints...