Re: QSHELL db2 command

Thanks Scott.
I used your example and it worked exactly the way I wanted.
 
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
  
 






________________________________
From: Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Sent: Friday, April 10, 2009 2:20:04 PM
Subject: 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