Re: SQLCLI program calling another SQLCLI program. -- RPG400-L

Subject: Re: SQLCLI program calling another SQLCLI program.
From: Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>
Date: Thu, 07 Feb 2008 13:34:37 -0600
List-archive: <http://archive.midrange.com/rpg400-l>
List-help: <mailto:rpg400-l-request@midrange.com?subject=help>
List-id: RPG programming on the AS400 / iSeries <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>

JLong@xxxxxxxxxx wrote:

I have 2 programs using SQLCLI. Both are standalone programs and function perfectly when called directly. Now I want pgmA to call pgmB but I have a CLI error on my SQLConnect(...). rc = -1.

When an SQL CLI procedure fails, you need to call SQLError() to determine why it failed. (-1 only means "SQL_ERROR", and doesn't tell you anything more than "an error occurred".) Call SQLError to get an SQLState or SQLCode that will tell you which error occurred.

Follow-Ups:

Re: SQLCLI program calling another SQLCLI program. , JLong

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.