DSXchange

Hi All, I have installed Datastage Parallel 7.5x2 on Windows XP. i couldnt able to compile the job when i am using an transformer stage. can any one pls let me know how to solve this issue. Error: Output from transformer compilation follows: ##I TFCN 000001 22:02:22(000) <main_program> Ascential Dat...

What's XPath Expressions? Where do we need to set them? I dont have any XML experience. Im trying to learn now.

But u can modify the oracle source query for null handling.

It should work but r u recieving the same message? In the source query try to use NVL(EMP_CODE,'') as EMP_CODE. Is that a direct mapping or do u have any intermediate stages between source and target. In which stage u r recieving this 'Field 'Emp_code' from input dataset '0' is NULL. Record drop' me...

Try to use NullToEmpty(EMP_CODE) in the column derivation, and let me know if the problem still exist

Hi , I have designed a job as Src_sequential File ----> XML Input -----> Tgt_Sequential file In Src_sequential File , I ahve embedded the XML file path and metadata as input_rec of datatype longNvarachar. In XML Input stage, I selected the option 'URL PATH' and loaded the namespace definition and in...

I need to know how to use XML input and Output stages to read and write data. I have downloaded some of the materials which I got from DSxchange, but those examples are dealing with Server jobs.Is it necessary to know XML codes when we need to read data or write data into XML through datastage. I ha...

Whether the Header and Trailer records are in Sequential file? Do you want to merge them into single file or do you want to join them? Send brief description of your requirement.

Hi,

Could you please specify the Output format you require. The question is not so clear, it would be easy to understand if the output is posted.

Hi set the value to null isntead of '' as below,

if Trim(Out_MAI21.Suppdate)='' then Setnull() else StringToDate(Out_MAI21.Suppdate,"%yyyy%mm%dd")

Thanks , Now I'm able to execute after passing DSinvocationid to the job. I have one more question here, In a Oracle table I have a field called 'InvocationId'. Every time the sequence should lookinto this table and if there are 4 invocation ids(4 rows) then 4 instances should be raised by reading e...

I'm not aware of the Multiple instance completely. I'm doing it for the first time. Let me know how to pass sequence invocation id as part of job invocation id? I'm invoking the sequence from unix using '-dsjob -run NORMAL <PROJECTNAME> <SEQUENCENAME>.<INVOCATION_ID> Here how do we pass this ivocati...

Hi, I'm running the sequence with two different invocation id's, but within the sequence, the job is getting a single invocation id for two instances of the sequence. When we pass invocation id to the sequencer, the job is not taking that invocation id for it. How do we pass the invocation id to the...

I have a Job sequence with a single job inside it. I have enabled the 'Multiple Instance' at sequence level as well as Job level. When I execute the Sequencer from unix with two invocation ids, One of the instance is successfully getting finished. But the other is getting aborted. Its not throwing a...

Hi Laxman,

Thanks for your solution.