batch job to extract data from tables in DB2

[=?Utf-8?B?S3Jpc2huYWthbnRo?=]

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_0 9302008.txt"
The error report name will be like error_report_<d ate>.

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

[Mr. Arnold]

Re: batch job to extract data from tables in DB2


"Krishnakan th" <Krishnakanth@d iscussions.micr osoft.comwrote in message
news:12AE947D-D0A2-44E8-893C-CA6A59DD427C@mi crosoft.com...

>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_0 9302008.txt"
The error report name will be like error_report_<d ate>.
>
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.