SAP Knowledge Base Article - Preview

2028975 - How to refer to online help of T-SQL and OS command from isql - SAP ASE

Symptom

You can refer to the online help of T-SQL and OS command by using a sp_syntax stored procedure.
To use this feature, you must create a sybsyntax database using ins_syn_sql script(UNIX) / inssynsq(Windows).

1> sp_syntax "disk init"
2> go
 Syntax Help

 ------------------------------------------------------------------------------
 Transact-SQL
 disk init - Makes a physical device or file usable by Adaptive Server.
   disk init
      name = "device_name" ,
      physname = "physicalname" ,
      [vdevno = virtual device number],
      size = size of device
      [, vstart = virtual address
          , cntrltype = controller_number ]
      [, dsync = {true|false}]

(return status = 0)

1> sp_syntax
2> go
Msg 17970, Level 16, State 1:
Server 'yk1570', Procedure 'sp_syntax', Line 74:
sp_syntax provides syntax help for Sybase products.
Msg 17971, Level 16, State 1:
Server 'yk1570', Procedure 'sp_syntax', Line 78:
These modules are installed on this Server:

 Module
 --------------------
 dbcc Procedure
 ESP
 System Procedure
 Transact-SQL
 UNIX Utility
 Windows NT Utility

Msg 17972, Level 16, State 1:
Server 'yk1570', Procedure 'sp_syntax', Line 85:
Usage: sp_syntax command [, module [, language]]
(return status = 0) 


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) - All versions

Product

SAP Adaptive Server Enterprise SDK 16.0 ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5 ; Sybase Software Developer Kit 15.7

Keywords

CR, 765533 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-SDK , SDK , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.