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,
Phantom
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Hi,
I posted a while back how to get to the info you need.
Do search for it.
IHTH,
I posted a while back how to get to the info you need.
Do search for it.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
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).
Rick H
Senior Consultant
Senior Consultant
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.