Treffer: Calling RPG from SQL: External UDFs to Extend SQL.

Title:
Calling RPG from SQL: External UDFs to Extend SQL.
Authors:
Noll, Lynne1
Source:
System iNEWS. Aug2007, Issue 334, Special section p23-27. 5p. 1 Illustration, 2 Charts.
Subject Terms:
RPG (Computer program language), SQL, Object linking & embedding, Java programming language, Databases
Database:
Supplemental Index

Weitere Informationen

The article offers information on user-defined functions (UDFs) that provide a simple way to call Report Program Generator (RPG) procedure functions from Structured Query Language (SQL). A UDF works in Visual Basic SQL statements running under object linking and embedding database (OLE DB) or open database connectivity (ODBC) as well as in Java over Java database connectivity (JDBC). The SHORTDATE and LONGDATE functions allow users to show dates with the month spelled out.