NLS settings required for handling Spanish characters
Posted: Tue Jun 04, 2013 12:13 pm
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
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