RE: v5r2 question

I tried it on our V5R1 system and got the following:

   > CREATE VIEW QTEMP/TESTINGMYVIEW AS SELECT * FROM SYSIBM/SYSDUMMY1
     View TESTINGMYVIEW created in QTEMP.
   > SELECT * FROM QTEMP/TESTINGMYVIEW
     TESTINGMYVIEW in QTEMP type *FILE not found.

There does appear to be a SYSIBM library.  I'm no SQL expert so that's
about all I know.

Dave Parnin
--
Nishikawa Standard Company
Topeka, IN  46571
daparnin@xxxxxxxxxxxxxx




                                                                                
                                                         
                      "Wilt, Charles" <CWilt@xxxxxxxxxxxx>                      
                                                         
                      Sent by:                                            To:   
    "Midrange Systems Technical Discussion"              
                      midrange-l-bounces+daparnin=niscoseals.com@m         
<midrange-l@xxxxxxxxxxxx>                                     
                      idrange.com                                         cc:   
                                                         
                                                                          
Subject:  RE: v5r2 question                                    
                                                                                
                                                         
                      08/10/2005 01:25 PM                                       
                                                         
                      Please respond to Midrange Systems Technical              
                                                         
                      Discussion                                                
                                                         
                                                                                
                                                         




Elvis,

SYSIBM didn't exist on v5r1.

At least there is no mention of it in that "SQL Catalog Views" page of the
v5r1 Infocenter.

http://publib.boulder.ibm.com/iseries/v5r1/ic2924/info/db2/rbafzmstcatalog.htm


Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121


> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Elvis Budimlic
> Sent: Wednesday, August 10, 2005 1:50 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: v5r2 question
>
>
> I have access to V5R1 and V5R3, but not V5R2.  Can someone
> test this for me:
>
>
>
> STRSQL
>
> CREATE VIEW QTEMP/TESTINGMYVIEW AS SELECT * FROM SYSIBM/SYSDUMMY1
>
> SELECT * FROM QTEMP/TESTINGMYVIEW
>
>
>
> And tell me if they get SQL0204 message or not.
>
> It didn't work for me on v5r1, but it did on v5r3 and maybe
> I'm just missing
> a PTF but don't know which one.
>
> Thanks.
>
>
>
> Elvis
>
> --
> This is the Midrange Systems Technical Discussion
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.