New Reserved Words

Reserved words, or ASE keywords, can only be used by ASE and cannot be used to name user-created objects. New ASE objects and commands result in new reserved words being added with every release. The following chart shows the keywords added in ASE 11.9.2, 12.0, and 12.5:

Release

New reserved words

11.9.2

  • exp_row_size

  • reservepagegap

  • lock

  • readpast

  • reorg

12.0

  • proxy

  • proxy_table

  • key

  • jar

  • join

  • install

  • remove

  • identity_gap

  • quiesce

  • modify

12.5

  • deterministic

  • func

  • function

  • inout

  • new

  • out

  • output

  • stringsize

You must change all object names that contain reserved words before you upgrade. You must also change those names in your procedures, SQL scripts, and applications before you can run them against the upgraded server.

Use the reserved word check in sqlupgrade, which you can run without starting the upgrade, to check object names. Subsequent checks can be performed by running the stored procedure, sp_checkreswords. Names that contain reserved words can be changed with the sp_rename procedure, or can be enclosed in double quotes. See the discussion on reserved words in your installation guide.

NoteThe Sybase procedures for detecting reserved words in object names cannot be used to find them in scripts and applications. You need to check scripts and applications separately.