Does DB2 have a programming language?

Post #78,416 by tablizer 1/31/03 1:05:27 PM Reply	Does DB2 have a programming language? You know, like PL/SQL, Transact SQL, etc. I have never seen any books or docs show a procedural language built into DB2. ________________ oop.ismad.com
Post #78,470 by morganek 1/31/03 4:09:29 PM Reply	Re: Does DB2 have a programming language? They didn't when I used to use it. But, it looks like they've added what they call [link\|http://www-3.ibm.com/software/data/db2/udb/ad/v7/adg/db2a0/sqlproc.htm#HDRPSMUSNG\|SQL Stored Procedures] Back when I used DB2, you wrote your stored procedure/function in REXX, C, or COBOL and then registered it into the database. It was a painful process. I have not used the SQL Stored Procedure, but it looks like it fits what you're asking. -Mike
Post #78,667 by gdaustin 2/1/03 6:10:28 PM Reply	Re: Does DB2 have a programming language? 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

Welcome to IWETHEY!