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
Warning Msg in DSJob for Oracle field lengths
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 59
- Joined: Sat May 29, 2004 12:31 am
- Location: Pune
-
- Participant
- Posts: 59
- Joined: Sat May 29, 2004 12:31 am
- Location: Pune
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.
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.
-
- Participant
- Posts: 59
- Joined: Sat May 29, 2004 12:31 am
- Location: Pune