RE: v5r2 question -- MIDRANGE-L

Ah ha..

There was a PTF

http://archive.midrange.com/midrange-l/200209/msg01422.html

V4R5 : 5769SS1 SF67478
V5R1 : 5722SS1 SI04582


HTH Elvis,

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
> daparnin@xxxxxxxxxxxxxx
> Sent: Wednesday, August 10, 2005 2:41 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: v5r2 question
> 
> 
> 
> 
> 
> 
> 
> It doesn't look that way:
> 
>                        Display Object Description - Full
>                                                               
>    Library 1
> of 1
>  Object . . . . . . . :   SYSIBM          Attribute  . . . . 
> . :   PROD
>    Library  . . . . . :     QSYS          Owner  . . . . . . 
> . :   QSYS
>  Type . . . . . . . . :   *LIB            Primary group  . . 
> . :   *NONE
>  User-defined information:
>    Attribute  . . . . . . . . . . . . :
>    Text . . . . . . . . . . . . . . . :
>  Creation information:
>    Creation date/time . . . . . . . . :   09/25/03  19:01:19
>    Created by user  . . . . . . . . . :   QSYS
>    System created on  . . . . . . . . :   S10A7887
>    Object domain  . . . . . . . . . . :   *SYSTEM
> 
> More...
>  Press Enter to continue.
>  F3=Exit   F12=Cancel
>  (C) COPYRIGHT IBM CORP. 1980, 2000.
> 
> 
> 
> 
> 
>                                                               
>                                                    
>                       "Wilt, Charles"                         
>                                                    
>                       <CWilt@xxxxxxxxxxxx>        To:       
> "Midrange Systems Technical Discussion"              
>                       Sent by:                     
> <midrange-l@xxxxxxxxxxxx>                                     
>                       midrange-l-bounces@m        cc:         
>                                                    
>                       idrange.com                 Subject:  
> RE: v5r2 question                                    
>                                                               
>                                                    
>                                                               
>                                                    
>                       08/10/2005 01:36 PM                     
>                                                    
>                       Please respond to                       
>                                                    
>                       Midrange Systems                        
>                                                    
>                       Technical Discussion                    
>                                                    
>                                                               
>                                                    
> 
> 
> 
> 
> Maybe somebody created it manually?
> 
> Can you check the created by user?
> 
> 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
> > daparnin@xxxxxxxxxxxxxx
> > Sent: Wednesday, August 10, 2005 2:31 PM
> > To: Midrange Systems Technical Discussion
> > Subject: 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/rba
> > fzmstcatalog.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.
> >
> >
> > --
> > 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.
> 
> 
> -- 
> 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.
> 
>