DSXchange

Is there anyway to trap these errors

Hello - I currently am running a datastage job that contains error and reject file logs within for bad data. however say the job fails for whatever reason privelage insufficeint disk space and etc.. I know it is written to a job log file viewable through Director but is there anyway to view the erro...

I mean use ANd instead of OR

Ahh i see didnt really even think about it. I guess you have to create a reject link for each constraint

I have that in place already Not(IsNull(DSLink2.userid)) Or Not(IsNull(DSLink2.Amount)) Or Not(IsNull(DSLink2.ban)) Or Not(IsNull(DSLink2.due_dte)) Or Not(IsNull In the reject link i have this constraint IsNull(DSLink2.userid) Or (IsNull(DSLink2.Amount)) Or (IsNull(DSLink2.ban)) Or (IsNull(DSLink2.d...

I have set up constraints in my transform stage and I set one link to be a reject row when a certain condition is met. In my example I passed in one field as null and it send that row to the reject file like it was suppose to. However that row is also is being passed on in the other link which goes ...

I have source files that have ids prepended to each filename
In my sequentail file stage in the filename textbox is there anyway i can pass in a variablename in there. What i really want to do is pass in the filename as a job parameter and then read that parameter in the filename textbox

Hi All -
I am new to datastage and i have this issue.
I am reading in data from a sequential file and the date format is a timestamp yyyy-mm-dd time. I need to do a conversion to mm/dd/yyyy
because i keep getting this invalid month error. Can anyone help?

Thanks,
Anis