Brad Thomas wrote: > > Hi all > > I've looked in the documentation (and found the reserved key > word list - > thank you - \e0\ed9036dfe4b903e10000009b38f889\frameset.htm) > and in the > archives, and I'm sure they exist in a table somewhere > because I saw dbmcli > output a message saying "loading reserved words" (or similar) > during the > creation of the database but do you think I can find that > list of reserved > key words under either the dba, sys, or domain users? > > Could some kind soul tell me which "user"."table" holds the > list of reserved > words? I think I found it, but I'm not sure - is it: > "dba"."sys_myautosuppose" ?? > > Or is there another? That table has sql statements in it too..... > > The reason is I'm trying to do a migration from Access97 to SAP > automagically - if I know what the list of reserved words > are, I can check > them against the table and column names in the Access97 DB, > and if they > are the same, add some extra set of chars so that the create > table statement doesn't fail.
The table you mentioned is not the exact list of known/reserved keywords in the kernel. The table is prepared by hand and is used by SQLStudio to allow people just to type the first x characters of a keyword or phrase then using tab or so and SQLStudio will fill up this keyword/phrase according to this table you mentioned. To assure that you uses the correct list of known / reserved keywords (and because it is perhaps easier to prepare them of these than to prepare them out of the docs) I send two lists with this mail. <<reserved_keywords>> <<known_keywords>> Elke SAP Labs Berlin
reserved_keywords
Description: Binary data
known_keywords
Description: Binary data
