Leafs
Active Member
special instructions for planner esu (JD16916) require the indexes to be generated for the F96761 table into the planner database.
The indexes are not being generated due to the error's below.
I see that there is an invalid field definition and would imagine this is the problem.
Now if only I knew what the fix was. Any suggestions would be appreciated.
Thank-You.
RS/6000..AIX 7.2..DB2/UDB...xe..SP20...planner esu JD16916
===============================================
ODB0000183 - SQLExecute failed
968/1176 Thu Oct 31 07:55:17 2002 JDBODBC.C2105
[Microsoft][ODBC Microsoft Access Driver] Invalid field definition 'SOCDCID' in definition of index or relationship. - SQLSTATE: S0022
968/1176 Thu Oct 31 07:55:17 2002 jdb_drvm.c920
JDB9900401 - Failed to execute db request
968/1176 Thu Oct 31 07:55:17 2002 jdb_exem.c680
JDB2100018 - Failed to create index 1 for table F96761 in data source OneWorld Local
968/1176 Thu Oct 31 07:55:17 2002 JDBODBC.C2105
ODB0000183 - SQLExecute failed
968/1176 Thu Oct 31 07:55:17 2002 JDBODBC.C2105
[Microsoft][ODBC Microsoft Access Driver] Invalid field definition 'SOCDCID' in definition of index or relationship. - SQLSTATE: S0022
968/1176 Thu Oct 31 07:55:17 2002 jdb_drvm.c920
JDB9900401 - Failed to execute db request
968/1176 Thu Oct 31 07:55:17 2002 jdb_exem.c680
JDB2100018 - Failed to create index 4 for table F96761 in data source OneWorld Local
The indexes are not being generated due to the error's below.
I see that there is an invalid field definition and would imagine this is the problem.
Now if only I knew what the fix was. Any suggestions would be appreciated.
Thank-You.
RS/6000..AIX 7.2..DB2/UDB...xe..SP20...planner esu JD16916
===============================================
ODB0000183 - SQLExecute failed
968/1176 Thu Oct 31 07:55:17 2002 JDBODBC.C2105
[Microsoft][ODBC Microsoft Access Driver] Invalid field definition 'SOCDCID' in definition of index or relationship. - SQLSTATE: S0022
968/1176 Thu Oct 31 07:55:17 2002 jdb_drvm.c920
JDB9900401 - Failed to execute db request
968/1176 Thu Oct 31 07:55:17 2002 jdb_exem.c680
JDB2100018 - Failed to create index 1 for table F96761 in data source OneWorld Local
968/1176 Thu Oct 31 07:55:17 2002 JDBODBC.C2105
ODB0000183 - SQLExecute failed
968/1176 Thu Oct 31 07:55:17 2002 JDBODBC.C2105
[Microsoft][ODBC Microsoft Access Driver] Invalid field definition 'SOCDCID' in definition of index or relationship. - SQLSTATE: S0022
968/1176 Thu Oct 31 07:55:17 2002 jdb_drvm.c920
JDB9900401 - Failed to execute db request
968/1176 Thu Oct 31 07:55:17 2002 jdb_exem.c680
JDB2100018 - Failed to create index 4 for table F96761 in data source OneWorld Local