Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2016
    Posts
    4

    Answered: Sysproc.admin_cmd ('declare c1 cursor...

    Dear all,
    how i can declare a cursor with SYSPROC.ADMIN_CMD?
    I assumed so:
    SYSPROC.ADMIN_CMD('DECLARE C1 CURSOR DATABASE dbname USER user USING 'pw' FOR SELECT * FROM Schema.table FOR FETCH ONLY');

    Thanks and best regards

  2. Best Answer
    Posted by db2mor

    "You cannot do that with admin_cmd, which is for ruñing commands, it is not for runing SQL."


  3. #2
    Join Date
    Apr 2012
    Posts
    1,006
    Provided Answers: 16
    You cannot do that with admin_cmd, which is for ruñing commands, it is not for runing SQL.

Posting Permissions

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