Question Re: Some basic commands in isql in Technology Q&A

Some basic commands in isql

Former Member — Thu, 22 Mar 2012 06:24:27 GMT

Hi All,

One can use the command line or else one can use dbisql which is GUI based.

Once we have logged into isql then how to query tables in our database.

1> use SID

2> go

1> select top 1 * from SAPSR3.USR02

Suppose by mistake we had typed incorrectly then we can use "reset" to reset the command prompt.

go is like ; in oracle. we need to manually type after every statement.

This is a sample output from isql.

Re: Some basic commands in isql

Former Member — Tue, 10 Apr 2012 05:14:25 GMT

yeah you are correct !!

You cane run following basic command after login in Sybase ASE

1.@@version : Version of ASE Data Server

2. @@boottime : The time when it was started.

3. @@servername : ASE Server name

4. getdate() : For Current Date

5. db_name(): for Current Database Name

6. @@error : for checking the status of last executed command/sql

1> select @@version

2> go

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Adaptive Server Enterprise/15.7.0/EBF 19497 SMP /P/Sun_svr4/OS 5.10/ase157/2820

/64-bit/FBO/Fri Sep 16 05:21:18 2011

(1 row affected)

1> select @@servername,getdate()

2> go

------------------------------ -------------------------------

SYB_NEW_157 Apr 10 2012 11:09AM

(1 row affected)

1> select @@error

2> go

-----------

(1 row affected)

1> select @@trancount

2> go

-----------

(1 row affected)

1> select @@spid

2> go

------

(1 row affected)

1> select @@boottime

2> go

-------------------------------

Mar 5 2012 1:58PM

(1 row affected)

1> select db_name()

2> go

------------------------------

master

(1 row affected)

Re: Some basic commands in isql

Former Member — Thu, 10 May 2012 17:46:54 GMT

I would like to mention the importance of "go" here apart from sentence completion is that it is used for batch processing also i.e. "go" can be used to club the SQL statements for one shot processing in a single script.

select * from tbl1

select * from tbl2

select * from tbl3

select * from tbl4

Re: Some basic commands in isql

SybDBA — Tue, 05 Jul 2016 09:35:26 GMT

Hi SybAnva,

These are so basic , so that even I also know

Global Variable	Description
select @@bootcount	number of times server restarted since installation.
select @@boottime	date and time when server was last booted.
select @@dbts	timestamp of current database.
select @@error	most recently generated error number by system.
select @@errorlog	path of ase dataserver error log.
select @@heapmemsize	size of heap memory pool in bytes.
select @@identity	most recently generated identity column values.
select @@isolation	session specific isolation level.
select @@kernelmode	kernel mode.
select @@lastlogindate	last login date and time of user.
select @@maxpagesize	server’s logical page size.
select @@nestlevel	current nesting level
select @@optgoal	current optimization goal setting.
select @@pagesize	server’s virtual page size.
select @@parallel_degree	current max parallel degree setting.
select @@rowcount	number of rows affected by last query.
select @@scan_parallel_degree	number of parallel degree for nonclustred index scan.
select @@servername	server name.
select @@setrowcount	current session set rowcount setting
select @@spid	spid of current session.
select @@sqlstatus	status of fetch command.
select @@tempdbid	temporary database id of the session.
select @@thresh_hysteresis	decrease in free space to activate threshold.
select @@timeticks	number of microseconds per tick.
select @@total_read	total disk read
select @@total_write	total disk write.
select @@tranchained	current session transaction mode (0- unchained 1- chained )
select @@trancount	transaction nesting level of current session.
select @@transtate	current state of transaction.
select @@version	version of ase server.
select @@version_as_integer	base version as number
select @@version_number	version as a number.

Thanks

pankaj

Re: Some basic commands in isql

Johan_sapbasis — Tue, 05 Jul 2016 10:05:35 GMT

remember with sybase to use the go command for commands in the database.