RE: v5r2 question

I have V5R1 and am sure SYSIBM came shipped with the OS.  IBM's doing it to
conform to DB2 standards.  SYSDUMMY1 is used widely as a table for
illustration purposes, since it is guaranteed to contain only one record.
For example, SELECT CURRENT_DATE FROM SYSIBM/SYSDUMMY1 is guaranteed to only
return single record, while doing it against a multi-row table it would
return current date for all rows in the FROM table.
I only used it out of habit.

Fact is that V5R1 doesn't seem to handle a case where a view is created with
a long name (> 10 chars) in a QTEMP library.  It signals SQL0204 (can't find
it), even though it's there.  It doesn't matter what the FROM file is.

I might open an informational PMR just to see if there is a PTF for it on
V5R1.  Thanks all for trying it out.

Elvis

-----Original Message-----
 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"

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
> 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>
>
>
> 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-----
> > 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