Symptom
Currently, we have 2 types reserved words, "Transact-SQL Reserved Words" and "ANSI SQL Reserved Words".
However, spt_values has words in the list of "Transact-SQL Reserved Words" as the manual describes.
The sp_checkreswords displays identifiers that are Transact-SQL reserved words.
Therefore, for example, "column" is listed in "ANSI SQL Reserved Words" and it is not checked and reported by sp_checkreswords.
Then logged a new feature request to extend the system stored procedure 'sp_checkreswords' or create a new system procedure to check and report both Transaction-SQL and ANSI SQL reserved words.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.x
Product
Keywords
sp_checkreswords, reserved words, spt_values, Transact-SQL, T-SQL, ANSI , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.