DSXchange

Hi All,

Can any one through some suggestions on the following Err

DataStage Job 785 Phantom 27904
Program "JOB.891742608.DT.1368838389.TRANS1": Line 1173, Improper data type.

I have checked each and every data type,every thing is perfect. The job was running fine y'day, after changing the DSN when I ran the job it was aborted with the Phantom err.

Thanks,

Check the stage variables and their default values.

The error can be located in the given line number on the BP dir TRANS file.

Hi,
I posted a while back how to get to the info you need.
Do search for it.

IHTH,

I would suspect that when you changed the DSN, the underlying database table is defined differently than the one that ran successfully. Scrutinize the actual table definitions (and get the current definitions from the database itself, not from the DDL you "think" was used to create them).

Within the Transformer stage are you invoking any routines that perform I/O? This message often indicates incorrect usage of a file I/O statement, in particular the file variable.