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

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

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.