Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Tricky scenario

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
useit

Active User


Joined: 05 Oct 2006
Posts: 144

PostPosted: Wed Aug 31, 2011 12:09 pm    Post subject: Tricky scenario
Reply with quote

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
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7307

PostPosted: Wed Aug 31, 2011 12:32 pm    Post subject: Reply to: Tricky scenario
Reply with quote

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 :-)
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Aug 31, 2011 7:20 pm    Post subject:
Reply with quote

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...
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Aug 31, 2011 8:55 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1756
Location: UK

PostPosted: Thu Sep 01, 2011 12:05 am    Post subject:
Reply with quote

Quote:
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.

If you are running at 5pm how do you expect to get data that is after 5pm? Got that time machine warmed up?
Back to top
View user's profile Send private message
John Albert B. Sison

New User


Joined: 06 Sep 2011
Posts: 1
Location: Philippines

PostPosted: Sat Oct 15, 2011 8:15 pm    Post subject: Re: Reply to: Tricky scenario
Reply with quote

Quote:
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.


I agree with Bill...


Quote:
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.


Goods in and goods out creation jobs that run every hour must not run after the one time feed.


Quote:
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.


Why run the one time feed job if there are still goods in and out file to be processed? Or why run the one time feed job prior to the run of the jobs it is dependent on?

It is most tricky for people who read your problem but does not know the real process behind it.

My very first post, please bear with me.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Tricky sort logic required pgopi92 DFSORT/ICETOOL 3 Mon Jan 25, 2016 3:29 pm
No new posts Assistance required for WHEN=GROUP sc... thirumalasetty JCL & VSAM 8 Wed Sep 10, 2014 12:56 am
No new posts OUTREC S0C7 issue for particular scen... Skolusu DFSORT/ICETOOL 6 Fri Mar 07, 2014 1:10 pm
No new posts Tricky requirement using sort N.Nirmal Raj DFSORT/ICETOOL 5 Tue Oct 01, 2013 10:54 pm
No new posts ADRDSSU code scenario enrico-sorichetti JCL & VSAM 3 Fri Jan 25, 2013 2:50 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us