|
View previous topic :: View next topic
|
| Author |
Message |
santoshramr
New User
Joined: 11 Nov 2009
Posts: 4
Location: Pune
|
|
|
|
Our requirement is below:
System 'A' stores Batch records with requested processing date for each record. Each Batch record will have one record in Batch table with processing date and multiple records in sub batch table with batch id as forign key.
On each processing day , System 'A' has to extract all the batches of that processing date. Need to generate a seperate file for each batch. This file contains the batch details and all the related sub batch details. Required to send the generated files to system 'B' using C:D .
Ex: The extraction job runs today ( 27th Mar) and there are 3 batches with processing date 27th MAR in system 'A' database. Need to generate 3 seperate files and send each file to System 'B' using C:D
Our soulution:
Set up an online schedular. Which runs daily and extracts all the batches of that processing date. After extracting each batch record, triggers a batch job and passes the key information of the batch record. The batch program under this batch job , retreives batch and corresponding sub batch details, generates the file and sends the file to system 'B'.
Could you please review this and let me know , if there is any better option.
Also would like to know, does this solution support, if the batch volumes are high such as 1000 per day? |
|
| Back to top |
|
 |
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India
|
|
|
|
| What your stake-holders have to say on this? |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
Well i have a nice solution, but (there is always a but(t)) :
It wil cost you, in real money like 600 euro's an hour. thats up front
then i will need some living accomodation, some ladies preparing my meals, a room with a fully installed IBM ZO/S box. Dark sunglasses against the glow of 200 screens, and jodium pills against all that japanese stuff. |
|
| Back to top |
|
|
santoshramr
New User
Joined: 11 Nov 2009
Posts: 4
Location: Pune
|
|
|
|
Thanks peter for your genrous offer !! but you made a right offer at wrong place sir !!
but ofcourse you deserve a special apreciation for giving an open offer without any specific choices about type ladies you want to cook for you, meal menu and kind of accomidation etc... I hope you won't miss them, when u offer a solution next time at right plce 
Cheers ! |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8796
Location: Welsh Wales
|
|
|
|
Yes Peter, I'm only charging 600 euro per day 
Why not use the schedular package that should already be in place |
|
| Back to top |
|
|
UmeySan
Active Member
Joined: 22 Aug 2006
Posts: 771
Location: Germany
|
|
|
|
@santoshramr !
Same as Expat said applies to me. Only 600 euro per day will be fine.
Ok, perhaps wie could make an arrangement regarding the money.
But two young cute, lascivious blondes are a must.
And not only for cooking. |
|
| Back to top |
|
|
|
|
