Thanks for your reply. The udts will be going so they won't be a problem.
The cursor I referred was the same as the one that you say is "normal" in
DB2. That's a relief. I have the very book you mentioned in front of me!

Have you had any success using ER/win templates to convert stored procs?

Adam
"AK" <ak_tiredofspam@yahoo.com> wrote in message
news:46e627da.0401161512.4f804abc@posting.google.c om...
> Adam,
>
> > good. It doesn't seem to handle user-defined datatypes even though they
> > exist in db2 but I can manually tweak the code.
>
> please be careful: user-defined datatypes in DB2 are very different
> from user-defined datatypes in MS SQL Server.
>
> > I'm more concerned, however,
> > about the fact that the converted db2 stored procedures use cursors
while
> > the MS SQL procs do not.
>
> In SQL Server you can just write
> SELECT * FROM SOME_TABLE
> in an SP, the client will get a result set
>
> To accomplish the same in DB2 you have to open a cursor, that's
> normal.
> Are you speaking about that?
>
> There is a great book:
>
>
> DB2 SQL Procedural Language for Linux, Unix and Windows
> Paul Yip, Drew Bradstock, Hana Curtis, Michael X. Gao, Zamil
> Janmohamed