Re: QSHELL db2 command

[Jeff Young <cooljeff913@xxxxxxxxx>]

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