G
gtkchen
Guest
Hi, Thanks for the reply. 1.CCSID is EBCDIC 2.Trace File
just a connection and a query which throws the exception) Assembly Name: DDTek.DB2, Version=4.1.0.0, Culture=neutral, PublicKeyToken=c84cd5c63851e072 Assembly File Version: 4.1.0.010202 00000001 08:44:54.857 T1 I26966483 Connection::Open ENTER ConnectionString: Host=10.232.19.209;Port=9500;User ID=MRE0222;Password=*****;Database=DJ50;CharsetFor65535=0;Enable trace=1;Trace File=E:\TraceFile.txt ConnectionTimeout: 15 POOL: Found a pooled connection POOL: Current status: 1 pools, 0 connections 00000002 08:44:54.953 T1 I61150033 Command::ExecuteReader ENTER Arg #1: "CommandBehavior.Default" CommandText: SELECT COUNT(*) FROM SYSIBM.SYSPACKSTMT WHERE NAME ='DDAC320A' and COLLID = 'NULLID' AND LOCATION = '' AND (SEQNO 0 OR STMTNO 0 OR SECTNO 0) CommandType: Text CommandTimeout: 15 UpdatedRowSource: Both 00000002 08:44:54.998 T1 I61150033 Command::ExecuteReader EXIT Return: DDTek.DB2.DB2DataReader RecordsAffected: -1 00000003 08:44:54.998 T1 I54234833 DataReader::Read ENTER 00000003 08:44:54.999 T1 I54234833 DataReader::Read EXIT Out #1: "NumRowsRead = 1" Return: True 00000004 08:44:54.999 T1 I54234833 DataReader::GetInt32 ENTER Arg #1: 0 00000004 08:44:54.999 T1 I54234833 DataReader::GetInt32 EXIT Return: 200 00000005 08:44:54.999 T1 I54234833 DataReader::Close ENTER 00000005 08:44:55.011 T1 I54234833 DataReader::Close EXIT 00000001 08:44:55.011 T1 I26966483 Connection::Open EXIT 00000006 08:44:55.011 T1 I9035653 Command::ExecuteReader ENTER Arg #1: "CommandBehavior.SequentialAccess" CommandText: select * from sysa.ar_ar_51 where COD_FN_ENT = '0103' and NUM_SEQ_AR = '02024351200000006' with ur; CommandType: Text CommandTimeout: 30 UpdatedRowSource: Both Error Generated by DB2 Provider: Message = SQL0098W: A dynamic SQL statement ends with a semicolon. a: System.InvalidOperationException Message: Transliteration table not found: IBM-1388_P110-2000 Source: Stack Trace 在 DDInt.Common.a1.a(Exception , a ) 在 DDInt.Common.a1.c(Exception ) 在 DDTek.DB2.DB2Exception.a(String ) 在 DDTek.DB2.DRDA.b.bw() 在 DDTek.DB2.DRDA.c.bw() 在 DDTek.DB2.DB2Command.a(CommandBehavior , Boolean ) 在 DDTek.DB2.DB2Command.ExecuteReader(CommandBehavior behavior) 在 DDTek.DB2.DB2Command.ExecuteDbDataReader(CommandBehavior behavior) 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) 在 TestADOnet.Form1.button_connect_Click(Object sender, EventArgs e) 在 System.Windows.Forms.Control.OnClick(EventArgs e) 在 System.Windows.Forms.Button.OnClick(EventArgs e) 在 System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) 在 System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) 在 System.Windows.Forms.Control.WndProc(Message& m) 在 System.Windows.Forms.ButtonBase.WndProc(Message& m) 在 System.Windows.Forms.Button.WndProc(Message& m) 在 System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) 在 System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) 在 System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) 在 System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) 在 System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData) 在 System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) 在 System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) 在 System.Windows.Forms.Application.Run(Form mainForm) 在 TestADOnet.Program.Main() 在 System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args) 在 System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args) 在 Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() 在 System.Threading.ThreadHelper.ThreadStart_Context(Object state) 在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) 在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) 在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) 在 System.Threading.ThreadHelper.ThreadStart() 00000006 08:44:55.078 T1 I9035653 Command::ExecuteReader EXIT --*********************************************************************************************************** 3.CREATE TABLE Query: CREATE TABLESPACE TARAR50 IN DBOEAR1 USING STOGROUP SSMSBOED PRIQTY 1440 SECQTY 144000 FREEPAGE 31 PCTFREE 5 GBPCACHE CHANGED TRACKMOD YES LOGGED DSSIZE 32G NUMPARTS 49 BUFFERPOOL BP30 LOCKSIZE ANY LOCKMAX SYSTEM CLOSE YES COMPRESS NO CCSID EBCDIC DEFINE YES MAXROWS 255 ; COMMIT; CREATE TABLE SYSA.AR_AR_50 (COD_FN_ENT CHAR(4) FOR MIXED DATA NOT NULL, NUM_SEQ_AR CHAR(17) FOR MIXED DATA NOT NULL, COD_PRO_COD CHAR(2) FOR MIXED DATA NOT NULL, COD_BRCH_OU CHAR(6) FOR MIXED DATA NOT NULL, NAM_AR CHAR(150) FOR MIXED DATA NOT NULL, COD_ISO_CCY CHAR(3) FOR MIXED DATA NOT NULL, IND_CSH_RMT CHAR(1) FOR MIXED DATA NOT NULL, COD_PD_LINE CHAR(2) FOR MIXED DATA NOT NULL, ID_GRP_PD CHAR(2) FOR MIXED DATA NOT NULL, ID_PD CHAR(4) FOR MIXED DATA NOT NULL, NUM_TARF CHAR(6) FOR MIXED DATA NOT NULL, COD_PD_CLS CHAR(8) FOR MIXED DATA NOT NULL, COD_AR_CHAR CHAR(2) FOR MIXED DATA NOT NULL, COD_AR_ACTG_CLS CHAR(5) FOR MIXED DATA NOT NULL, COD_BUS_BREED CHAR(8) FOR MIXED DATA NOT NULL, COD_AR_SRCE CHAR(1) FOR MIXED DATA NOT NULL, COD_AR_PAY_CTRL CHAR(3) FOR MIXED DATA NOT NULL, TXT_PWD CHAR(8) FOR MIXED DATA NOT NULL, COD_UNVS_DP_RGE CHAR(2) FOR MIXED DATA NOT NULL, COD_UNVS_WTHD_RGE CHAR(2) FOR MIXED DATA NOT NULL, IND_RES CHAR(1) FOR MIXED DATA NOT NULL, COD_LCS_AR CHAR(2) FOR MIXED DATA NOT NULL, COD_RSN_LCS_AR CHAR(4) FOR MIXED DATA NOT NULL, DATE_STRT_LCS CHAR(8) FOR MIXED DATA NOT NULL, DATE_REG_AR CHAR(8) FOR MIXED DATA NOT NULL, DATE_REG_LCS CHAR(8) FOR MIXED DATA NOT NULL, DATE_VLU_STRT CHAR(8) FOR MIXED DATA NOT NULL, DATE_MATU CHAR(8) FOR MIXED DATA NOT NULL, NUM_SEQ_SUBAR_CUR DECIMAL(10,0) NOT NULL, COD_MSK_AR_1 CHAR(100) FOR MIXED DATA NOT NULL, COD_MSK_AR_2 CHAR(100) FOR MIXED DATA NOT NULL, COD_CHANL CHAR(4) FOR MIXED DATA NOT NULL, CNT_AR_SP SMALLINT NOT NULL, VLU_AR_SP CHAR(240) FOR MIXED DATA NOT NULL, ID_INTL_IP CHAR(16) FOR MIXED DATA NOT NULL, COD_IP_CLS CHAR(8) FOR MIXED DATA NOT NULL, ID_MAGR_CUST CHAR(16) FOR MIXED DATA NOT NULL, ID_MAGR_PD CHAR(16) FOR MIXED DATA NOT NULL, NUM_ENCR_ARIT SMALLINT NOT NULL, TXT_REM_1 CHAR(50) FOR MIXED DATA NOT NULL, TXT_REM_2 CHAR(50) FOR MIXED DATA NOT NULL, TXT_REM_3 CHAR(50) FOR MIXED DATA NOT NULL, TXT_REM_4 CHAR(50) FOR MIXED DATA NOT NULL, TXT_REM_5 CHAR(50) FOR MIXED DATA NOT NULL, CONSTRAINT PK_AR_AR_50 PRIMARY KEY (COD_FN_ENT, NUM_SEQ_AR)) IN DBOEAR1.TARAR50 PARTITION BY (COD_FN_ENT ASC, NUM_SEQ_AR ASC) (PART 1 VALUES('0103','01999999999999999'), PART 2 VALUES('0103','02999999999999999'), PART 3 VALUES('0103','03999999999999999'), PART 4 VALUES('0103','04999999999999999'), PART 5 VALUES('0103','05999999999999999'), PART 6 VALUES('0103','06999999999999999'), PART 7 VALUES('0103','07999999999999999'), PART 8 VALUES('0103','08999999999999999'), PART 9 VALUES('0103','09999999999999999'), PART 10 VALUES('0103','10999999999999999'), PART 11 VALUES('0103','11999999999999999'), PART 12 VALUES('0103','12999999999999999'), PART 13 VALUES('0103','13999999999999999'), PART 14 VALUES('0103','14999999999999999'), PART 15 VALUES('0103','15999999999999999'), PART 16 VALUES('0103','16999999999999999'), PART 17 VALUES('0103','17999999999999999'), PART 18 VALUES('0103','18999999999999999'), PART 19 VALUES('0103','19999999999999999'), PART 20 VALUES('0103','20999999999999999'), PART 21 VALUES('0103','21999999999999999'), PART 22 VALUES('0103','22999999999999999'), PART 23 VALUES('0103','23999999999999999'), PART 24 VALUES('0103','24999999999999999'), PART 25 VALUES('0103','25999999999999999'), PART 26 VALUES('0103','26999999999999999'), PART 27 VALUES('0103','27999999999999999'), PART 28 VALUES('0103','28999999999999999'), PART 29 VALUES('0103','29999999999999999'), PART 30 VALUES('0103','30999999999999999'), PART 31 VALUES('0103','31999999999999999'), PART 32 VALUES('0103','32999999999999999'), PART 33 VALUES('0103','33999999999999999'), PART 34 VALUES('0103','34999999999999999'), PART 35 VALUES('0103','38999999999999999'), PART 36 VALUES('0103','39999999999999999'), PART 37 VALUES('0103','40999999999999999'), PART 38 VALUES('0103','41999999999999999'), PART 39 VALUES('0103','44999999999999999'), PART 40 VALUES('0103','45999999999999999'), PART 41 VALUES('0103','50999999999999999'), PART 42 VALUES('0103','71999999999999999'), PART 43 VALUES('0103','80999999999999999'), PART 44 VALUES('0103','81999999999999999'), PART 45 VALUES('0103','82999999999999999'), PART 46 VALUES('0103','83999999999999999'), PART 47 VALUES('0103','84999999999999999'), PART 48 VALUES('0103','97999999999999999'), PART 49 VALUES('0103','99999999999999999')) AUDIT NONE DATA CAPTURE NONE CCSID EBCDIC NOT VOLATILE APPEND NO; COMMIT; CREATE UNIQUE INDEX SYSA.XARAR50P ON SYSA.AR_AR_50 (COD_FN_ENT ASC, NUM_SEQ_AR ASC ) PARTITIONED USING STOGROUP SSMSBOED PRIQTY 720 SECQTY 72000 FREEPAGE 7 PCTFREE 5 GBPCACHE CHANGED CLUSTER COMPRESS NO (PART 1, PART 2, PART 3, PART 4, PART 5, PART 6, PART 7, PART 8, PART 9, PART 10, PART 11, PART 12, PART 13, PART 14, PART 15, PART 16, PART 17, PART 18, PART 19, PART 20, PART 21, PART 22, PART 23, PART 24, PART 25, PART 26, PART 27, PART 28, PART 29, PART 30, PART 31, PART 32, PART 33, PART 34, PART 35, PART 36, PART 37, PART 38, PART 39, PART 40, PART 41, PART 42, PART 43, PART 44, PART 45, PART 46, PART 47, PART 48, PART 49) BUFFERPOOL BP31 CLOSE YES COPY NO DEFER NO DEFINE YES ; COMMIT; CREATE INDEX SYSA.XARAR50A ON SYSA.AR_AR_50 (COD_FN_ENT ASC, COD_BRCH_OU ASC, NUM_SEQ_AR ASC) USING STOGROUP SSMSBOED PRIQTY 720 SECQTY 72000 ERASE NO FREEPAGE 7 PCTFREE 5 GBPCACHE CHANGED NOT CLUSTER COMPRESS NO BUFFERPOOL BP31 CLOSE YES COPY NO DEFER NO DEFINE YES PIECESIZE 16G ; COMMIT; --*********************************************************************************************************** most of time,the ADO.net works well, if the value of column NAM_AR like this (hex) 0E56F94F964CD46C894B7C5D9956745A73625B4D65565F58B158B158B158B158B158B158B158B158B158B158B158B158B158B158B158B158B158B158B14040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040 then the query throw the exception : Transliteration table not found: IBM-1388_P110-2000
Continue reading...
just a connection and a query which throws the exception) Assembly Name: DDTek.DB2, Version=4.1.0.0, Culture=neutral, PublicKeyToken=c84cd5c63851e072 Assembly File Version: 4.1.0.010202 00000001 08:44:54.857 T1 I26966483 Connection::Open ENTER ConnectionString: Host=10.232.19.209;Port=9500;User ID=MRE0222;Password=*****;Database=DJ50;CharsetFor65535=0;Enable trace=1;Trace File=E:\TraceFile.txt ConnectionTimeout: 15 POOL: Found a pooled connection POOL: Current status: 1 pools, 0 connections 00000002 08:44:54.953 T1 I61150033 Command::ExecuteReader ENTER Arg #1: "CommandBehavior.Default" CommandText: SELECT COUNT(*) FROM SYSIBM.SYSPACKSTMT WHERE NAME ='DDAC320A' and COLLID = 'NULLID' AND LOCATION = '' AND (SEQNO 0 OR STMTNO 0 OR SECTNO 0) CommandType: Text CommandTimeout: 15 UpdatedRowSource: Both 00000002 08:44:54.998 T1 I61150033 Command::ExecuteReader EXIT Return: DDTek.DB2.DB2DataReader RecordsAffected: -1 00000003 08:44:54.998 T1 I54234833 DataReader::Read ENTER 00000003 08:44:54.999 T1 I54234833 DataReader::Read EXIT Out #1: "NumRowsRead = 1" Return: True 00000004 08:44:54.999 T1 I54234833 DataReader::GetInt32 ENTER Arg #1: 0 00000004 08:44:54.999 T1 I54234833 DataReader::GetInt32 EXIT Return: 200 00000005 08:44:54.999 T1 I54234833 DataReader::Close ENTER 00000005 08:44:55.011 T1 I54234833 DataReader::Close EXIT 00000001 08:44:55.011 T1 I26966483 Connection::Open EXIT 00000006 08:44:55.011 T1 I9035653 Command::ExecuteReader ENTER Arg #1: "CommandBehavior.SequentialAccess" CommandText: select * from sysa.ar_ar_51 where COD_FN_ENT = '0103' and NUM_SEQ_AR = '02024351200000006' with ur; CommandType: Text CommandTimeout: 30 UpdatedRowSource: Both Error Generated by DB2 Provider: Message = SQL0098W: A dynamic SQL statement ends with a semicolon. a: System.InvalidOperationException Message: Transliteration table not found: IBM-1388_P110-2000 Source: Stack Trace 在 DDInt.Common.a1.a(Exception , a ) 在 DDInt.Common.a1.c(Exception ) 在 DDTek.DB2.DB2Exception.a(String ) 在 DDTek.DB2.DRDA.b.bw() 在 DDTek.DB2.DRDA.c.bw() 在 DDTek.DB2.DB2Command.a(CommandBehavior , Boolean ) 在 DDTek.DB2.DB2Command.ExecuteReader(CommandBehavior behavior) 在 DDTek.DB2.DB2Command.ExecuteDbDataReader(CommandBehavior behavior) 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) 在 TestADOnet.Form1.button_connect_Click(Object sender, EventArgs e) 在 System.Windows.Forms.Control.OnClick(EventArgs e) 在 System.Windows.Forms.Button.OnClick(EventArgs e) 在 System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) 在 System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) 在 System.Windows.Forms.Control.WndProc(Message& m) 在 System.Windows.Forms.ButtonBase.WndProc(Message& m) 在 System.Windows.Forms.Button.WndProc(Message& m) 在 System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) 在 System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) 在 System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) 在 System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) 在 System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData) 在 System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) 在 System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) 在 System.Windows.Forms.Application.Run(Form mainForm) 在 TestADOnet.Program.Main() 在 System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args) 在 System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args) 在 Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() 在 System.Threading.ThreadHelper.ThreadStart_Context(Object state) 在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) 在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) 在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) 在 System.Threading.ThreadHelper.ThreadStart() 00000006 08:44:55.078 T1 I9035653 Command::ExecuteReader EXIT --*********************************************************************************************************** 3.CREATE TABLE Query: CREATE TABLESPACE TARAR50 IN DBOEAR1 USING STOGROUP SSMSBOED PRIQTY 1440 SECQTY 144000 FREEPAGE 31 PCTFREE 5 GBPCACHE CHANGED TRACKMOD YES LOGGED DSSIZE 32G NUMPARTS 49 BUFFERPOOL BP30 LOCKSIZE ANY LOCKMAX SYSTEM CLOSE YES COMPRESS NO CCSID EBCDIC DEFINE YES MAXROWS 255 ; COMMIT; CREATE TABLE SYSA.AR_AR_50 (COD_FN_ENT CHAR(4) FOR MIXED DATA NOT NULL, NUM_SEQ_AR CHAR(17) FOR MIXED DATA NOT NULL, COD_PRO_COD CHAR(2) FOR MIXED DATA NOT NULL, COD_BRCH_OU CHAR(6) FOR MIXED DATA NOT NULL, NAM_AR CHAR(150) FOR MIXED DATA NOT NULL, COD_ISO_CCY CHAR(3) FOR MIXED DATA NOT NULL, IND_CSH_RMT CHAR(1) FOR MIXED DATA NOT NULL, COD_PD_LINE CHAR(2) FOR MIXED DATA NOT NULL, ID_GRP_PD CHAR(2) FOR MIXED DATA NOT NULL, ID_PD CHAR(4) FOR MIXED DATA NOT NULL, NUM_TARF CHAR(6) FOR MIXED DATA NOT NULL, COD_PD_CLS CHAR(8) FOR MIXED DATA NOT NULL, COD_AR_CHAR CHAR(2) FOR MIXED DATA NOT NULL, COD_AR_ACTG_CLS CHAR(5) FOR MIXED DATA NOT NULL, COD_BUS_BREED CHAR(8) FOR MIXED DATA NOT NULL, COD_AR_SRCE CHAR(1) FOR MIXED DATA NOT NULL, COD_AR_PAY_CTRL CHAR(3) FOR MIXED DATA NOT NULL, TXT_PWD CHAR(8) FOR MIXED DATA NOT NULL, COD_UNVS_DP_RGE CHAR(2) FOR MIXED DATA NOT NULL, COD_UNVS_WTHD_RGE CHAR(2) FOR MIXED DATA NOT NULL, IND_RES CHAR(1) FOR MIXED DATA NOT NULL, COD_LCS_AR CHAR(2) FOR MIXED DATA NOT NULL, COD_RSN_LCS_AR CHAR(4) FOR MIXED DATA NOT NULL, DATE_STRT_LCS CHAR(8) FOR MIXED DATA NOT NULL, DATE_REG_AR CHAR(8) FOR MIXED DATA NOT NULL, DATE_REG_LCS CHAR(8) FOR MIXED DATA NOT NULL, DATE_VLU_STRT CHAR(8) FOR MIXED DATA NOT NULL, DATE_MATU CHAR(8) FOR MIXED DATA NOT NULL, NUM_SEQ_SUBAR_CUR DECIMAL(10,0) NOT NULL, COD_MSK_AR_1 CHAR(100) FOR MIXED DATA NOT NULL, COD_MSK_AR_2 CHAR(100) FOR MIXED DATA NOT NULL, COD_CHANL CHAR(4) FOR MIXED DATA NOT NULL, CNT_AR_SP SMALLINT NOT NULL, VLU_AR_SP CHAR(240) FOR MIXED DATA NOT NULL, ID_INTL_IP CHAR(16) FOR MIXED DATA NOT NULL, COD_IP_CLS CHAR(8) FOR MIXED DATA NOT NULL, ID_MAGR_CUST CHAR(16) FOR MIXED DATA NOT NULL, ID_MAGR_PD CHAR(16) FOR MIXED DATA NOT NULL, NUM_ENCR_ARIT SMALLINT NOT NULL, TXT_REM_1 CHAR(50) FOR MIXED DATA NOT NULL, TXT_REM_2 CHAR(50) FOR MIXED DATA NOT NULL, TXT_REM_3 CHAR(50) FOR MIXED DATA NOT NULL, TXT_REM_4 CHAR(50) FOR MIXED DATA NOT NULL, TXT_REM_5 CHAR(50) FOR MIXED DATA NOT NULL, CONSTRAINT PK_AR_AR_50 PRIMARY KEY (COD_FN_ENT, NUM_SEQ_AR)) IN DBOEAR1.TARAR50 PARTITION BY (COD_FN_ENT ASC, NUM_SEQ_AR ASC) (PART 1 VALUES('0103','01999999999999999'), PART 2 VALUES('0103','02999999999999999'), PART 3 VALUES('0103','03999999999999999'), PART 4 VALUES('0103','04999999999999999'), PART 5 VALUES('0103','05999999999999999'), PART 6 VALUES('0103','06999999999999999'), PART 7 VALUES('0103','07999999999999999'), PART 8 VALUES('0103','08999999999999999'), PART 9 VALUES('0103','09999999999999999'), PART 10 VALUES('0103','10999999999999999'), PART 11 VALUES('0103','11999999999999999'), PART 12 VALUES('0103','12999999999999999'), PART 13 VALUES('0103','13999999999999999'), PART 14 VALUES('0103','14999999999999999'), PART 15 VALUES('0103','15999999999999999'), PART 16 VALUES('0103','16999999999999999'), PART 17 VALUES('0103','17999999999999999'), PART 18 VALUES('0103','18999999999999999'), PART 19 VALUES('0103','19999999999999999'), PART 20 VALUES('0103','20999999999999999'), PART 21 VALUES('0103','21999999999999999'), PART 22 VALUES('0103','22999999999999999'), PART 23 VALUES('0103','23999999999999999'), PART 24 VALUES('0103','24999999999999999'), PART 25 VALUES('0103','25999999999999999'), PART 26 VALUES('0103','26999999999999999'), PART 27 VALUES('0103','27999999999999999'), PART 28 VALUES('0103','28999999999999999'), PART 29 VALUES('0103','29999999999999999'), PART 30 VALUES('0103','30999999999999999'), PART 31 VALUES('0103','31999999999999999'), PART 32 VALUES('0103','32999999999999999'), PART 33 VALUES('0103','33999999999999999'), PART 34 VALUES('0103','34999999999999999'), PART 35 VALUES('0103','38999999999999999'), PART 36 VALUES('0103','39999999999999999'), PART 37 VALUES('0103','40999999999999999'), PART 38 VALUES('0103','41999999999999999'), PART 39 VALUES('0103','44999999999999999'), PART 40 VALUES('0103','45999999999999999'), PART 41 VALUES('0103','50999999999999999'), PART 42 VALUES('0103','71999999999999999'), PART 43 VALUES('0103','80999999999999999'), PART 44 VALUES('0103','81999999999999999'), PART 45 VALUES('0103','82999999999999999'), PART 46 VALUES('0103','83999999999999999'), PART 47 VALUES('0103','84999999999999999'), PART 48 VALUES('0103','97999999999999999'), PART 49 VALUES('0103','99999999999999999')) AUDIT NONE DATA CAPTURE NONE CCSID EBCDIC NOT VOLATILE APPEND NO; COMMIT; CREATE UNIQUE INDEX SYSA.XARAR50P ON SYSA.AR_AR_50 (COD_FN_ENT ASC, NUM_SEQ_AR ASC ) PARTITIONED USING STOGROUP SSMSBOED PRIQTY 720 SECQTY 72000 FREEPAGE 7 PCTFREE 5 GBPCACHE CHANGED CLUSTER COMPRESS NO (PART 1, PART 2, PART 3, PART 4, PART 5, PART 6, PART 7, PART 8, PART 9, PART 10, PART 11, PART 12, PART 13, PART 14, PART 15, PART 16, PART 17, PART 18, PART 19, PART 20, PART 21, PART 22, PART 23, PART 24, PART 25, PART 26, PART 27, PART 28, PART 29, PART 30, PART 31, PART 32, PART 33, PART 34, PART 35, PART 36, PART 37, PART 38, PART 39, PART 40, PART 41, PART 42, PART 43, PART 44, PART 45, PART 46, PART 47, PART 48, PART 49) BUFFERPOOL BP31 CLOSE YES COPY NO DEFER NO DEFINE YES ; COMMIT; CREATE INDEX SYSA.XARAR50A ON SYSA.AR_AR_50 (COD_FN_ENT ASC, COD_BRCH_OU ASC, NUM_SEQ_AR ASC) USING STOGROUP SSMSBOED PRIQTY 720 SECQTY 72000 ERASE NO FREEPAGE 7 PCTFREE 5 GBPCACHE CHANGED NOT CLUSTER COMPRESS NO BUFFERPOOL BP31 CLOSE YES COPY NO DEFER NO DEFINE YES PIECESIZE 16G ; COMMIT; --*********************************************************************************************************** most of time,the ADO.net works well, if the value of column NAM_AR like this (hex) 0E56F94F964CD46C894B7C5D9956745A73625B4D65565F58B158B158B158B158B158B158B158B158B158B158B158B158B158B158B158B158B158B158B14040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040 then the query throw the exception : Transliteration table not found: IBM-1388_P110-2000Continue reading...