Advertisement
PaulBailey

RPG Subroutine Calling C_EVENT

Apr 4th, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.22 KB | None | 0 0
  1. // ...
  2. w_eventKey = %trim(sPolicyID); //sPolicyID is defined LIKE(w_eventKey)
  3. w_processed = 'N';
  4. EXEC SQL CALL C_EVENT(
  5. :lFileID,
  6. :w_eventKey,
  7. :w_processed) ;
  8. If SQLCOD = 466;
  9. // A resultset has been returned
  10. sql_error = *OFF;
  11. ElseIf SQLCOD = 100;
  12. // No data found but we don't need an error message
  13. sql_error = *ON;
  14. Else;
  15. S#STMT = 'CALL C_EVENT';
  16. ExSr CheckSQLError;
  17. EndIf;
  18. if sql_error = *OFF;
  19. EXEC SQL associate RESULT SET LOCATOR (:C_EVENT_rs)
  20. WITH PROCEDURE C_EVENT;
  21. EXEC SQL ALLOCATE C_EVENT_C CURSOR
  22. FOR RESULT SET :C_EVENT_rs;
  23. S#STMT = 'ALLOCATE C_EVENT_C';
  24. ExSr CheckSQLError;
  25. // The C_ procedures return the created file record
  26. // back as a resultset
  27. EXEC SQL FETCH NEXT FROM C_EVENT_C INTO :C_EVENT_Row;
  28. S#STMT = 'FETCH C_EVENT_C';
  29. ExSr CheckSQLError;
  30. // ...
  31. EXEC SQL CLOSE C_EVENT_C;
  32. // ...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement