Re: HEY!!: SQL5011 error when accessing remote (seperate LPAR) DB

Doug
We've always been able to use SQL against other systems. Have to define a relational database entry for the remote system, then create a package on that system. Then your program needs to set a connection to that system. Can't use local DDM files at all with SQL.

Vern

Sent from my Samsung Epicâ 4G

Douglas Belcher <dougdbkv@xxxxxxxxx> wrote:

Stephen,

I did not know you could use SQL on remote systems because everytime I've
tried in the past, i.e. use DDM, I could not connect or access the file with
SQL. Could that be part of the problem?

Doug Belcher
St Louis, MO
314-766-4461



On Tue, Sep 7, 2010 at 8:28 AM, Needles,Stephen J <SNEEDLES@xxxxxxxxxxxxx>wrote:

I really need a bit of feedback here!!

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Needles,Stephen J
Sent: Friday, September 03, 2010 9:58 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: SQL5011 error when accessing remote (seperate LPAR) DB

I am getting an SQL5011 error when compiling my program.

The error states:

"Position 25 Host structure array TWFPDFDS not defined or not usable."

This is part of an SQL to fetch multiple rows into a data structure.

This is the data structure:

D TWFPDFDs E Ds Extname(TWFPDF) occurs( 9999
)

The TWFPDF table resides on a remote system i.

Here is the bit of the RPG code:

Exec sql SET CONNECTION :srcBox ;
Exec sql SET schema :srclib ;

Exec Sql DECLARE input CURSOR FOR
Select * from TWFPDF;
exec sql open input;
exec sql fetch input for 9999 rows
into :TWFPDFDS;

The compile error happens on this fetch. I've done this before and I am
actually cloning an existing process that works...the only unusual item
might be this table's definition.

It only contains three columns; the first two are character and are 17 and
20 characters. The third and final column is a *BLOB.

Is this BLOB the problem?

I need to send the data within this table across LPARs on a monthly
schedule. Just trying to evaluate possibilities other than
save/FTP/restore.

Thanks!

Steve Needles


==============================================================================
This communication, including attachments, is confidential, may be subject
to legal privileges, and is intended for the sole use of the addressee. Any
use, duplication, disclosure or dissemination of this communication, other
than by the addressee, is prohibited. If you have received this
communication in error, please notify the sender immediately and delete or
destroy this communication and all copies.

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




==============================================================================
This communication, including attachments, is confidential, may be subject
to legal privileges, and is intended for the sole use of the addressee. Any
use, duplication, disclosure or dissemination of this communication, other
than by the addressee, is prohibited. If you have received this
communication in error, please notify the sender immediately and delete or
destroy this communication and all copies.

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

--
Doug Belcher
St Louis, MO
314-766-4461
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.