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.