altquark
Legendary Poster
Hi listers
ok - heres a perplexing one, and i'm hoping someone out there has simplified chinese.
My customer is running OneWorld Xe (B7333) SP23K1. Primary platform is AS/400 (V5R3). I think thats all the info you need about the platform (though they ARE running central objects on a SQL Server 2005 on the deployment server).
ok - they have two instances of oneworld. The first instance is set up using standard JDE with CCSID 37 and contains all the single-byte languages (English, French, Italian etc etc). The second instance runs on a separate port and uses CCSID 939 for Japanese users. I know, they could have combined the two as a single instance - but back when all this was created, there might have been additional doublebyte languages.
Now, strangely enough, they created a data dictionary using CCSID 65535 (unicode) - which, of course, is not right. But, we're not touching production working code - especially if its working !
Anyway - they get an urgent requirement to implement Simplified Chinese - so the decision is made to create a new separate instance using CCSID 935. So, I install a new instance on a new port, create new pathcodes (for the chinese language pack), create a new Data Dictionary - CHINA datasource and upload the china DD - and build a new data set (DVCDTA and DVCCTL for example) using an iSeries system user with CCSID 935. Everything initially looks ok.
The F0101, for example, is a CCSID 935 table, and I have a user with a CCSID 935 system user that read/writes with no issue.
BUT, then during testing its revealed that there are a handful of missing tables. Specifically the F3002. So, I add this to OMW and attempt to generate the table using my "JDESCH" oneworld user (which has a system user "JDESCH" with 935 CCSID).
I get an error trying to generate the table as follows :
[ QUOTE ]
5288/6140 Sun Jan 10 23:14:06 2010 jdb_ctl.c2763
Starting OneWorld
5288/6480 Sun Jan 10 23:14:27 2010 jdb_ctl.c6179
JDB9900155 - Failed to get non - zero AB Number.
5288/6480 Sun Jan 10 23:14:48 2010 jdb_ctl.c6179
JDB9900155 - Failed to get non - zero AB Number.
5288/6480 Sun Jan 10 23:15:41 2010 ODBC_U1.C1124
ODB0000175 - Columns not in cache in Table F3002
Column IXF$RP
Database Business Data - PD7333
5288/6480 Sun Jan 10 23:15:41 2010 JDBODBC.C1515
ODB0000055 - Describe table failed for table F3002.
5288/6480 Sun Jan 10 23:15:41 2010 jdb_drvm.c839
JDB9900168 - Failed to initialize db request
5288/6480 Sun Jan 10 23:15:41 2010 JTP_CM.C1090
JDB9909007 - Unable to obtain driver request handle
5288/6480 Sun Jan 10 23:15:41 2010 JDBODBC.C5470
ODB0000071 - SQLPrepare failed
5288/6480 Sun Jan 10 23:15:41 2010 JDBODBC.C5470
[IBM][System i Access ODBC «˝∂Ø≥ÖÚ][DB2 i5/OS ∞Ê]SQL0113 - ≤ª‘ –Ì√˚≥∆IXF$RP°£ - SQLSTATE: 37000
5288/6480 Sun Jan 10 23:15:41 2010 jdb_drvm.c938
JDB9900401 - Failed to execute db request
5288/6480 Sun Jan 10 23:15:41 2010 jdb_exem.c481
JDB21000091 - Failed to create table F3002 in data source Business Data - DVC7333
5288/6480 Sun Jan 10 23:15:41 2010 tccopy.c568
TCE000009 - CopyTable create output table failed.
[/ QUOTE ]
When I look, all the tables that failed to create ALSO have the "$" symbol in their column names. So, I am presuming that these are being interpreted as chinese characters.
I capture the create table command using JDEDEBUG - and log into the AS/400 directly with a CCSID 935 user. I am then ABLE to create the table directly - so the use of "$" isn't actually an issue.
ok - so this table doesn't actually need to contain chinese characters, since it just contains numbers. So, I generate the table as a CCSID37 table as a test.
I log in using my JDESCH user ID, with its JDESCH System ID (default CCSID 935) - and its NOT able to read the F3002 I just generated.
So, I change my system user to default to CCSID37. Now, it can read/write to the F3002 AND it can see chinese data in, for example, the F0101.
My question is - is this right ? are my Simplified Chinese oneworld enduser system user ID's supposed to all be CCSID 37?
What is my Data Dictionary supposed to be generated at - I presume CCSID935 - but I'm unsure given the shared English/Japan one being at CCSID65535 !
Could someone who has Simplified Chinese on an AS/400 please look and see if our setup is right ?
ok - heres a perplexing one, and i'm hoping someone out there has simplified chinese.
My customer is running OneWorld Xe (B7333) SP23K1. Primary platform is AS/400 (V5R3). I think thats all the info you need about the platform (though they ARE running central objects on a SQL Server 2005 on the deployment server).
ok - they have two instances of oneworld. The first instance is set up using standard JDE with CCSID 37 and contains all the single-byte languages (English, French, Italian etc etc). The second instance runs on a separate port and uses CCSID 939 for Japanese users. I know, they could have combined the two as a single instance - but back when all this was created, there might have been additional doublebyte languages.
Now, strangely enough, they created a data dictionary using CCSID 65535 (unicode) - which, of course, is not right. But, we're not touching production working code - especially if its working !
Anyway - they get an urgent requirement to implement Simplified Chinese - so the decision is made to create a new separate instance using CCSID 935. So, I install a new instance on a new port, create new pathcodes (for the chinese language pack), create a new Data Dictionary - CHINA datasource and upload the china DD - and build a new data set (DVCDTA and DVCCTL for example) using an iSeries system user with CCSID 935. Everything initially looks ok.
The F0101, for example, is a CCSID 935 table, and I have a user with a CCSID 935 system user that read/writes with no issue.
BUT, then during testing its revealed that there are a handful of missing tables. Specifically the F3002. So, I add this to OMW and attempt to generate the table using my "JDESCH" oneworld user (which has a system user "JDESCH" with 935 CCSID).
I get an error trying to generate the table as follows :
[ QUOTE ]
5288/6140 Sun Jan 10 23:14:06 2010 jdb_ctl.c2763
Starting OneWorld
5288/6480 Sun Jan 10 23:14:27 2010 jdb_ctl.c6179
JDB9900155 - Failed to get non - zero AB Number.
5288/6480 Sun Jan 10 23:14:48 2010 jdb_ctl.c6179
JDB9900155 - Failed to get non - zero AB Number.
5288/6480 Sun Jan 10 23:15:41 2010 ODBC_U1.C1124
ODB0000175 - Columns not in cache in Table F3002
Column IXF$RP
Database Business Data - PD7333
5288/6480 Sun Jan 10 23:15:41 2010 JDBODBC.C1515
ODB0000055 - Describe table failed for table F3002.
5288/6480 Sun Jan 10 23:15:41 2010 jdb_drvm.c839
JDB9900168 - Failed to initialize db request
5288/6480 Sun Jan 10 23:15:41 2010 JTP_CM.C1090
JDB9909007 - Unable to obtain driver request handle
5288/6480 Sun Jan 10 23:15:41 2010 JDBODBC.C5470
ODB0000071 - SQLPrepare failed
5288/6480 Sun Jan 10 23:15:41 2010 JDBODBC.C5470
[IBM][System i Access ODBC «˝∂Ø≥ÖÚ][DB2 i5/OS ∞Ê]SQL0113 - ≤ª‘ –Ì√˚≥∆IXF$RP°£ - SQLSTATE: 37000
5288/6480 Sun Jan 10 23:15:41 2010 jdb_drvm.c938
JDB9900401 - Failed to execute db request
5288/6480 Sun Jan 10 23:15:41 2010 jdb_exem.c481
JDB21000091 - Failed to create table F3002 in data source Business Data - DVC7333
5288/6480 Sun Jan 10 23:15:41 2010 tccopy.c568
TCE000009 - CopyTable create output table failed.
[/ QUOTE ]
When I look, all the tables that failed to create ALSO have the "$" symbol in their column names. So, I am presuming that these are being interpreted as chinese characters.
I capture the create table command using JDEDEBUG - and log into the AS/400 directly with a CCSID 935 user. I am then ABLE to create the table directly - so the use of "$" isn't actually an issue.
ok - so this table doesn't actually need to contain chinese characters, since it just contains numbers. So, I generate the table as a CCSID37 table as a test.
I log in using my JDESCH user ID, with its JDESCH System ID (default CCSID 935) - and its NOT able to read the F3002 I just generated.
So, I change my system user to default to CCSID37. Now, it can read/write to the F3002 AND it can see chinese data in, for example, the F0101.
My question is - is this right ? are my Simplified Chinese oneworld enduser system user ID's supposed to all be CCSID 37?
What is my Data Dictionary supposed to be generated at - I presume CCSID935 - but I'm unsure given the shared English/Japan one being at CCSID65535 !
Could someone who has Simplified Chinese on an AS/400 please look and see if our setup is right ?