I have got a requirement as follows.

I am having a table RCBL_ERROR in a database in DB2.

I need to create a batch file, which has to extract the rows from this table
and write those extracted records to a text file.
And that text file needs to be placed in the folders ORD and BKUP.

The text file name should be "error_report_09302008.txt"
The error report name will be like error_report_<date>.

Since this is a batch job, can we schedule this batch job to run daily at 1
AM PST.

is it possible ?

If so can anyone give me some samples

Thanks in advance.

Krishnakanth

"Krishnakanth" <(E-Mail Removed)> wrote in message
news:12AE947D-D0A2-44E8-893C-(E-Mail Removed)...
>I have got a requirement as follows.
>
> I am having a table RCBL_ERROR in a database in DB2.
>
> I need to create a batch file, which has to extract the rows from this
> table
> and write those extracted records to a text file.
> And that text file needs to be placed in the folders ORD and BKUP.
>
> The text file name should be "error_report_09302008.txt"
> The error report name will be like error_report_<date>.
>
> Since this is a batch job, can we schedule this batch job to run daily at
> 1
> AM PST.
>
> is it possible ?

Sure you can do it. You can write a VB.Net or C#.NET Windows desktop
solution that has nothing on the form no Win controls on the Win from,
minimize the form so it's not seen.

You can run the program-name.exe in a batch file. You can even check the
return-code that the program would return to the batch, and process
accordingly based on the return-code.

You can also just make a Console Application that starts and ends itself
with no user interaction and just schedule the exe to run. You can do the
same with the Windows solution up a above there too and not even need a
batch file, just schedule the exe.