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

    Question Unanswered: CLP If Statements

    I'm maintaining DDL files for deploying database changes, using the DB2 CLP. In some cases, the files are run at sites that have older versions of the database structures. At other sites, the database structures don't exist.

    I've included Drop statements in the DDL files, which are run unconditionally. This results in errors at sites that don't have the structures. Does the DB2 CLP support conditional statemets (i.e. "IF" statements)? If so, could someone point me to some documentation or provide an example?

    For what it's worth, I'm using DB2 UDB v8

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    Quote Originally Posted by KrimblKrum View Post
    IDoes the DB2 CLP support conditional statemets (i.e. "IF" statements)?


Posting Permissions

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