Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010
    Posts
    2

    Unanswered: DB2 Variable Substitution

    Does DB2 support variable substitution when processing a DDL file at command prompt? The following is a psuedo-example of what I'm trying to do:

    Code:
    db2 -vtf update_table.ddl var="myTable"
    Where the update_table.ddl contains the following:

    Code:
    update global.var set flag=1;

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    It has nothing to do with DB2 per se, but rather with the command line processor. DB2 9.7 has a new command line processor, CLPPlus, that offers this capability.

Posting Permissions

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