User Profile

Collapse

Profile Sidebar

Collapse
rjj1
rjj1
Last Activity: May 8 '12, 10:17 PM
Joined: Jan 23 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • rjj1
    replied to DB2 Nested Stored Procedures and labeled_begin_atomic error
    in DB2
    I called each stored procedure separately in my stored procedure, and it works now.

    [code]
    CONNECT RESET
    $
    CONNECT TO MAXDB71

    $
    DROP PROCEDURE ARC.ARC_RESTORE
    $

    CREATE PROCEDURE ARC.ARC_RESTORE ()
    LANGUAGE SQL
    BEGIN ATOMIC
    DECLARE stmt varchar(32000) default ' ';

    set stmt = '
    CALL ARC.arc_disable _trig(''MAXIMO' ',''WORKLOG_T'' )
    ';
    ...
    See more | Go to post

      Leave a comment:

    • rjj1
      started a topic DB2 Nested Stored Procedures and labeled_begin_atomic error
      in DB2

      DB2 Nested Stored Procedures and labeled_begin_atomic error

      In DB2 UDB, I call a stored procedure, which in turn calls a number of other stored procedures. I am used Command Editor.

      Here is the call which fails and the error message:
      call arc.arc_restore ;
      ------------------------------------------------------------------------------
      call arc.arc_restore
      SQL0104N An unexpected token "CALL ARC.ARC_DISABLE _TRIG('MAXIMO', 'WORKLOG_T"
      was found following...
      See more | Go to post
      No activity results to display
      Show More
      Working...