Hi All,

We recently upgraded a DB2 instance from 32-bit to 64-bit. After that I am not able to query the tables from the OS(i.e..directly wihtout getting into the db2 prompt).

$ db2 select * from ab
SQL0104N An unexpected token "sqllib" was found following "inst1
prev_check_run". Expected tokens may include: "<space>". SQLSTATE=42601

The same is fine when accessed from the DB2 prompt.



Pls help.

try this:
db2 "select * from ab"

Background: This is not a DB2 problem but relates to your shell. Whenever you type '*' or '?', the shell will expand this based on the content of the local directory. So if you have three files 'abc', 'def', and 'xyz' in the current directory, your command will become:
If you look at this statement, you will agree that it is syntactically incorrect and DB2 must complain about it. (This happens way before the DB2 CLP is invoked.)

Putting quotes around it - as Marcus suggested - prevents the globbing of the shell and DB2 will get the "*". Another (but IMHO more cumbersome) alternative is to escape any special characters that the shell interprets (*, ?, $, etc.):