How can we View the DB2 Procedure and How can we execute the DB2 Procedure and just see the output of the procedure using DB2

db2 db2-400
Someone picture Someone · Aug 4, 2010 · Viewed 25.9k times · Source

How can we View the DB2 Procedure (I mean what logic they have written ) and How can we execute the DB2 Procedure and just see the output of the procedure using DB2

Answer

Liju Mathew picture Liju Mathew · Dec 29, 2010

DB2 stores the system related tables under syscat schema. So a query on syscat.routines will give you the Stored Procedure content.

A typical example: if you got a stored procedure by the name update_employee, the below query works:

select text from syscat.routines where routinename = 'update_employee'

Using the db2 describe command, you can see the table schema and can determine which all columns you want to view.

Invoking a stored procedure is already answered in "How to call a stored procedure in IBM System i Access for Windows GUI Tool" and you can refer that. (Eg: call myStoredProc(parm1, parm2, ?); )

I suggest you read the DB2 stored procedure details from IBM website.

Related questions

How to add a not null constraint in an existing column in DB2 iSeries?

I have tried the following scripts to add a not null constraint to my column. ALTER TABLE MYDB.RULES ALTER TYPEID SET NOT NULL; ALTER TABLE MYDB.RULES ALTER COLUMN TYPEID SET NOT NULL; I also get this error when …

Read More
Add a column to a DB2/400 table with a specific ordinal position

Is there an SQL command on the AS400/iSeries/System-i/whatever to add a column to a table in a specific ordinal position, or moving an existing column to a different position?

Read More
DB2 400 drop column

I want to drop a column called id which is an auto incrementing PK. The SQL: alter table "CO88GT"."XGLCTL" drop column id cascade; And I get: Error: [SQL0952] Processing of the SQL statement ended. Reason code 10. SQLState: 57014 ErrorCode: …

Read More