Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
marco.mir
Participant
Posts: 16 Joined: Wed Jul 28, 2010 1:30 am
Location: Italy
Post
by marco.mir » Mon Oct 31, 2011 6:30 am
Hello,
I have an issue with a server job always working until now.
I have warning IDENT1: OCI has fetched truncated data.
I made a job with Oracle stage and Sequential File. Oracle table definition in reading is the same of Sequential file.
May someone help me?
Thanks in advance.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Oct 31, 2011 7:26 am
IDENT1 is the 'invisible' transformer between your passive stages. One of your fields has grown large enough to be truncated, it would seem. Any CLOB or unbound NUMBER fields in the source?
-craig
"You can never have too many knives" -- Logan Nine Fingers
marco.mir
Participant
Posts: 16 Joined: Wed Jul 28, 2010 1:30 am
Location: Italy
Post
by marco.mir » Mon Oct 31, 2011 9:00 am
There are char, varchar, decimal and timestamp fields in source.
My doubt is: when my job loads this table, nothing happens. In reading it, just as select * from table, I have this problem.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Mon Oct 31, 2011 11:47 am
Do all the VARCHAR fields have Precision set? Do all the VARCHAR fields have Precision set large enough for the data?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
marco.mir
Participant
Posts: 16 Joined: Wed Jul 28, 2010 1:30 am
Location: Italy
Post
by marco.mir » Fri Nov 04, 2011 7:32 am
I think that I solved. It was a problem of not good data.
Thanks.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri Nov 04, 2011 8:51 am
What kind of not good data?
-craig
"You can never have too many knives" -- Logan Nine Fingers