TomLiotta-There are no invoice numbers associated with these transactions. These are debits and credits hitting a clearing account, and no other detail can be added to this table. There is one field on each record that you are not seeing, and that is date of transaction-though the date would be totally irrelevant to writing this query. This is not an academic exercise-not sure why you would think that. This is a real life work scenario and we are out of options at the moment for reconciling this particular clearing account.
Philp- I am exploring doing some inner joins and see where that may take me. Though, I will ultimately be in the same predicament of not knowing what language/expressions to use when trying to write a query that returns matching or unmatching records. 
 
Thanks

Ive posted the topology of the network so you might get a better understanding of what i mean. please have a look. [URL= http://www.image-share.com/ijpg-2139-158.html ] [IMG] http://www.image-share.com/upload/2139/158.jpg [/IMG][/URL][URL=http://www.image-share.com/ijpg-2139-158.html][IMG]http://www.image-share.com/upload/2139/158.jpg[/IMG][/URL][URL=http://www.image-share.com/ijpg-2139-158.html][IMG=http://www.image-share.com/upload/2139/158.jpg][/URL]

you can use dell factory default IF there is an image on the laptop

try checking the time from BIOS and try setting it there and then start windows and change the time..then give a final restart to see if the day still changes

maybe you can go to flash website and execute it. but we need more information if its your pc or companies pc and if you are login as user or administrator

Sounds like you’re dealing with a corrupt video file.

How are you sending? What e-mail client are you using? — Tom

The TOFILE() must be a database file with fields that can accept each of the values between the delimiters. In your first example, the first field looks like a CHAR(1) field, the second field looks like it might be a CHAR(15), and so forth. What are the field definitions in file PRASH/RPOOL1? — Tom

Hi,You can also configure i Navigator, Apllication Admin., Client Application,ODBC…RegardsHassan

Thank you for your reply Tom.after reading online, this is what i think about implementing management VLAN:I have an address space of 172.16.2.192
/27 for the management VLAN. So first usable IP 172.16.2.193 will be the the routers sub interface I.D. Vlan 100 will be created and called Switch-Managment-LAN and propagated via VTP. then interfrace Vlan100 will be created on all switches. an ip address ranging from 172.16.2.194 – 172.16.2.222 will be given to the interface vlan 100 on each switch. each switch will be assigned a default gateway of 172.16.2.93. Vty 0 4 passwords will be set to allow telnet! ok thats sorted!thanks Tom! a bit of google and some lecture notes from last year has sorted that out!now to give you an idea of my DMZ set up i will post an image on and get back here to post the link. i wish i could post the packet tracer file over too.

How are you creating the attachment and sending the file?Look into that code and you will probably find that a temp file is being created with a length of 1024.

This is the command I gave.
 CPYFRMIMPF FROMFILE(TESTB/RPOOL *ALL) TOFILE(PRASH/RPOOL1 *ALL) RCDDLM(|STRDLM(|) FLDDLM(‘|’)        
It displayed error ->    Message . . . . :   To-file RPOOL1 in PRASH not allowed.                     Cause . . . . . :   File RPOOL1 in PRASH is not the correct file type for the  copy command.                                                                                         
Since it is a exisitng business logic the data are present like this.
Kindly guide me in this. TIA

This is the command I gave.
 CPYFRMIMPF FROMFILE(BASEL2/RPOOL *ALL) TOFILE(PRASH/RPOOL1 *ALL) RCDDLM(|STRDLM(|) FLDDLM(‘|’)        
It displayed error ->    Message . . . . :   To-file RPOOL1 in PRASH not allowed.                     Cause . . . . . :   File RPOOL1 in PRASH is not the correct file type for the  copy command.                                                                                         
Since it is a exisitng business logic the data are present like this.
Kindly guide me in this. TIA

how do i implement a mangment vlan?
 
As is usually the case, a Google search for [ management vlan ] or for [ management vlan configuration ] brings up numerous authoritative links that tell much about doing this. Did you run into any specific problems?
 
Now i need to set up these servers in a DMZ or a DMZ VLAN but i dont know how.
 
What don’t you know how? How to set up the servers? How to create a DMZ? How to position the servers inside or outside a DMZ? A more detailed description of the actual problem would help. Google searches for [ DMZ ] or [ DMZ topology ] and similar terms show various examples.
 
Start with some diagrams. Upload scans or any images of your network that you can create to any image sharing site, and link them here. Label your segments, sites, equipment, network and device addresses, anything you have an idea about. Mark any problem areas. It’s possible that some discussion can get you going in good directions.
 
But be clear; homework or class assignments cannot be answered here. We can only give suggestions or help with understanding. Guidance is possible; an actual answer is not.
 
Tom

What “spooled file” are you trying to get? This subsystem monitor stuff doesn’t need to create any spooled output. — Tom

I would probably first use iSeries Navigator to get the spooled file. Drill down to your printer output, then drag & drop the spooled file to your PC. You can only map a drive to your server if your server is exporting a shared directory for you to map over, and it can only export a share if you have properly configured NetServer and you have NetServer running. (A drive doesn’t have to be “mapped”. You can just use the UNC for the shared directory.) You’ll need to research NetServer before trying to learn details. — Tom

I found these instructions by running a Google search for [ how do i download my ipad backup from icloud ]. The search was copied directly from your question. — Tom

Tom,I have one more queries, I m sure you can help me out. Its not related to this. But i m putting it up here only, Let me know if you want i should put in some question/heading. Question: I have to copy the spool file to the PC Drive in text format, I searched hard for how to map the IFS Drive but could not get the solution.I have to copy the spool file, Changed the Name of the Spool file, Create folder with the current date and  then i should access that folder from PC.Thanks,Deepak

Thanks Tom.All is working fine as expected. Thanks a lot for all the help.

It looked like an academic exercise to me. And the lack of useful response from the OP seemed to eliminate an “IT pro” learning question. I suspect the deadline for turning in the assignment has already passed. — Tom