User Profile

Collapse

Profile Sidebar

Collapse
appunni
appunni
Last Activity: Aug 13 '07, 03:48 AM
Joined: Aug 10 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • appunni
    replied to Db2
    in DB2
    Option B wiol be true if u r not applying any external commit...
    See more | Go to post

      Leave a comment:

    • appunni
      started a topic DB2 Z/OS Stored proc help
      in DB2

      DB2 Z/OS Stored proc help

      Hi,

      I am trying to execute an DB2 SQL stored proc in mainframe.

      my proc is

      CREATE PROCEDURE db2t.abuproc
      ()
      LANGUAGE SQL
      external name abuproc
      wlm environment dbatspas
      BEGIN
      UPDATE DBXR.PRTTAB SET NUMBER=10 WHERE NUMBER=0;
      end?

      But when am executing it thru coammnd line editor, am gtting SQLERROR -444...

      it...
      See more | Go to post
      No activity results to display
      Show More
      Working...