Re: SQL guru question

My only issue with that is that the date the file gets updated may change from the 5th to ???

So we need to check everyday just to be safe

I failed to mention that

I actually have a somewhat working version of it now

Its not the most logical process
But it does seem to work in our test system


---------------------------------
Sent from blackberry device


----- Original Message -----
From: midrange-l-bounces@xxxxxxxxxxxx <midrange-l-bounces@xxxxxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx <midrange-l@xxxxxxxxxxxx>
Sent: Tue Jun 10 07:35:17 2008
Subject: Re: SQL guru question

maybe I'm missing something here,
but its seem pretty simple to me..

create a CL to run a copy file command
with the *ADD option, it seems the date/time
field will take care of any key issues.
put the CL in the job scheduler to run at 3am on
the 6th..... problem solved...
do not understand your "daily" requirements...
if the file only gets replaced once a month on the 5th.
HTH

"Norbut, Jim" <Jim.Norbut@xxxxxxxxxxxxxxx> 6/9/2008 3:16 PM >>>

I have a file called headcount which gets data pumped to each month on
the 5th of the month.

FILEDATE EMPLOYEEID EMPLOYEESTATUS LASTNAME
Jun 5 2008 11:36PM 110886 Active Wong


Filedate is a CHAR(26) Field.
EmployeeID is a Char(41) Field
EmployeeStatus is a CHAR(50) Field
LastName is a CHAR(30) Field

I also have a file called HCARCHIVE
With the same exact definition which has all the data from previous
months in it.
(on the 5th of the month...that Headcount file gets overwritten with a
new version)

What I am looking to do is automate a daily process that says something
like
Insert into HCARCHIVE
Only the records from headcount if max(filedate) in headcount >
max(filedate) in hcarchive.
So that way the hcarchive file gets updated with the latest data
automatically w/o me having
To remember to do it.








The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Under Florida law, e-mail addresses are public records. If you do not want your e-mail address released in response to a public-records request, do not send electronic mail to this entity. Instead, contact this office by phone or in writing.