Hi,
This is my first post in DSXchange.
The configurations
The customer database is of Peru(Latin America-Spanish)
SOURCE : DB2 hosted on z/OS codepage is CCSID37
Datastge : Version 8.7 hosted on AIX
Configurations from dsenv file
export LANG=ES_PE.UTF-8;
export LC_ALL=ES_PE.UTF-8;
export LC_CTYPE=ES_PE.UTF-8;
export LC_COLLATE=ES_PE.UTF-8;
export LC_MONETARY=ES_PE.UTF-8;
export LC_NUMERIC=ES_PE.UTF-8;
export LC_TIME=ES_PE.UTF-8;
export LC_MESSAGES=ES_PE.UTF-8;
Default NLS : Project default (ISO_8859-1:1987)
Target : DB2 hosted on AIX codepage 1208 and codeset UTF-8
Problem:
While extarctind data from source DB2, the data when viewed from datatstage I see the characters ?????? displayed for a particular column.This column size is 8 characters .For example when viewed the data from the datstage using DB2 connector stage, if input value is only 6 characters U12345 then the output is viewed as U12345?? and if input is null then output is ???????? which is the output value is passed with these junk characters When I load this data into the target DB2 hosted on AIX the job gets aborted with the error SQLExecute reported: SQLSTATE = 22001: Native Error Code = -302: Msg = [IBM][CLI Driver][DB2/AIX64] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use. SQLSTATE=22001
Verified for similar problems in DSxchange but could not arrive at a solution
I tried the options
Removing unicode extensions
Using NLS settings as UTF -8
The link http://publib.boulder.ibm.com/infocente ... idvals.htm
indicates the conversion is not feasible... I am not sure if I understood it clearly.
Any help in identifying where I am going wrong is highly appreciated...Thanks in advance
Let me know if any additional information is required
NLS settings required for handling Spanish characters
Moderators: chulett, rschirm, roy
NLS settings required for handling Spanish characters
Thanks,
HK
*Go GREEN..Save Earth*
HK
*Go GREEN..Save Earth*