Using a Parameter table to tell SQL when to look for a file

%3CLINGO-SUB%20id%3D%22lingo-sub-828478%22%20slang%3D%22en-US%22%3EUsing%20a%20Parameter%20table%20to%20tell%20SQL%20when%20to%20look%20for%20a%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-828478%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20automate%20a%20process%20that%20will%20populate%20a%20table%20with%20all%20transactions%20that%20occurred%20the%20previous%20day.%26nbsp%3B%20I%20have%2025%20different%20groups%20that%20receive%20these%20transactions.%26nbsp%3B%20The%20problem%20is%20that%20not%20every%20group%20receives%20transactions%20every%20day.%26nbsp%3B%20Some%20will%2C%20others%20only%20receive%20them%20Monday%20through%20Friday%20and%20still%20others%20receive%20them%20only%20once%20a%20week%20or%20twice%20a%20month.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20a%20group%20should%20not%20have%20received%20a%20file%20yesterday%2C%20I%20need%20to%20program%20that%20so%20the%20system%20doesn't%20go%20and%20look%20for%20yesterday's%20file%20for%20that%20group.%26nbsp%3B%20My%20first%20impression%20is%20to%20provide%20a%20static%20parameter%20table%20that%20will%20list%20each%20group%20and%20the%20days%20of%20the%20week%20that%20each%20group%20will%20receive%20a%20file%3A%20for%20example%2C%201%2C2%2C3%2C4%2C5%2C6%2C7%20for%20daily%20or%202%2C3%2C4%2C5%2C6%20for%20Monday%20through%20Friday.%26nbsp%3B%20However%20I%20am%20open%20to%20suggestions%20if%20there%20is%20an%20easier%20way.%26nbsp%3B%20I%20just%20need%20to%20accurately%20know%20if%20we%20missed%20a%20file%20or%20not.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20appreciated%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJ%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

Hello All,

 

I am trying to automate a process that will populate a table with all transactions that occurred the previous day.  I have 25 different groups that receive these transactions.  The problem is that not every group receives transactions every day.  Some will, others only receive them Monday through Friday and still others receive them only once a week or twice a month.

 

If a group should not have received a file yesterday, I need to program that so the system doesn't go and look for yesterday's file for that group.  My first impression is to provide a static parameter table that will list each group and the days of the week that each group will receive a file: for example, 1,2,3,4,5,6,7 for daily or 2,3,4,5,6 for Monday through Friday.  However I am open to suggestions if there is an easier way.  I just need to accurately know if we missed a file or not.

 

Any help is appreciated,

 

J

 

0 Replies