|
DB2 ist ein Produkt der
IBM Corporation. Bitte Copyright- und Trademark-Hinweise beachten!
http://www-1.ibm.com/support/docview.wss?rs=64&uid=swg27008781
UDF to switch between LRSNs and timestamps Forum/discussion group
Abstract
This sample code creates two user-defined functions (UDFs) to allow either a timestamp value to be converted to an LRSN value or an LRSN value to converted to a timestamp value.
Content
This sample contains the following attachments:
FUTTLRSN is the code for converting a timestamp value to an LRSN value.
FUTLRSNT is the code for converting an LRSN value to a timestamp value.
ASMJOB is the assemble deck to create the load modules from the source.
UDF_DEFINE contains the definitions for the UDFs.
UDF_TEST contains the example SQL statements to demonstrate that the UDFs work.
Example submitted by: Peter Lenart, Futurex Computing Limited
Rate this example
User comments on this example:
"Just brilliant"
"very nice"
"Brilliant! This helped me a lot! You are a god!"
Notice: This example is from the DB2 Examples Trading Post and is provided on an "as-is" basis. You may copy and modify this example in any form without payment to IBM, for the purposes of designing and developing application programs conforming to the application programming interface for the z/OS or OS/390 operating system for which these examples are written. This example has been tested, but it has not been thoroughly tested under all conditions. IBM, therefore, cannot guarantee or imply reliability, serviceability, or function of this example in your particular environment. Use this example as a model for your own situations
P.S. Please pass my address to anyone interested in DB2 HOTLINE - thank you.
With kind regards
Michael Dewert, Software Group
DB2 Development
DB2 Information Management Software
© Gernot Ruban