Page 1 of 1

Warning Msg in DSJob for Oracle field lengths

Posted: Tue Aug 29, 2006 12:00 am
by Vijay Kumar
Hi,
I am getting the following warning msg in the Job Log:

Implict conversion from source type 'string max[200] to result type max=50. Possible truncation of variable length string.

In fact the field length is 50. I had verified this using the Oracle Client which is loaded on the same DataStage Server.

Is there any other specific setting that should done in DataStage to avoid this kind of warning msgs.

Thanks in advance.
Vijay

Posted: Tue Aug 29, 2006 12:08 am
by balajisr
The message is clearly stating that your source has length of 200 and your target has length of 50 and due to that truncation may occur.

Import your metadata correctly.

Posted: Tue Aug 29, 2006 12:16 am
by Vijay Kumar
The metadata that i have defined is correct it is only of lenght 50 and not 200.
I had verified with the Oracle DBA also.
balajisr wrote:The message is clearly stating that your source has length of 200 and your target has length of 50 and due to that truncation may occur.

Import your metadata correctly.

Posted: Tue Aug 29, 2006 12:20 am
by balajisr
What is your source and target?

Posted: Tue Aug 29, 2006 12:57 am
by Vijay Kumar
Source is Oracle Enterprise Stage and Target is a Flat File.