Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    306

    Unanswered: db2batch/db2expln input file syntax?

    DB2 LUW 9.1 on AIX

    db2bacth and db2expln seem to have different requirements with regard to an SQL input file.

    Why is it that when I create a file with a single statement in it that I can run it with db2 -tvf, I can explain it when I use the -schema % and -package % syntax but I just cant seem to run it in db2batch :/

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Could you be a bit more specific and provide an example for illustration purposes? Also, the exact error message would be appreciated.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Jul 2004
    Posts
    306
    Quote Originally Posted by stolze
    Could you be a bit more specific and provide an example for illustration purposes? Also, the exact error message would be appreciated.
    Sorry it was the end of a very long and stressful day :/

    Looking at it with a fresh head it basically it seems I'm having schema problems. I can issue a set schema statement in db2expln and then my SQL and that works fine (the -schema option didn't seem to do anything?) but I can't seem to get the db2batch to accept a set schema or find a -schema option for it... I've read the doco and I'm still stumped... I'm sure I'm doing something silly here... any ideas?

Posting Permissions

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