Re: Embedded Exec SQL versus SQL-CLI Performance (Link?)

I have used SQL-CLI In noxDB to bring relational data into the object graph
and it gives you the opportunity to create generic functions or API’s.

https://github.com/sitemule/noxDB

In the new version of noxDb that is all UTF8 I use a quite nice feature in
SQL-CLI wher you set the connection into UTF8 mode so all SQL statements
and data goes back and forth in UTF8 releasing me for lot of conversion
headaches

lør. 31. jul. 2021 kl. 03.09 skrev Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>:

I don't know a link, but I did use CLI to advantage - you are able to
have more than one cursor open at a time, each time you allocate a
statement (I think, it's been awhile), you can get the cursor the system
is using. There is an SQLGetCursorName function that I think was
helpful. In other words, you can multiple cursors active on the same table.

I wonder where you heard that performance would be poorer, I'm
interested to learn about that, if it's true.

Cheers
Vern

On 7/30/2021 3:03 PM, Alan Cassidy wrote:

Is there a link on-line comparing the relative general merits
comparing benefits of embedded SQL with SQL-CLI?

--Alan

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com