RE: v5r2 question

Hey, Elvis

On our V5R1 machine I get the same results as you do. But if I use the system 
name TESTI00001, it works fine. And if I create the long-name view into a 
permanent library, it works. Looks like a PTF needed.

It also fails with CREATE TABLE - and short name works.

Vern

-------------- Original message -------------- 

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