Skip to Content
0
Former Member
Apr 24, 2007 at 10:53 AM

How to check the tet file data in the application server with database data

25 Views

Hi all,

My requirement is like this.I have already done my prog.i have

completed.After completion of my creation of sales orders i am

copying the text file data into 'Z' table for proof.

but this is new requirement they have given to me.pls if any

one knows solution pls help me.

1). If suppose 10 records are present in my text file.If any

one record is not in the master data in the data base then no

sales order should be created.and also check that data is

already present in the my 'Z' table.if both conditions

satisfied means,Then only that file has to be deleted from the

application server.

2). If suppose 50 records are present in the text file.If the

program is running online.If all records are present in the

data base also.but,only 25 records are only created sales

orders.but remaining 25 records are not created sales orders

due to net work problem.so now no record has to create the

sales orders.is it possible like this?

3). Error log file should be maintained in the program and

that file also sent to that server.Because even user also has

to see the errors happened in the program.how we have to do

that one?

Pls if any one has idea of all these requiremnets pls help me

with example coding.pls.

regards,

lokesh.