Re: SQLSTATE 01004 now appears with v7.1 ?

You lost your easy, "no recompile/rebind" advantage, then. Might as well have used /COPY. The original message I saw on this (a great idea, by the way) was to use a Service Program *because* that would mean one change, one place in the odd event that IBM makes another similar change. But of course this is all moot, since we all know IBM would _never_ do that. (Again.)
++
Dennis
++
"If you get up early, work late, and pay your taxes, you will get ahead - if you strike oil."
-- J. Paul Getty




Sent from my Galaxy tablet phone. Please excuse my brevity.
For any grammatic/spelling errors, there is no excuse.
++


"Stuart Rowe" <rowestu@xxxxxxxxx> wrote:

Joe,

I boxed them up in a module that is bound in where needed. I did not
use a
service program here since the code is A) very small, and B) never
changes.

Stu



On Tue, Oct 25, 2011 at 07:32, Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>
wrote:

On 10/25/2011 5:59 AM, Stuart Rowe wrote:

I've also written encapsulated procedures to deal with common SQL

needs,

like isSQLError( sqlca ), isSQLWarning( sqlca ), isSQLSuccess(

sqlca ),

isSQLRecordNotFound( sqlca ), and such as that. I pass myself the

entire

SQLCA since it is handy and contains everything needed including

error

message info for my sendSQLException( sqlca ).

Stu

That's a great idea, Stu. How do you include them? /COPY or via a
service program? I personally have something of a love/hate
relationships with service programs. I love everything they provide
right up to the point where they don't work very well (which is
typically when I'm calling them from Java; the toolbox support for
service programs is not as robust as the support for bound programs).

Joe
--
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 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.