DB2 Package Information

paul546 · #1 (**permalink**) 01-11-08, 09:06

I'm new to db2. Will someone please inform me of the file type for a db2 package and stored procedure?

ARWinner · #2 (**permalink**) 01-11-08, 11:27

What DB2 version and OS?

paul546 · #3 (**permalink**) 01-14-08, 12:06

Sorry for the delay. We're on version 8 on Unix

ARWinner · #4 (**permalink**) 01-14-08, 12:57

Quote:

Originally Posted by paul546

I'm new to db2. Will someone please inform me of the file type for a db2 package and stored procedure?

I am not sure what you are asking. What do you mean by "file type"? Packages are created either creating Stored procedures or binding applications to the DB. SQL Stored procedures are created directly with a CREATE PROCEDURE statement. External SPs are created with an appropriate compiler and then use the CREATE PROCEDURE statement.

Andy

Internet Services

Web Development

Digital Marketing

Consumer Tech