Tag: IBM

Community

Stored Procedures and DB2

(Troy Coleman) Have you ever wanted to issue a DB2 command from your program? It’s actually possible, thanks to stored procedures. Procedure SYSPROC.ADMIN_COMMAND_DB2 allows you to issue DB2 commands. Information on this and other administrative stored procedures is available in the Administration G

Community

A Case for CASE

(Skip Marchesani) The CASE operation is common to several programming languages on the IBM i. This includes SQL in DB2 for i, where it is available as the CASE statement for use in conjunction with a SELECT statement, or CASE expression for use in conjunction with the DB2 for i SQL Procedure Languag