RE: Accessing Remote Database using SQL - requesting an SQL Package?

Sorry if you feel attacked, Alan; that was not my intention :-) But my
first post was not addressing you, but 'aec', who only suggested: 'What
about SQLCLI?
Would that handle a CLOB?'.

As for complicated:

Embedded:
- exec sql execute immediate :sqlstm;

CLI:
- Allocate environment
- Allocate connection
- Connect
- Set connection attributes
- Allocate statement
- Execute statement
- Disconnect
- Free connection handle
- Free environment handle

Hm. ;-)

Joep Beckeringh


"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 29-07-2014 23:46:35:

Alan Cassidy <ACassidy@xxxxxxxxxxxxxx>

Date:

29-07-2014 23:46

Subject:

RE: Accessing Remote Database using SQL - requesting an SQL Package?

At some point Stephen's program with embedded SQL got this error
message.
Replacing the embedded SQL with the more complicated CLI (which

probably

eventually will use the same underlying technology) and hoping the

problem

will go away seems rather far-fetched.

Sort of like: "My RPG program is giving a run time error!" - "Try

programming

it in C++".

Joep Beckeringh

It's a good point, but I wasn't "hoping it would go away"! I was
just asking!
And maybe it doesn't look that much more complicated to me!