RE: v5r2 question

Thanks Vern, that's what I surmised as well so I opened a PMR asking if
there's a PTF.  
Official answer is that it is working as designed for V5R1 and the only way
to hope to change that would be to submit a DCR.  Being that they've changed
this on V5R2 and that V5R1 is nearing end of life, I'm not going to create a
DCR.
I'll just stick with the short view names in Qtemp.  

Elvis

-----Original Message-----
 Subject: 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