DSXchange

Hi All, can anyone help me with the situation. i have input as seq file and their is colmn email id and output is also a seq file and reject file is also seq file: Seq------trans-----seq(target) \ \(reject) \seq ex: roxy123@gmail.com(pass) roxy123@gmail..com(reject) roxy 123@gmail.com(reject) and em...

Thanks chulett

Hi Gurus,

can any one please help me understand this constraint

(StageVar = 'Y' and lkp.NOTFOUND = @false ) or lkp.NOTFOUND


Thanks
in advance

Thank you chulett, got it

Hi All,

I have a condition If IsNull(DSLink1.EMP_ID) Then ' ' Else DSLink1.EMP_ID

Now iam confused when to use @NULL , Can we use @ NULL instead of ' ' in the condition .

Please suggest me.

Thanks in advance

Thank you very much chulett .

Hi All, Iam new to datastage server edition when i was going through the jobs i came across the following functions may i know Y do we use them and i have searched for those functions in help topics also i dint find the result. NullHandleNumeric NullHandleVarchar Iam wondering whether such kind of f...

Hi friends,

Iam working on datastage 7.5 server edition, and iam new to peoplesoft tools can any one tel me what is peoplesoft hcm,peoplesoft epm,OWS ,OWE,custom data,delivered jobs?

Thanks in Advance

yes every time they are running the query manually using sql developer, and

note:they dont want to use shell scripts

so asked me to convert to datastage jobs

Hi All, I was assigned a task to convert system generated sql script to datastage job and iam using server edition 7.5 version. sql script consists of 15 tables and 3 views and and many joins and many subqueries , the sql script is almost 3 pages and it is deleting and inserting records and the firs...

No I didn't use any routines. In fact I have used custom sql and I didn't put any constraints in transformer, its a straight move.

Now when i try to run the similar job iam getting the similar warning is their any thing to worry with this warning ?data is getting loaded but ending up with this these kind of warning in view log

start problems
DataStage Job 541 Phantom 8987
DataStage Phantom Finished

sorry its not error its warning ,job is working fine and data is getting loading but iam getting this warning at last

start problems
DataStage Job 539 Phantom 13455
DataStage Phantom Finished

Hi All, I have a job like this oracle----->transformer------>oracle when i try to run job everything is fine regards are getting loaded but I am ending up getting following error can any one aware of it plz help me start problems DataStage Job 539 Phantom 13455 DataStage Phantom Finished Thanks Raji