DB2 command line processor

Gideon22 · #1 (**permalink**) 06-22-11, 15:35

I am using DB2 on Winddows

From the command line processor I can enter the following successfully:

Code:

db2 => CREATE TABLE testtable_a ( \
db2 (cont.) =>     col_a                  CHAR(1) \
db2 (cont.) =>  )
DB20000I  The SQL command completed successfully.
db2 =>
db2 =>

But I can not figure out how to invoke the option to do this without the slash "\" after every line:

What command do I run to do this ?

Thanks

ARWinner · #2 (**permalink**) 06-22-11, 15:37

You can either put the entire statement on a single line, or you can put the statements in a script file (text file) and execute the script file using "db2 -tvsf <scriptfile>".

Andy

DB_N00b · #3 (**permalink**) 06-22-11, 15:55

this was accidently posted and can be removed :-)

ARWinner · #4 (**permalink**) 06-22-11, 16:00

You posted this on the wrong thread. But yes, that is what you need to do.

Andy

Internet Services

Web Development

Digital Marketing

Consumer Tech