All examples of SQL syntax published by Sybase use “go” as the command batch terminator. Can I use a different terminator?
Yes. The command option -c string on UNIX, Windows NT, Windows 95, DOS, or OS/2 platforms and qualifier /TERMINATOR=string on OpenVMS specifies the string to be used by isql instead of “go”. For example, to use a period (“.”) as the command terminator, invoke isql on UNIX or PC platforms as follows: isql -c. A sample isql session with this command terminator looks like this: 1> select name from sysusers 2> . name ———– sandy kim leslie (3 rows affected) See the Adaptive Server Enterprise Utility Programs manual for your platform for a description of the -c option of isql. Keep the following points in mind when dealing with the isql command terminator: • Sybase-supplied scripts and stored procedures always use “go.” • If your own scripts use “go” or another command terminator, you must edit your scripts accordingly. • Make sure that the selected command terminator does not allow “partial commands.” For example, if you make a carriage return the command terminator, you could accide
Related Questions
- After running Recovery for Sybase on the corrupted database, a folder with sql script(s) and batch file has been created. How could these files be transfigured into a new database?
- How do I determine the number of users that exist in the database for each CSUnix server? What SQL command syntax do I need to use?
- Why do I sometimes get different results when executing menu options from a batch file and a command line?
