A warning msg that i'm unable to solve

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

Post Reply
raj_cipher
Participant
Posts: 90
Joined: Mon Dec 08, 2003 4:48 am
Location: Chennai

A warning msg that i'm unable to solve

Post by raj_cipher »

Hi,
I'm getting the following warning.I hv checked for input/output filed lengths.They r correctly mentioned. But i don't know why this error is coming.

Message: IWD5A014Part3..IWD_CLM_LINER_Seq.IWD_LNR_OP_Lnk: nls_map_buffer_out() - NLS mapping error, row 1 (approx), row = "```80036946860000000000```|```0001```|```X```|```900```|```N```|```
N
``9203 `|``` ```|``` ```|``` ```|``` ```|``` ```|``` ```|``` ```|``` ```|``` ```|```AD```|||```199811173456```|`Y`|0|0|`_`|`_`|0|0|`1753-01-01`|`1753-01-01`|```2003-11-16```"

Pls Help me out on this regard...
Think Ahead,
Raj.D
raju_chvr
Premium Member
Premium Member
Posts: 165
Joined: Sat Sep 27, 2003 9:19 am
Location: USA

Re: A warning msg that i'm unable to solve

Post by raju_chvr »

Where are u having this error ? I mean in which stage?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

That message usually indicates that there is at least one character in your data that can not be mapped using the NLS character map set on that link.

Usually there is a "?" character in the View Data grid indicating which character(s) could not be handled.

If this is coming from an ODBC data source, you might like to verify that the quote and separator characters are correctly set.

What are all the backquote characters doing?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
raj_cipher
Participant
Posts: 90
Joined: Mon Dec 08, 2003 4:48 am
Location: Chennai

Solved

Post by raj_cipher »

Hi ,

Thanks guys.The pblm was i had a quote appended in each fields.
Think Ahead,
Raj.D
Post Reply