User Profile

Collapse

Profile Sidebar

Collapse
JUKe
JUKe
Last Activity: Jul 29 '11, 12:46 PM
Joined: Apr 27 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • JUKe
    started a topic opening a ref cursor in dynamic sql
    in DB2

    opening a ref cursor in dynamic sql

    i have a stored procedure, with a ref cursor variable as an out parameter say cur_v, which creates a table, say tab_abc, in the execute immediate statement.

    so i populate tab_abc in the body of the stored procedure.

    and at the end of the procedure i need to open the cursor, cur_v with the contents of the table, tab_abc.

    a simple "open... select.. from... " would suffice, but the table is non...
    See more | Go to post
    • JUKe
      replied to How to alter a column from NULL to NOT NULL?
      in DB2
      alter table <table_name> alter column <column_name> drop not null
      See more | Go to post

        Leave a comment:

      No activity results to display
      Show More
      Working...