Why buy a tool when it’s easier to resolve the problem with what comes with the system and the resolution has the support of the system vendor? — Tom

This is not an academic exercise-not sure why you would think that.
 
I can explain that, but it won’t be a very nice description of the database that you have and of the requirements that you listed. It might help with future questions.
 
The ‘academic’ characteristics begin with the simplicity of the question parameters. You supplied a specific set of data. The requirements you gave can be satisfied easily if that data is used. It doesn’t need any techniques above the novice level, techniques that would be part of a beginner’s course in queries.
 
Also, the requirements themselves don’t make business sense. (And it all doesn’t actually seem to fit with the accounting definitions of a ‘clearing account’.) They do make academic sense, though, as part of an academic assignment that would ilustrate principles.
 
Without procedural code, there is no valid way to match DRs and CRs in the manner that you requested using only a query. In order to do it with any set of data rather than just the example set, a procedure must be followed. Consider data like this:

ID EEID DR CR
 1  333 30
 2  333 10
 3  333 20
 4  333 50
 5  333    30
 6  333    30
 7  333 30
 8  444 60
 9  444    60
10  444 70

It’s very similar to your example data set, but with a few extra lines to illustrate a problem. ID 2 and 3 have been added for two new DRs, and ID 6 has been added to show a single CR that offsets those two new DRs in a single transaction.
 
The problem brought by this is that a “query” cannot tell that both ID 5 and ID 6 do not associate with ID 1. A procedure is necessary. The proc would need to associate ID 5 with ID 1, and then create some kind of mark that ensures that ID 1 can’t be re-used for a different CR. It might DELETE both ID 1 and ID 5 before going on to the next CR, or it might UPDATE both with a flag to eliminate them from further processing. Then when ID 6 is processed, it wouldn’t mistakenly match it with ID 1.
 
But your requirements only allowed a ‘query’ solution, and your database eliminates a ‘flag’ column and apparently it cannot be altered. Those are also general ‘academic’ requirements because they don’t reflect common real-world business situations.
 
The question you wrote asks for a specific technical solution for a very specific scenario. A technical solution for the scenario is possible, but it can’t be used for real-world unpredictable data sets. It will give incorrect results.
 
The business answer is to redesign the database to have it record actual transactions. The transactions need to be related to business entities such as order numbers or invoice numbers or payroll advance IDs or whatever these transaction represent. The amounts cannot be the basis in a real-world situation because you can’t guarantee that they won’t be duplicated. Some type of “EntityID” needs to be assigned that guarantees a valid association.
 
A business problem describes a problem environment and looks for a good resolution. An academic problem gives exact details and asks for a specific solution. A solution for an academic problem illustrates a definite principle and often doesn’t have a valid solution that can be directly used in business, like this question.
 
This exact question can be solved with fairly basic novice-level queries. However, the queries cannot be relied upon for actual business use with unpredictable data. The problem environment (the database) is wrong, and the environment is what needs to be fixed if this really is a business problem.
 
If it can’t be changed and queries are required, then there is no valid solution.
 
Tom

If the OP had shown the function the way you did, we might have been able to help. But we couldn’t suggest any changes since we couldn’t see what was being done. Yours is a good example of one kind of fix. — Tom

Application Admin will be on Alll ODBC files
 
Only if the ODBC client honors the setting. The server does not enforce the setting. If an ODBC client doesn’t check the function registry, it won’t matter if you set it or not. The iSeries Access ODBC client driver is the only I’m sure of that will honor Application Administration ODBC settings.
 
See Block Crystal Reports from iSeries access for IBM’s recommendation.
 
Tom

Without knowing the exact kind of printer (and having the user guide for it) and how the wireless router (or access point) is to be configured and what platform (or platforms) need to use the printer (particularly what OSs, and possibly any SPs), there’s no way to be sure how it’s done. The direct answer is “Read the user guides for each of the associated devices and follow their directions, or get someone familiar with all of the connected devices and have them do it.” — Tom

You calculate KWH by measuring kilowatts over some number of hours, then multiply the two numbers together. (Estimates of kilowatt usage can be made from power ratings.) The question isn’t very clear. The calculation is too simple to explain much more than that without details of the circumstances. — Tom

You need to put your phone number in here if you want someone to call you. I would not recommend that since anyone can have access to this site.

Then the dates become important .. I would take the lowest (oldest) dated credit for each person and match it with the lowest dated debit where the credit and debit has an amount that is > the total of that credit/debit in the clearing file.  Use the less of the credit – total cleared for that credit or the debit – total clearded for that debit to make a new row cleared. 
I think that you’ll be repeating this until you don’t find any more credit/debits with uncleared balance that can be cleared. 

If you have TAATOOL on your system, I believe it contains a similar command.

Sounds like you are getting to the outfile..which has the journalling details and then a long field which contains the actual data.
Make a new file which contains the journalling details followed by all the fields in your original file.  Then copy the outfile to this newfile file with format *nochk you will have the data as it was.  That’s what the command Charlie Browne suggested does.  Then you can do anything you want with the new file.

Which fields are in unreadable format. Are they packed numeric?All the EXPJRNE command does is a normal DSPJRN but instead of having all the data for the PF that was journaled put in one field, It will add all the fields from the field description for the PF to the end of the record so you can acutally do SQL commands or any other normal access to look at the data.

You can also check out this article on SearchExchange about Exchange Global Address, which answers many Exchange Global Address FAQs.

Google the company of the tv and download the PDF file of the manual for the tv.  In there, you should be able to find instructions for what you need.

Can I do a select in SQL Server from a table in another DBMS system? 

You can certainly do that, by means of Linked Servers.  However, I have never heard of ‘Intersystems Cachè’, so I don’t know if it will work well as a linked server (probably yes if an ODBC driver exists).

I’m not sure that’s a possible solution Charlie Brown… I would prefer to export the file locally (to my PC for instance) and convert it rather than run a command I’m not familiar with on a production box. I’d guess it’s safe, but I would only be guessing without evaluating every line of code. Perhaps a better question is why is the before image and after image in an unreadable format? The file itself is in plain text, I can see the current field data. 

The easiest way to find the location (in relation to the data directory) is to check the person document / mailin database document.

In what program?  You question is very vague.  Some Office programs have it in their toolbars for creating a table.  So please give us more information.

Here’s a simple question for you, don’t you have your systems on UPS so that you can do a simple shut-down in the event of a extended power outage?  This would also save you some headaches.

Do you have administrator rights on your system?  If not, you will not be able to install anything.  Also, try uninstalling all of the older versions, reboot, and then try the download.  This has worked for me on my customers systems quite a few times.

You might not get it to work, though there might be adapters you can buy. You might also find a forum that has something to do with home DVD players and TVs in order to get a good answer. A Magnavox customer support forum is possibly your best direction. — Tom