How to Access DB2 SQL Mode

Share this article :

You can access into the DB2 SQL mode as following,

For Windows environment use command, db2cmd
For UNIX, Linux environment use command, db2

Example in UNIX, Linux envinronment,

> db2
(c) Copyright IBM Corporation 1993,2007
Command Line Processor for DB2 Client 9.7.4

You can issue database manager commands and SQL statements from the command
prompt. For example:
    db2 => connect to sample
    db2 => bind sample.bnd

For general help, type: ?.
For command help, type: ? command, where command can be
the first few keywords of a database manager command. For example:
 ? CATALOG DATABASE for help on the CATALOG DATABASE command
 ? CATALOG          for help on all of the CATALOG commands.

To exit db2 interactive mode, type QUIT at the command prompt. Outside
interactive mode, all commands must be prefixed with 'db2'.
To list the current command option settings, type LIST COMMAND OPTIONS.

For more detailed help, refer to the Online Reference Manual.

db2 =>


Related posts

Activate & Deactivate DB2 Database
SQL1116N: Connection to DB2 Failed because Backup Pending
Find Installed Instances in DB2
Get the Lists and Information on DB2 Tablespace
© 2017 ITsiti. All Rights Reserved
Powered by KEEM