I have fields in the source A, B, C which has lengths 1,5,20.
I gave a definedstring value in the environmental parameters for null values given as destr1,destr7 which gives values 'U' for destr1 and 'UNKNOWN' for destr7.
I used these definedstring values as NVL in the source query which gives me warning as the length should be 4 times of the destr length like the length for field A should be 4 but given 1 and 80 for field C but given 20.
Below is the warning
When checking operator: When binding output interface field "DEP" to field "DEP":Implicit conversion from source type "string[max=28]" to result type "string[5]": Possible truncation of variable length string.
It gave 28 as I gave destr7 which has length 7
please suggest if any changes are required
Warning in the Oracle enterprise stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am
Warning in the Oracle enterprise stage
Regards,
Kenny
Kenny
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That's just how the interaction with Oracle with NLS enabled works. Depending on version specify four times or three times the actual number of characters in the metadata. Or use a specific string_from_ustring specification to effect the transfer.
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.
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am