Re: Select/Update Loop in SQL

Personally, I'd look at some way to send all the BLOBs in one shot...

Them you'd could go back and mark them as sent.

Charles

On Mon, Apr 9, 2018 at 11:14 AM, Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:

He needs the cursor to read the BLOB columns, so I'd think he might as
well use the cursor for the update.



-----Original Message-----
From: Raul Jager [mailto:raul@xxxxxxxxxx]
Sent: Monday, April 09, 2018 11:37 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: Select/Update Loop in SQL

RPG does not likes blobs, you can create a view without the blob to chain
or read sequentially, you can update the record, but to send the blob you
need SQL


On 04/09/2018 11:52 AM, Art Tostaine, Jr. wrote:

It's sending the Blob to another system and updating the row that it's
been sent.

Art

On Mon, Apr 9, 2018 at 11:47 AM, Charles Wilt <charles.wilt@xxxxxxxxx>
wrote:

The RPG is updating the BLOB?

What exactly is being done?

Charles

On Mon, Apr 9, 2018 at 9:40 AM, Art Tostaine, Jr.
<atostaine@xxxxxxxxx>
wrote:

Thank you Charles. I am using a BLOB so I need to use SQL.

On Mon, Apr 9, 2018 at 11:26 AM, Charles Wilt
<charles.wilt@xxxxxxxxx>
wrote:

Do you really need to do this in a cursor?

SQL is best for set at a time processing...

You might as well stick with RPG rather than use SQL for RLA...

Charles

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our
affiliate
link: http://amzn.to/2dEadiD

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our
affiliate
link: http://amzn.to/2dEadiD

-- Este e-mail fue enviado desde el Mail Server del diario ABC Color --
-- Verificado por Anti-Virus Corporativo Symantec --

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD