I read somewhere that inorder to hard close the cursor I have to put CLOSQLCSR as *ENDMOD instead of *ENDACTGRP . If I come out of SQL RPGLE with Close Cursor command and *INLR on, it will close the files right? Please share your thoughts on this.

Both my programs are using RCVF on that file, in that case how can I avoid DCLF? I am coming out of the RPG program with INLR on. And to add on that, am not using this file in F spec in RPG, instead it is being used inside an SQL and am making sure to close the cursor and LR = *ON while coming out.

The encoding and modulation are not the same thing. Modulation is the changes made on the physical media to be detected at the following end, encoding is how you use those changes to represent the data.

Ethernet on twisted pair (including cat5) uses Pulse amplitude modulation. Have a look at this white paper on the Cisco site.
http://www.cisco.com/global/EMEA/sitewide_assets/pdfs/realbroadband/gigabit_ethernet_over_copper_white_paper.pdf

The scenario answer is based on a /30 mask. Your answer is correct for the subnets, based on the /28 mask. The IP addresses allocated to the interfaces are not correct, as this is supposed to be “the last available Ip address on the appropriate subnet”. You have put the first address, which is the subnet network address, and can not be used for the interfaces. I would recommend you review this, and correct your answer for the interfaces.

Oh, now it will

What I was suggesting ,, no DCLF in the first level programs

PgmCL1
OVRDBF
OPNQRY
Call PgmCL2
CLOF
DLTOVR

OVRDBF
OPNQRY
Call PgmCL2
CLOF
DLTOVR
EndPgm

Sorry, it’s not that we’ve abandoned you .. but the system will not process my discussion responses.

What you’ve shown us should work.
What you haven’t shown us is the SQL Select
.. This must either be a Select * or select fld1, fld2 .. all fields in original order.
Finally the version of the file used in the Select must have the same fields as the one used when compiling.

DCLF File(xxx)
Ovrdbf File(xxxx) Share(*Yes) Secure(*Yes)
Opnqryf File((T00210)) QrySlt(‘AAAUS *GT “111″ +
*And AAAUS *LE “222″‘)

1. DCLF File(xxx) in both programs may not be necessary.
This declaration is used in cl programs that use the rcvf to read the file.

2. I assume that T00210 in your sample is xxx an error in editing the question.

3. Clof Opnid(XXX) DltOvr File(XXX) might not act as expected if the RPG program fails to close the file (usually putting on *INLR)

Yes, just as you used IN to get the data area contents, use OUT to update the data area.
If you are not familiar to how this is done, see the RPG Reference manual.

You can use RPG to retrieve and/or up[date the contents of a *DTAARA
If you have not done this before, look in the RPG reference manual and scan for DTAARA

Tom,Could you please suggest any solution other than OPNQRYF? OS version is V5R4

Searches through Google (or your favorite search provider) will give plenty of results. This appears to be an academic kind of question that we can’t provide direct answers for. If you post the answer that you think is right or that is as close as you can get, we can provide guidance. But we can’t simply give you the answers.
.
Tom

Please don’t start new questions when you already have the same question open. It makes it difficult to follow what has already been said.
.
Tom

Since Actuate (Spreadsheet) works over Excel spreadsheets rather than over any real “database”, it’s hard to guess what dialect of SQL would be used. There are numerous potential variations. I’d think first of a form that’s compatible with Microsoft Access, then with SQL Server, and finally with actual standard SQL.
.
Tom

Please don’t start new questions when you already have the same question open. It makes it difficult to follow what has already been said.

Tom

If you have the Office Starter package, what directory has the starter Excel version in it? If the accounting product looks for a specific directory structure, it probably won’t know how to locate a ‘starter’ version unless the directory structure matches the full Excel product path.
.
The Support group for your accounting product might be the only ones who can help you.
.
Tom

Because EOF has been reached, POSDBF won’t work. Without knowing the OS version and the programming, breaking it into sub-programs is about as much as can be said. — Tom

you can only use the word modulation when you are talking about the RF kinks such as terrestrial microwaves for instances 16 QA M, QPSK and so on. But in the context of Ethernet Network, in standard and modernity we use Cat5 cable as a transmission medium.

You should be able to run 32-bit Excel on 64-bit Windows just fine.

Sounds like you have a hardware failure such as memory, motherboard, or power supply.