Hi,

We have a server with 64-BIT 8.1 FP 18 DB2 UDB on Linux ( CentOS) and I'm having a problem with the db2look command --. when I give it to see the definition of a table I get this error --

db2look -d dbname -t site -e -x -o site.ddl
-- No userid was specified, db2look tries to use Environment variable USER
-- USER is: DB2INST1
-- The db2look utility will consider only the specified tables
-- Creating DDL for table(s)
-- Output is sent to file: site.ddl
SQL0007N The character "\" following "HIJKLMNOPQRSTUVWXYZ[" is not valid.
SQLSTATE=42601


Any idea how I can fix this? Thanks!!
Edit/Delete Message

You need to specify -z schema name in your db2look command.

thanks, i tried it with -z and still get the same error, any other ideas?

db2look -d dbname -z schemaname -t tablename -l -e -a -x -o o/pfilename

Please do check the DB2 Manuals for the command.( for options)

thx, i tried that and it still fails.. I don't think there is anything wrong with the command itself.. but maybe I'm missing some packages..has anyone else seen this before?

What's the output from:

env | grep LANG
db2 get db cfg for <db name> | grep code

Hi, this is what I get --



env | grep LANG
LANG=en_US.UTF-8


db2 get db cfg for dbname | grep code
Database code page = 819
Database code set = ISO8859-1
Database country/region code = 1

Also, thought I would add that I tried it without the -t option and it worked just fine --

this works : db2look -d dbname -e -x -o site.ddl