DSXchange

We are facing problem in using Load/Replace method in Oracle stage in datastage for all jobs.The jobs which were running earlier are now failing with the following error: ANNUNCIATOR_INPUTS_OUTPUT_ldr,11: APT_FileExportOperator unable to export record: Record larger than fixed-length record stream A...

Hi All, We are facing a problem while loading the data into SAP stages like BAPI and IDOC, to identify the issues we would like to know how the the values are passed to the BAPI / IDoc Stages so that we can resolve our issues. Is there any way that we can debug the job and ABAP together. Thank you, ...

Yes, You can do this with 2 links one link with the constraint "link1.myDate <= '01/01/2007' " and updating all the columns and the other link with constraint "link1.myDate > '01/01/2007' " and updating the column that you want to update.

Hi experts, with kim duke s export batchfile I managed to export my project every night. Controlling the log file and export file, I see that the size of the exported dsx file is about 160 MB, but at initial run two days ago it was 240 MB. In the current log file I have a line saying 375 read-only ...

hi guys, i have code like this aruments i dec arg1,a1,a2 if arg1= '+' then res=a1+a2 else if arg1='-' then res=a1+a2 else if arg1='*' then res=a1*a2 end end end when i was compiling the code iam getting error if Arg1= '+' or Arg1='-' then res=a1+a2 end else if Arg1='*' then res=a1*a2 end

As per Datastage "StageName is the name of the active stage to be interrogated".. May be you are not giving active stage

USE ODBC Stage and in the general tab select stored procedure.

Take ODBC lookup and make colm1,table2.startdt,table2.enddt as keys and in user defined query use select table2.col3 from where table2.colm1= ? and table2.startdt > ? and table1.date < ? and in the transformer give the values for table2.colm1 as table1.colm1, for table2.startdt as table1.date and fo...

I think the julian date format will be CYYJJJ and the data will be like
dj = 106346

to convert the above one we can use this OCONV(ICONV(dj + 1900000,"D2/"),"D4/MDY").

You can use some other date formats for the above one to get the desired result.