AS/400 create table reserved column name

165 pts.
Tags:
AS/400
We have an SQL "reserved" word in 90% of our tables. When we were on V5R4, and would run the create table, (strqm, option 3, then to copy the PF to a collection via create table), that reserved word would automatically be double-quoted, so that the create table would work no problem. now, we are on v7r1, and there are no auto-double quotes, and I can't find any parameter or setting that would help with this. all of our systems are now on v7r1, so I can't go back and look for a setting (etc). Anyone have any advice?


Software/Hardware used:
as/400
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • pdraebel
    Would an SQL exit program have done the trick?
    7,545 pointsBadges:
    report
  • philpl1jb

    We have a table with a column name that is an SQL reserve word.

    For all of our needs we have found that we can address the table by

    1.  Enclosing the field name in "FIELDNAME" double quotes

    2.  Capitalizing the field name


    54,090 pointsBadges:
    report
  • philpl1jb

    Should read more and answer less.

    I would do a dos crtdupobj to create the object

    or a create table .. listing the fields and reserved fields in "CAPS"

     and then an

    Insert to load the data. 

    ps .. navigator will write the SQL for the create table for you if you have an existing table.

    54,090 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: