DSXchange

Did you get any warnings in your log ? Also check your reject table stage whether you have set all properties.

Check FIELD function.. It can fulfil your requirement.

Even I am also getting the same error. APR_ORCHHOME and APT_CONFIG_FILE are set properly in my project and also I am able to run DataStage jobs through command line from that location. But ORCHADMIN is not working.

Yes we can call Stored procedure through Stored procedure Stage.
Please refer the manuals where it is explained better.

If your next step is also in DataStage, Dataset will be a good option.

CRC32 is a function that generates a number based on its arugument. If the same argument comes in future, then same number will be generated. For your case, Concatenate all your non key columns from source into a single value and pass this value to CRC32 function. Similarly calculate CRC value from ...

Calculate CRC values using CRC32 function for all non key columns and do a lookup. If the values matches then there is no change and if the value changes then update in table and write in a file. Since it is a server job we cant have ChangeData capture stage.

What's your target datatype. It should be a DATE.

Sorry the date should be MMDDYYYY format

Try this :
OConv(IConv(StageVar1[1,2]:'/':StageVar1[3,2]:'/':StageVar1[5,4], "D2/"),"D4/")

Where StageVar1 is your date '19991231'

If they are mentioned as Environment variables the values are substituted at run time only. If you try to view data in designer then it will show error

How about the other 2 clauses that you gave in IF condtion. Are they true for your current scenario

Is this appearing to you alone or everyone in your team

stageVar=WeekdayFromDate(To_New_isrt_trans.ISSUE_DT)
If the value of stageVar is 0 then it is Sunday I beleive. That you can test with a sample value. As a whole, this function will return the Day number (i.e 0 -Sunday , 1 - Monday,.....)

Check WeekdayFromDate function.