$ ISQL-u username-P Password
1> sp_helpdb
2> go
List all databases
1> Use afcdb
2> go
Open a library
1> sp_help
2> go
All tables in the column Library
1> sp_help db01
2> go
View the definition of a table
1> select count (*) from db01
2> go
Execute an SQL statement
1> Create Table tmptable (
2> ID int,
3> name char (128 ))
4> go
A table named tmptable is created.
1> insert into tmptable values (1, 'Robert is a pig! ')
2> go
(1 row affected)
Insert a data entry
1> select * From tmptable
2> go
ID
Name
----
-------------------------------------------
1
Robert is a pig!
(1 row affected)
Query
1> quit
Exit
ISQL [-B] [-E] [-F] [-p] [-N] [-V] [-x] [-y]
[-A display_charset] [-A packet_size] [-C cmdend] [-D database]
[-E editor [-H header [-H hostname [-I inputfile]
[-I interfaces_file] [-J client_charset] [-K keytab_file]
[-L login_timeout] [-M errorlevel] [-M labelname labelvalue]
[-O outputfile] [-P Password] [-r remote_server_principal]
[-S col_separator] [-s SERVER_NAME] [-T timeout] [-u username]
[-V [security_options] [-W column_width] [-Z localename]
[-Z security_mechanic]