[foxboro] IA Batch Reporting


Report Manager in IA Batch uses a variant of SQL to generate reports. I would
like to generate a report for the last 24 hours (or previous day) using a SQL
script. However, there is no information on RptSQL?s (the SQL editor for IA
Batch) SQL syntax. Specifically on how to use and manipulate the date and
date-time variables, so that the reports can be generated for a certain period.
Any information or sample scripts would be appreciated.
Thanks,
Jon Simon
Lever Pond's South Africa
 
 
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
 
foxboro mailing list:             http://www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave

Other related posts: