The OS/390 REXX language offers an interface to DB2 so that REXX programs can use SQL DML and execute IFI commands. Even though REXX is an interpreted language, DB2 provides the same capabilities as other languages in that a REXX program can run in any OS/390 address space, and REXX programs can run as stored procedures. In fact, a stored procedure written in REXX was delivered with this feature, as it is one of the many components of the SQL procedures implementation.

You can write SQL application programs in the REXX programming language, and dynamic SQL is issued from REXX with no precompiles or link edit. REXX is an interpreted language and has been around for a long time. It is SYSPROG and “techie-loved,” and you can build quick and ...

Get DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.