For what uses? — Tom

Are you curious about the future for most people alive today or for some time within the next few dozen centuries or more? It seems unlikely in any near future.
.
Technology involved around police actions advances as always, both positively and negatively. Technological advances need to be understood at a “meta” level before society learns how to manage human interactions Implications and relationships are too complex and not enough is known. We have a long way to go before we reach predictability for individuals in a population. Until then, technology will counteract technology; and human presence will be required.
.
Tom

The actions I asked about are possible kinds of things that might have happened manually or by 3rd-party products or other ways completely separate from the use of the user space. For example, someone might do a test install of some Security or Compliance product. A test run of the product could run through a list of libraries to retrieve ownership and authority in order to generate a sample report.
.
Now, that example shouldn’t have the effect you’re asking about. It’s just an example of some external, unrelated process that touches objects on the system. And the point is that something like IFS processes can happen in many ways.
.
IFS activity is interesting for user spaces because a space can be accessed as a stream file. You can use the CPY command or EDTF to modify a space. I haven’t seen either of those give your result, but I don’t know all possible combinations. The use of SAV might set IFS-style backup attributes.
.
In short, I don’t see anything that you can do differently. Your recreation seems to be appropriate. You might need to call the QUSCUSAT API for additional attributes, in case you need it to auto-size itself or other reasons.
.
IBM support seems to be your best place to go if you need an authoritative explanation.
.
Tom

If you are rich enough to build one, then you’re rich enough to hire companies that can do it. You don’t need to ask here, and this isn’t a place you can get that kind of information anyway.
.
Tom

My 1T external has a D/C power supply that has to be running for it to power up?

Can you give us more information as to what is happening?

I did not find any call to QLICOBJD , neither object auditing … I did not find IFS calls either … as you said the other parameters do not wite this -extended data- section …

Tom,

I tried to make the report work a dozen times with no success. I recreated the file and imported its MS Word document and all works just fine now.

Win 98 to the rescue!

Must have been a glitch in the original importing of the MS Word document.

wem3rd

SQL can run a statement like this:

   INSERT INTO MyFile2 SELECT * FROM MyFile1

The problem comes from the sharing. OPNQRYF cannot share an existing ODP. But unfortunately, as you’ve learned, the reason you have to share is because of OPNQRYF. You’ve answered why the sharing is done; OPNQRYF requires it. But it seems like a contradiction, doesn’t it?

Call CL1

Call RPG program 

Call CL2

PGM
DCLF File(XXX)
OvrDbf     File(xxxx) ToFile(*LIBL/xxxx) SHARE(*YES)                    
OpnQryF    File((xxxx) QrySlt('Fld1 *EQ "3"')                   
read the file here 

PGM
DCLF File(xxx)
Ovrdbf     File(xxxx) Share(*Yes) Secure(*Yes)      
Opnqryf    File((T00210)) QrySlt('AAAUS *GT "111" +        
             *And AAAUS *LE "222"')

Yes, Export Notes is good and helpful utility that convert
Domino v8.5 nsf mail file to Outlook .pst without any removal or variation in
information as well as it manages same folder structure after Lotus Notes to
Outlook Conversion.

Thank you all i am able to achive this with ought RUNSQLSTM,but able to achive this through 2 processes .
1STRQMQRY
2embedded sql

I have used sharing because otherwise my Rcvf was not getting the records that satisfy the QrySlt condition mentioned in Opnqryf.
I have Dclf, ovrdbf share(*Yes), opnqryf, and Rcvf on both the CL programs. But the Opnryf QrySlt condition is different in both the CL. As I said, if the file reads till Eof, I dont have any issues. The issue appears only if I read one record alone. And from your response I understood we cannot deletet the ODP just by closing the file and deleting the override. And my programs are not Clle, they are CLPs. If I make Share(*No) do I need to change the scope to *Job inorder to read the Qryslt records using Rcvf?

http://www.highprbacklinks.co.in

Though I used share in both CL, I had deleted that override in that program itself after closing the file and then called the second program. I have commetned out the call to SQLRPGLE program, but still the error is there. But one thing I noticed was my Rcvf was not looping till EOF as for testing purpose I had commented out the loop to read the file again. So the RCVF was reading the file only once and then it was calling the RPG program, then close the file delete the override and call the second RPG program. Now I remove the comment and the file is reading till CPF0864 and the problem is resolved. But if the file is read only once….then even after closing the file why it is not allowing to do another opnqryf in the second program remains unanswered..

Correction… What is the SFLCTL DDS for fields (rather than the “subfile” itself)? — Tom

What computer? What is the OS? Is this your personal home system or a business system? How have you maintained old restore points? — Tom

The RPG possibly doesn’t matter (though the OVRDBF could make odd trouble; I’ve never mixed OPNQRYF and embedded SQL which seems almost contradictory).
.
The ODP is *SHAREd in the outer CL and also *SHAREd in the inner CL while the outer is still active.The outer ODP still exists. The two CLs have different OPNQRYFs, so the *SHARE probably should not be used at all. The two CLs need different ODPs. There’s nothing that should be shared as far as I can tell.
.
Tom