db2look usage

gamo · #1 (**permalink**) 11-17-09, 20:11

Hi,

I am trying to reconstruct a UDF so I'm attempting to use db2look

I have
> db2look -d mydb -e

the error which I am getting is

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 "db2look" was found following
"BEGIN-OF-STATEMENT". Expected tokens may include: "DECLARE".

which seems a bit weird to me

might this be because I don't have access to system tables? shouldn't the error message be a bit more descriptive if that is the case?

tonkuma · #2 (**permalink**) 11-17-09, 20:53

From CLP:

db2 => !db2look -d sample -e
-- USER is: DB2ADMIN
-- Creating DDL for table(s)
-- This CLP file was created using DB2LOOK Version "9.7"
-- Timestamp: 2009/11/18 11:02:11
-- Database Name: SAMPLE
-- Database Manager Version: DB2/NT Version 9.7.0
-- Database Codepage: 1208
-- Database Collating Sequence is: IDENTITY

gamo · #3 (**permalink**) 11-17-09, 21:47

that worked

sorry if this is a really dumb question, but what is the ! for?

and why isn't it in the docs? (or is it and I'm just not seeing it?)

does it have something to do with my setup?

tonkuma · #4 (**permalink**) 11-17-09, 22:14

I can't remember how I leaned "!".

But, I found a description in
DB2 Database for Linux, UNIX, and Windows

Quote:

db2 - Command line processor invocation command
.....
The shell command (!), allows operating system commands to be executed from the interactive or the batch mode on UNIX based systems, and on Windows operating systems (!ls on UNIX, and !dir on Windows operating systems, for example).