New Reserved Words

Reserved words can only be used by ASE. New ASE objects and commands result in new reserved words being added with every release. To see the new reserved words for ASE 12.0, see the Adaptive Server Reference Manual.

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. The following chart shows the keywords added in recent releases:

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

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.