Question

1. What type of commands can you issue through the command line process?

Start-> IBM DB2COPY1 (Default) -> DB2 Command Line Processor

Answer 1

Types of commands can be issued through the command line process:

i) XMLSCHEMA:

a)ADD

adds one or more XML schema documents to an existing.

Ex: ADD XMLSCHEMA DOCUMENT TO MYNAME.TEST

b)COMPLETE

  completes the registration.

  Ex:COMPLETE XMLSCHEMA  relational-identifier

c) REGISTER

registers an XML schema

Ex: REGISTER XMLSCHEMA http://mywebsite.com/prod/a1.xsd FROM file:///u/temp/a1.xsd AS EXAMPLE.TEST1 COMPLETE

d) REMOVE

  deletes a previously registered XML schema.

Ex: REMOVE XMLSCHEMA SYS.PRODSCHEMA

ii) BIND:

binds DBRMs that are in HFS files into a package.

Ex: BIND /u/usr1/myapp.dbrm -collection PKG05 ISOLATION(CS) RELEASE(DEALLOCATE)

iii) CHANGE :

a) ISOLATION

changes the isolation level for SQL statements

Ex: CHANGE ISOLATION TO -RR

b) MAXCOLUMNWIDTH

changes the number of bytes in a table column.

Ex: CHANGE MAXCOLUMNWIDTH TO 10

c) MAXLINESFROMSELECT

changes the number of rows

Ex: CHANGE MAXLINESFROMSELECT TO  5

iv)  COMMIT:

saves all SQL work

Ex: COMMIT

v) ROLLBACK:

rollbacks all saves.

Ex: ROLLBACK

vi) CONNECT:

  connects to a DB2 server

Ex: CONNECT TO url.abc.com:4096/JKL1 USER abc11 USING mypwd123

vii) DESCRIBE:

a) CALL

returns Parameter name,Parameter type,Data type,Length,Scale,Nullability.

Ex: DISPLAY CALL SchemaName.PROCname

b)TABLE

returns Column name,Table qualifier,Data type,Length,Scale,Nullability

Ex: DESCRIBE TABLE MYNAME.TABLENAME

viii) DISCONNECT:

  disconnects current connection to db2 server.

Ex: DISCONNECT

ix)ECHO :

prints text string to the output stream.

Ex: ECHO Hello World

x) HELP:

gives info about commands.

Ex: ? LIST

xi) LIST TABLES:

list tables.

Ex: LIST TABLES

xii) sql commands:

execute SQL statement.

Ex: CONNECT TO url.abc.com:4096/JKL1 USER abc11 USING mypwd123 SELECT * FROM MYTABLE.EMP