Results 1 to 3 of 3
  1. #1
    Join Date
    May 2015
    Posts
    1

    Unanswered: “P1: begin” and “P2: begin” in a DB2 Stored Procedure

    Can anyone explain to me or point me to some documentation on why the stored procedures are tagged into different parts using "P1: begin" and "P2: begin" ? Thanks, Mike

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Read the documentation about the purpose(s) of optional labels in SQL procedures and compound SQL.

  3. #3
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Usually labels are used with GOTO, a programming practice that I am avoiding.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

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
  •