Results 1 to 3 of 3

Thread: Package in db2

  1. #1
    Join Date
    Jul 2014
    Posts
    294

    Unanswered: Package in db2

    Hi,

    I have a scenario & i accomplished that using 2 procedures . But my requirement is to make that 2 procedures into a single package. I am new to db2 , Now I came to know how to write procedures .
    what is a package in db2luw/udb?
    How can i combine 2 procedures into a Db2 package.Any steps to this conversion?
    can i debug a package as if I done for a procedure.

    can some one help me out .
    Last edited by HABBIE; 11-13-14 at 05:58.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    A "package" in DB2 is a routine that has been "bound" to the database. Basically this means that DB2 has created the access plan for the routine and stored it as a package. All of the SQL stored procedures get converted to a Package when they are created.

    Andy

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by HABBIE View Post
    How can i combine 2 procedures into a Db2 package.
    Do you mean may be DB2 modules? They are similar to PL/SQL packages, and you can use either in DB2. Both concepts are explained in the DB2 manuals.
    ---
    "It does not work" is not a valid problem statement.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •