There's a language built into DB2 called SQL PL, I guess as an answer to PL/SQL in Oracle.

But, if you're doing stored procedures, you can write them in C, C++, Java or SQL PL.

There's a GUI tool in the DB2 Admin Client called the Stored Procedure Builder, that guides you through a GUI to build a stored procedure, but I don't know what the final language is (C, Java?)

Finally, straight SQL commands can be run in batch from a command line db2. Just type db2 from a command prompt or shell prompt and you're at a db2 prompt. You can use pipes and send them in, too.

I do stuff like this all the time:

db2 < createRawMsgTable

Which is a db2 SQL command to create a database table.

Glen Austin