Warning Msg in DSJob for Oracle field lengths

Vijay Kumar · Post by **Vijay Kumar** » Tue Aug 29, 2006 12:00 am

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

balajisr · Post by **balajisr** » Tue Aug 29, 2006 12:08 am

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.

Vijay Kumar · Post by **Vijay Kumar** » Tue Aug 29, 2006 12:16 am

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.

balajisr · Post by **balajisr** » Tue Aug 29, 2006 12:20 am

What is your source and target?

Vijay Kumar · Post by **Vijay Kumar** » Tue Aug 29, 2006 12:57 am

Source is Oracle Enterprise Stage and Target is a Flat File.