RE: SQLCOD definition -- RPG400-L

Subject: RE: SQLCOD definition
From: "Dennis Lovelady" <iseries@xxxxxxxxxxxx>
Date: Mon, 03 May 2010 05:07:03 -0400
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>

I tried to put a temporary file in a program that catches the sql
commands executed. I created a table in an sql session with using the
same names as in the rpg program so it would be automatically
populated.
How should I have declared the fields sqlcod or sqlcode in the table so
that they had the same definition in the rpg?

Hi, David:

If you compile an RPG SQL program, the generated print file has a cross
reference by default. If you look at that cross reference, you will be able
to see these variables. To help you out, the listing is alphabetized.

HTH

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"If you become a star, you don't change, everyone else does."
-- Kirk Douglas

Follow-Ups:

RE: SQLCOD definition , David FOXWELL

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.