Re: SQLSTATE 01004 now appears with v7.1 ? -- RPG400-L

Subject: Re: SQLSTATE 01004 now appears with v7.1 ?
From: Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>
Date: Tue, 25 Oct 2011 07:32:43 -0500
List-archive: <http://archive.midrange.com/rpg400-l>
List-help: <mailto:rpg400-l-request@midrange.com?subject=help>
List-id: RPG programming on the IBM i / System i <rpg400-l.midrange.com>
List-post: <mailto:rpg400-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=unsubscribe>

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

Follow-Ups:

Re: SQLSTATE 01004 now appears with v7.1 ? , Stuart Rowe

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.