Generate index

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
 
Leafs :

Have you applied the pre and post installation instructions?
For example, on the JD14838 Planner ESU you had to run R98403 UBE to
copy some specifical Data Dictionary Items from the ESU Access tables
to the Planner Environment.
These DD items were necessary to create F9676* tables.

Sebastian Sajaroff
B7321 to Xe, NT, W2K, SQL, Citrix

Note for JDELIST administrators : I've noticed that when I click
'Reply' it will send my answer to the individual, not to the jdelist.
Is it a new feature? By the way, I'm writing this text from a Web Mail.
 
Back
Top