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
exec ado get cursor all_accounts_cursor into :accounts-dataset
rename datatable as account_table
set result-set to accounts-dataset::Copy.