OpenESQL Assistant with ADO.NET

Hi,

Could anybody please help me in automating this task using the OpenESQL Assistant for ADO.NET mode, since I have to rewrite the same code every time with slight changes such a cursor name and the query of course

      

    exec sql declare all_accounts_cursor dataset cursor for

      

        select * from account

      

    end-exec.

      

   

      

    exec sql

      

        open all_accounts_cursor

      

    end-exec.

      

   

      

    exec ado get cursor all_accounts_cursor into :accounts-dataset

      

        rename datatable as account_table

      

    end-exec.

      

   

      

    set result-set to accounts-dataset::Copy.

      

   

      

    exec sql

      

        close all_accounts_cursor

      

    end-exec.

Tags: