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