Re: Retrieve JOB (not SYSTEM) date in SQL

["Jim Essinger" <dilbernator@xxxxxxxxx>]

When I have wanted to do this, I had the advantage of the job date being
stored in a one record control file (with other control values) and could do
a subselect from that record to get the date.  Since it was a single record
file, I always got the job date I needed.  Something like this;
INSERT INTO Lib_Name/File_Name (NBR, NAME, Added_Date)
VALUES(20,  'Bill', (Select job_date from control_file))

HTH

Jim

On Tue, Jun 3, 2008 at 3:35 PM, <MKirkpatrick@xxxxxxxxxxxxxxxxx> wrote:

> I want to populate a date column in a table with the JOB DATE (not SYSTEM
> DATE).  This is because we run for prior days on the current day.  I could
> do this by using a variable in RPG on my INSERT stmt but would like to
> avoid RPG and possibly do it using RUNSQLSTM.  CURRENT DATE gives me the
> system date.  How could I get the JOB date to use in my INSERT stmt.
> Thanks.
>
>
>
>
>
> This email and any files transmitted with it are confidential and intended
> solely for the use of the individual or entity to whom they are addressed.
>  Unless you are the addressee (or authorized to receive for the addressee),
> you may not use, copy or disclose to anyone this email or any information
> contained in this email.  If you have received this email in error, please
> advise the sender by replying to this email, and delete this email
> immediately.  Please note that any views or opinions presented in this email
> are solely those of the author and do not necessarily represent those of
> Western Dental Services, Inc.  Finally, the recipient should check this
> email and any attachments for the presence of viruses. Western Dental
> Services, Inc. accepts no liability for any damage caused by any virus
> transmitted by this email.