View Data From DB/UDB Enterprise Stage
Posted: Tue May 31, 2005 9:19 pm
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.
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.