DSXchange

Check how your delete query looks in that stage. It should have WHERE clause having your key columns in it.

Use CONVERT function. And this has been answered here already. You can do a serach in this forum also.

SELECT DATE('2001-09-22'), DATE('2001-09-22') - 7 DAYS FROM SYSIBM.SYSDUMMY1;

Use this as base and try to modify as per your requirement.

Use convert/index function to find whether the input contains any special characters.

Try this code

( (@INROWNUM - 1) * @NUMPARTITIONS + @PARTITIONNUM + 1)

Add a reject link to Oracle stage and try to get the reason code. See if you can find anything from that.

Then use to_date() function in Oracle Stage while inserting..

Did you use StringToDate to convert String to a date before loading

You should be using sv1=Field(pFilename,"_",2,1)
to get the date from file name..

Try with Index function

While sorting in descending order add CreateKeyChange column in sort stage and then use remove duplicates using CNO and CreateKeyChange column value. I believe you will get only 2 entries.

Why you want to write the date in a file and read again. Instead you can use UserVariable activities.

There is no explicit IN statement . But we can implement the same functionality through Index function.
Index('Year,Year-1, Year-2','Year',1) > 0

I am expecting a strange behavior in Stored procedure stage. I am trying to call a DB2 procdure having 3 input parameters and 4 output parameters. When I run with a single row, for some cases the procedure runs fine. But when I run with multiple rows the DataStage job is aborting with the reason 'St...

Also check in your director log whether your script is returning values as expected.