Hi
What I did
1. CPYF  FROMFILE(IIC)  TOFILE(QTEMP/IIC)  MBROPT(*REPLACE)  CRTFILE(*YES)

2. OVRDBF  FILE(IIC)  TOFILE(QTEMP/IIC)

3. Then I went to interactive SQL by STRSQL and ran
            (a)    SELECT * FROM QTEMP/IIC
                              ----    It ran fine

            (b)    SELECT * FROM ATEMP/IIC     ( this time actually I mistyped, 
there is no ATEMP library)
                               ----   Still it ran and gave the same information

            (c)    SELECT * FROM ABCDE/IIC      (now from curiosity, no library 
like this)
                                ----   Still it ran and gave the same 
information.

I found that if I don't do the OVRDBF, then SQL gives message that "IIC in 
QTEMP type *FILE not found", which is normal. But after doing OVRDBF it is 
happening. I did these from command line, though I think it does not matter 
whether you do it from command line or by a CL program and then run interactive 
SQL. Does any body have any idea why it is happening?

TIA
Amitava





This thread ...

Follow-Ups:

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

This mailing list archive is Copyright 1997-2026 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.