Kieran
Active Member
Hi all
I've noticed that when I generate indexes on a table from OMW that the indexes go into the JDE schema (probably because I am signed on as JDE) rather that the same schema as the table.
I've noticed this in a few Oracle DB sites and I wonder if it is something missing from the F986115 table.
When I run it with debug on I can't see any thing and I get the following statement (i'm trying to generate the F91300 table into the SUK7334 schema)
CREATE UNIQUE INDEX F91300_0 ON SUK7334.F91300 (SJSCHJBNM ASC) tablespace suk7334i
If I change it to this, then it puts the index in the correct schema.
CREATE UNIQUE INDEX SUK7334.F91300_0 ON SUK7334.F91300 (SJSCHJBNM ASC) tablespace suk7334i
I could try siging on as the schema user that I'm generating into or modify the SQL statements to include the schema name, but that is a pain.
Any suggestions on how to make this work from Oneworld?
Thanks
kieran
I've noticed that when I generate indexes on a table from OMW that the indexes go into the JDE schema (probably because I am signed on as JDE) rather that the same schema as the table.
I've noticed this in a few Oracle DB sites and I wonder if it is something missing from the F986115 table.
When I run it with debug on I can't see any thing and I get the following statement (i'm trying to generate the F91300 table into the SUK7334 schema)
CREATE UNIQUE INDEX F91300_0 ON SUK7334.F91300 (SJSCHJBNM ASC) tablespace suk7334i
If I change it to this, then it puts the index in the correct schema.
CREATE UNIQUE INDEX SUK7334.F91300_0 ON SUK7334.F91300 (SJSCHJBNM ASC) tablespace suk7334i
I could try siging on as the schema user that I'm generating into or modify the SQL statements to include the schema name, but that is a pain.
Any suggestions on how to make this work from Oneworld?
Thanks
kieran