Warning When i run a simple job

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
rajeev_prabhuat
Participant
Posts: 136
Joined: Wed Sep 29, 2004 5:56 am
Location: Chennai
Contact:

Warning When i run a simple job

Post by rajeev_prabhuat »

Hi,

I am having a simple job which takes data from Ms Acess using ODBc and puts it into a sequential file, when i run the job i am geting the folloing Warining,

Job_ERROR_RUN..Sequential_File_4.DSLink5: nls_map_buffer_out() - NLS mapping error, row 1 (approx), row = ""ODBC_SEQ_LOAD=1"

can anyone help me in this regards.

Regards,
Rajeev Prabhu
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
this probably means that your table contains unmapable characters using your current nls settings.
you mead to use a proper nls that recognizes theese characters or convert them in your sql.
look in the nls manuals for more details.

IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Do you have "first line is column names" set and, if so, are the column names too large for your defined column widths?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply