View Data From DB/UDB Enterprise Stage

[daniel0623]

Hi all,
I can create table in DB2,but come up against a problem when I view data from DB2/UDB Enterprise Stage.The error as follows:
>##W TNDB 000361 11:07:17(001) <DB2_UDB_Enterprise_0> File db2_cs.txt either does not exist or contains no values for ICU charset ASCL_GB2312. Set environmental variable DB2CODEPAGE or verify that OS defaults can be used.
>##E TNDB 000312 11:07:18(001) <DB2_UDB_Enterprise_0> Error Idx = 5;
>DB2 Driver Embedded SQL: -391;
>sqlcode = 42881;
>sqlstate = SQL0391N Invalid use of the row based function "SYSIBM.NODENUMBER".
>SQLSTATE=42881
db2_cs.txt exists in dir ~/Ascential/DataStage/PXEngine/etc.Variable DB2CODEPAGE in DB2 is "819".How to resolve it?Please help.thanks.

[ray.wurlod]

Welcome aboard! :D

Does DataStage have NLS enabled? That character set GB2312 (which is one of the Chinese maps) is specified leads one to believe so.

Do you have the DB2CODEPAGE environment variable also set to GB2312?

[daniel0623]

DataStage have NLS enable. The default NLS Map is GB2312. Do I need to set DB2CODEPAGE to "GB2312" in ~/DSEngine/dsenv or in DB2? Thanks.

[Eric]

Set DB2CODEPAGE in either dsenv or as a project level user defined variable in the administrator.

You could also add the code into the db2_cs.txt file

[ray.wurlod]

It doesn't matter where the environment variable is set, so long as the DataStage processes inherit its value. The DataStage processes, in turn, become clients of the DB2 database server.