[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Error using DF utility

  • Thread starter Thread starter gus bjorklund
  • Start date Start date
Status
Not open for further replies.
G

gus bjorklund

Guest
SQL-92 does not have its own list of keywords which are disallowed. The SQL language does not impose any restrictions on what words can be used in table and column names. Instead, SQL has the concept of "delimited identifiers". Whenever you have a name that conflicts with the SQL language, you can enclose it in double quotes. So you can have a table named SELECT and use it thusly: SELECT * FROM "SELECT"; Also, in SQL, hyphens are used differently than in the 4GL. A table or column name such as A-B must be delimited (enclosed in quotes) because the SQL parser will treat is a subtraction, reading it as A - B.

Continue reading...
 
Status
Not open for further replies.
Back
Top