[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] check datetime stamp on file
- Subject: RE: [sqr-users] check datetime stamp on file
- From: "Alexander, Steve" <Steven.Alexander@sanjoseca.gov>
- Date: Mon, 30 Aug 2004 09:22:39 -0700
- Delivery-date: Mon, 30 Aug 2004 11:26:09 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
There is no SQR function to get the datetime of a file. You have to use
"call system" to pipe an "ls -l" command into a file, then read and parse
the directory listing. Unix will show the date in different formats
depending on how recent the datetime is.
-----Original Message-----
From: Yuri Lakef [mailto:lakef250@yahoo.com]
Sent: Monday, August 30, 2004 8:05 AM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] check datetime stamp on file
RESEND:
Anyone know how to determine datetime of a file programmatically?
Yuri Lakef <lakef250@yahoo.com> wrote:Greetings to all,
I'd like to add a procedure in my SQR to call the operating system and check
if a file exists or not (SQR reads a file and loads a table). If it does
exist, I'd like to check the datetime stamp for the file and only process if
it matches "today's date."
Are there operating system (or better yet, SQR) functions/features that
allow this? We're on Unix AIX and NT.
Much thanks!
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users