Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2011
    Posts
    39

    Unanswered: DB2 command line processor

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  3. #3
    Join Date
    Jan 2010
    Posts
    207
    this was accidently posted and can be removed :-)
    Last edited by DB_N00b; 06-22-11 at 17:05.

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You posted this on the wrong thread. But yes, that is what you need to do.

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •