Objective: to migrate the system from Oracle to Sybase.
Command Overview:
C: \ Documents ents and Settings \ newuesr> isql-help
Syntax Error in '-help '.
Usage: isql [-B] [-e] [-F] [-p] [-n] [-v] [-X] [-Y] [-Q]
[-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]
Log on to the database with the specified IP Address:
Isql-H 192.168.3.143-U sa-P zfvims-D zfv-S newuser
C: \ Documents ents and Settings \ newuesr> isql-H 192.168.3.143-U sa-P zfvims-D zfv-S newuser
Create a table and perform the test:
1> create table test (mom varchar (20 ))
2> insert into test values ('aaa ')
3> insert into test values ('bbb ')
4> insert into test values ('ccc ')
5> select * from test
6> go
(1 row affected)
(1 row affected)
(1 row affected)
Mom
--------------------
Aaa
Bbb
Ccc
(3 rows affected)
1>