SQL PL

'''SQL PL''' is the procedural language written by IBM for its set of databases called Db2. There are different types of Db2, each for a different platform (The names had changedDb2: A Small but Significant Change http://ibmsystemsmag.com/blogs/db2utor/july-2017/db2-a-small-but-significant-change/IBM’s June Announcements About DB2 http://db2commerce.com/2017/06/23/ibms-june-announcements-about-db2/Revised naming for IBM Db2 family products https://www-01.ibm.com/common/ssi/cgi-bin/ssialias?infotype=an&subtype=ca&appname=gpateam&supplier=897&letternum=ENUS217-363):

• Db2 LUW - For Linux, UNIX and Windows.
• Db2 for i - For the mainframes previously called AS/400.
• Db2 for z - For z/OS mainframes.

The differences between these three implementations are described here: https://web.archive.org/web/20201026170456/https://www.ibm.com/developerworks/data/library/techarticle/db2common/

Previosly, Db2 was called DB2 UDB for Universal Database.

See also

• SQL PL in Wikipedia.
• Knowledge center - IBM Db2 LUW V11.1
• Knowledge center - IBM Db2 LUW V10.5
• SQL PL Guide
• List of Internet free resources about Db2

References

Tasks

• 100 doors
• 4-rings or 4-squares puzzle
• A+B
• Ackermann function
• Apply a callback to an array
• Associative array/Creation
• Comments
• Create a file
• Detect division by zero
• Determine if a string is numeric
• Documentation
• Empty program
• Exceptions
• Execute a system command
• Hello world!
• Hello world/Newbie
• Hello world/Text
• Here document
• Hostname
• Integer comparison
• Look-and-say sequence
• Loops/Break
• Loops/Continue
• Loops/Infinite
• Loops/While
• Luhn test of credit card numbers
• Multiline shebang
• Parametrized SQL statement
• Repeat a string
• SEDOLs
• Send email
• String case
• String length
• Substring
• System time
• Table creation
• Table creation/Postal addresses
• Test a function
• Trigonometric functions
• Validate International Securities Identification Number