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 :/

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?