FreddyFrancis
Well Known Member
Hi List,
There is a strange problem thats occuring .
When a generate table (F55TEST1)command is given it generates the table and indices on the database.
however the indices are created as F55TEST1_1,F55TE00001,F55TE00002 and F55TE00003
the sqls generated being
CREATE UNIQUE INDEX PRODDTAPM/F55TES53_1 ON PRODDTAPM/F55TES53 (SDOBNM ASC, SDVERS ASC, SDUKID ASC)
CREATE INDEX PRODDTAPM/F55TEST1_10 ON PRODDTAPM/F55TES53 (SDOBNM ASC, SDVERS ASC, SDSEQ ASC)
CREATE INDEX PRODDTAPM/F55TEST1_11 ON PRODDTAPM/F55TES53 (SDOBNM ASC, SDVERS ASC, SDSDB ASC, SDTYDT ASC, SDLNID ASC, SDSEQ ASC)
CREATE INDEX PRODDTAPM/F55TEST1_12 ON PRODDTAPM/F55TES53 (SDOBNM ASC, SDVERS ASC, SD55ZSDBCR ASC, SDTYDT ASC, SDLNID ASC, SDSEQ ASC)
this is happening 3 different tables.
This is creating problems since it just wudnt work fine in the applications when the table is being called.
Ideally it should get it created as F55TEST1_1, F55TEST1_2,F55TEST1_3 and F55TEST1_4
why is JDE choosing to create _10,_11 and _12 index rather than _2,_3,_4 through sql statements.
This is with DB2/400 as database with ent svr on As400 . Since the tables and indices are getting created, i am sure that the authorities given are fine too .
any help would be appreciated.. (XE, SP23 , As400)
thanks
There is a strange problem thats occuring .
When a generate table (F55TEST1)command is given it generates the table and indices on the database.
however the indices are created as F55TEST1_1,F55TE00001,F55TE00002 and F55TE00003
the sqls generated being
CREATE UNIQUE INDEX PRODDTAPM/F55TES53_1 ON PRODDTAPM/F55TES53 (SDOBNM ASC, SDVERS ASC, SDUKID ASC)
CREATE INDEX PRODDTAPM/F55TEST1_10 ON PRODDTAPM/F55TES53 (SDOBNM ASC, SDVERS ASC, SDSEQ ASC)
CREATE INDEX PRODDTAPM/F55TEST1_11 ON PRODDTAPM/F55TES53 (SDOBNM ASC, SDVERS ASC, SDSDB ASC, SDTYDT ASC, SDLNID ASC, SDSEQ ASC)
CREATE INDEX PRODDTAPM/F55TEST1_12 ON PRODDTAPM/F55TES53 (SDOBNM ASC, SDVERS ASC, SD55ZSDBCR ASC, SDTYDT ASC, SDLNID ASC, SDSEQ ASC)
this is happening 3 different tables.
This is creating problems since it just wudnt work fine in the applications when the table is being called.
Ideally it should get it created as F55TEST1_1, F55TEST1_2,F55TEST1_3 and F55TEST1_4
why is JDE choosing to create _10,_11 and _12 index rather than _2,_3,_4 through sql statements.
This is with DB2/400 as database with ent svr on As400 . Since the tables and indices are getting created, i am sure that the authorities given are fine too .
any help would be appreciated.. (XE, SP23 , As400)
thanks