Re: QSHELL db2 command

No, unfortunately, the db2 command only does *SQL naming. So you have to code it like this:

db2 'select * from t37files.vinlot'

in SQL naming convention library is separated from filename by a dot. (The slash you were using was for *SYS naming.)

Personally, I tend to code my statements more like this:

db2 "select * from $FILELIB.vinlot"

This way, $FILELIB is a variable. Then my CL program can use RTVOBJD or similar to find vinlot in the *LIBL, and so I don't have to hard-code a library name.

PGM
DCL VAR(&FILELIB) TYPE(*CHAR) LEN(10)
RTVOBJD OBJ(*LIBL/VINLOT) RTNLIB(&FILELIB)
ADDENVVAR ENVVAR(FILELIB) VALUE(&FILELIB) REPLACE(*YES)
QSH CMD('db2 "select * from $FILELIB.vinlot")
ENDPGM

etc, etc.




Jeff Young wrote:

List,
I am attempting to use the db2 utility in QSHELL to run an SQL command from CL.
When I enter the command, I get an error indicating that it can not find the file that I want to display.
It seems to be using SQL naming syntax.

db2 'select * from vinlot' **** CLI ERROR ***** SQLSTATE: 42704 NATIVE ERROR CODE: -204 VINLOT in VAIJY type *FILE not found.
Can I specify *SYS naming convention?
If not how do I qualify the file to the library that I am using?

When I use the command:
db2 'select * from t37files/vinlot'
I get the following error:
**** CLI ERROR ***** SQLSTATE: 42833 NATIVE ERROR CODE: -5016 Qualified object name VINLOT not valid.

TIA,
Jeff Young Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2 IBM Certified Specialist- e(logo) server i5Series Technical Solutions Designer V5R3
IBM Certified Specialist- e(logo)server i5Series Technical Solutions Implementer V5R3