Just write an CL program that returns those information an register this CL
Command as stored procedure.
Call this stored procedure from any SQL interface where you need this
information.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"


-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Dunk, Michael -
Bognor
Gesendet: Thursday, 05.4 2012 10:05
An: midrange-l@xxxxxxxxxxxx
Betreff: Jobname from a an SPL procedure?


As an infrequent user of SPL, writing a data fix, I figured out how to set
date and time stamps in CYYMMDD and HHMMSS format but also need a simple way
to get the job name and user profile from within the SQL procedure to
complete the data to include a standard record update stamp.

E.g. is there an elegant way of accessing Retrieve Job Attributes (RTVJOBA)
from within SPL?

Best regards,

Mike


----------------------------------------------------------------------------
--------------------------------
John Wiley & Sons Limited is a private limited company registered in England
with registered number 641132.
Registered office address: The Atrium, Southern Gate, Chichester, West
Sussex, United Kingdom. PO19 8SQ.
----------------------------------------------------------------------------
--------------------------------
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.



This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].