DSXchange

Hi All ,

I have a requirment to extract the data that comes after 0 .

ex: EM0000000000000592176

Need to fetch 592176

The number of zeros may vary

ex:EM00789892

Output :789892

When we try with Field(Arg1,"0",1) this will provide EM .
Please let me know how to get data after 0

I tried compiling the job in trace mode . but still the option is disabled

I am unable to run the job with limits from Datastage . The whole option is disabled .can any one please tell me whether there is any way to enable the same .

Thanks Jerome , It was unprintable Ascii value .Was able to handle with seq function .

Hi All , I have job which has Teradata as source and Oracle as target . Some columns are coming as null, and as per the req if the column has null need to replace with 4 space . But I am unable to handle the nulls coming from source with the help of isnull . Is there any way to know whether the colu...

yes , we got the same error which has been posted

We have mentioned the exception table name also ..

Hi All , I am getting the below error when trying to run the DS job which has oracle bulk load option enabled The connector was configured to write data in bulk load mode and the reject condition for checking constraints was selected for the reject link. For this operation to work it is necessary to...

Hi All ,
We have a req where we receive the file which contain Japanese characters .
But once DS process the file the data is getting displayed as "?????"
Is this a DS problem or a DB issue .

Can any one let me know how to fix this .
I am using Project default (ISO8859-1) NLS setting.

Hi All , I am trying to use matchfield function for the below scenario . My requirement is if Arg1 will contain SDN in any position it should be populated as Y else Null. TRIM((IF MATCHFIELD (Arg1,"0X'SDN'0X",2)=1) THEN 'Y' ELSE @NULL) Values for Arg1 is as follows ================== TFM,S...

Hi All , Can any one please tell me when a job fails where the details will be saved . For eg : In the server ABC if 20 jobs has failed at the same time will this information be saved in any place . If so can we retrieve the information like which all jobs has failed . Rather than going into DS dire...

Hi All ,
Can any one please tell me where can I find the details which all jobs has failed in one project.
Will Datastage save these info some where other than DS director .

chulett wrote:I assumed they are looking for the C++ code for dsjob (which is actually published) rather than where the executable lives... but I guess we'll see.

Yes Craig ,I am looking for the C++ code for dsjob . If it is published could you please let me know where I can find the same .

Can any one please let me know where we can find the code for dsjob ?

Could you please tell me how to export multiple jobs via command prompt . I am using the below command for exporting the jobs via command prompt . dsexport.exe /H=hostname /U=user /P=pwd /JOB=jobname <project> <Path> Please tell me if we have multiple jobs(job1,job2) how to export it using the comma...