Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: zyerg
  • Order by date
  1. zyerg

    db2 v9.5 script error

    Hi, Sorry I forgot to post the error. This is what I got after running the script in DB29.5: DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0104N An unexpected token "BEGIN IF NOT...
  2. zyerg

    db2 v9.5 script error

    oopps.. the DB2 version was DB2 v9.7.0.441 not DB2 v9.8
  3. zyerg

    db2 v9.5 script error

    Hi, I am new to DB2, I have a script that is working on DB2 v9.8 but not in DB2 v9.5: BEGIN IF NOT EXISTS (SELECT TABNAME FROM SYSCAT.TABLES WHERE TABNAME='TABLE1') THEN EXECUTE IMMEDIATE 'CREATE TABLE "TABLE1" ( "USERNAME" VARCHAR (130) NOT NULL, "PASSWORD" VARCHAR (1020)...

Part and Inventory Search

Back
Top