How to declare CURSORS with variable file names?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nuhbye
    New Member
    • Jul 2010
    • 6

    How to declare CURSORS with variable file names?

    How to declare a cursor where the name of the file to be user will be known at the run time?

    DECLARE userlist CURSOR for SELECT * from XXX JOIN tab1 ON XXX.a = tab1.a;


    XXX need to be variable.
Working...