× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.







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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.