Tricky scenario

useit · Active User Joined: 05 Oct 2006 Posts: 152

Hi,

my requirement is something like below.

>End of the day store will send the final count(snap shot).final count on each product in the store.

>using this i have to build what is the available count of each product throughout the day.

1)- any goods in Add to count
2) - any goods out subtract from count.

say example:

one time feed from the denver.(File1)
store product count
aaa apple 1000
bbb tomoto 2000

goods in file:(File2)

store product count
aaa apple 200
bbb tomoto 100

goods out file:(File3)

store product count
aaa apple 20
bbb tomoto 10

so in my case my output file will have

final output (File4)

store product count
aaa apple 1180 (1000+200-20)
bbb tomoto 2090 (2000+100-10)

so next time onwards if there is any goods in or
goods out i ll add or subtract from final output.(this process ll continue till i get the next feed) .
when i get the next feed i will refresh the entire data and follow the same process.

problem here is.

this goods in creation job and goods out creation job ll run every hour and.The one time feed can be any time
between 4pm and 6pm depending on the store. but goods in and goods out file will have time stamp is added to it.

so if my one time feed job run at 5 o clock. i have to extract the record which is greater than 5 o clock
from goods in and goods out file.

one time feed will not have timestamp info. so is there any way we can extract based on the job timings?

if one time job runs at 4.30 i should fetch all ther records which is greater than 4.30 from goods in good out file?

i would really appreciate if someone can help me on this.

Regds,
useit

Bill Woodger · Posted: Wed Aug 31, 2011 12:32 pm

I'm guessing this is to do with those GDGs again?

The thing is, by far the best way, is to design the whole thing first. Starting from how the business operates/wants to operate and getting to how that is implemented first at a high level, and then getting down to more detail.

Then you shouldn't run into problems like this at this stage.

No, you never want to try to use anything to do with system time/date other than as a reference to connect something to a particular JOB.

Think of it this way. You once have to "re-run" part of the work. Oh no you don't, because you've coded to make it impossible :-)

Anuj Dhawan · Posted: Wed Aug 31, 2011 7:20 pm

Unfortunately, Your explnation is not very clear and pretty lengthy, too. By what I can understand, may be you can ask the other-team to send you timestamp also as one of the fields in your in- and out-feeds...

dick scherrer · Posted: Wed Aug 31, 2011 8:55 pm

Hello,

Why do you ask this in JCL?

There needs to be some actual application design and then an implementation.

Once you have done the design work, post what you intend to do and someone here will have suggestions.

Nic Clouston · Posted: Thu Sep 01, 2011 12:05 am

John Albert B. Sison · Posted: Sat Oct 15, 2011 8:15 pm