Re: Retrieve JOB (not SYSTEM) date in SQL

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.