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.
View Data From DB/UDB Enterprise Stage
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 34
- Joined: Tue May 31, 2005 8:17 pm
- Location: ShangHai,China
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Charter Member
- Posts: 34
- Joined: Tue May 31, 2005 8:17 pm
- Location: ShangHai,China
Error still exists
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.