RE: sql database in RPGLE program with lots of columns -- RPG400-L

No, I was using Scott's example reading the result set. It is a large number of fields, the reason why I was wondering if there is a more efficient way. This is the first time I have used an SQL database in an RPG program so I am pretty ignorant, other than what I read

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: Tuesday, December 11, 2012 4:21 PM
To: RPG programming on the IBM i / System i
Subject: Re: sql database in RPGLE program with lots of columns

Just curious. Is this one of those deals where you are returning array of records instead of using result sets? The number of fields you are returning makes me wonder.

On Tue, Dec 11, 2012 at 2:13 PM, Kim Massar <kmassar@xxxxxxxxx> wrote:

Writing them to a work file, physical file not qtemp

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Charles Wilt
Sent: Tuesday, December 11, 2012 3:50 PM
To: RPG programming on the IBM i / System i
Subject: Re: sql database in RPGLE program with lots of columns

What are you doing with the data once it's mapped into RPG variables?

Charles

On Tue, Dec 11, 2012 at 3:33 PM, Kim Massar <kmassar@xxxxxxxxx> wrote:

HI all,
I previously sent a question on reading an SQL db in an RPGLE
program using Scott Klement's example code, which I got to work. I
have a follow up question. I have a db with 165 columns of which I
will be getting 140 of those columns. When I read thru the result
set, do I need to list all 140 columns like this:

dow (jdbc_nextRow(rs));
RecordId = jdbc_getCol(rs:1);
SsnId = jdbc_getCol(rs:2);
Etc...

Or is there a more efficient, faster way. By faster, I mean
processor speed.

Thanks

Email Confidentiality Notice: The information contained in this
transmission is confidential, proprietary or privileged and may be
subject to protection under the law, including the Health Insurance
Portability and Accountability Act (HIPAA). The message is intended
for the sole use of the individual or entity to whom it is addressed.
If you are not the intended recipient, you are hereby notified that
any use, distribution, copying or printing of this message is
strictly prohibited and may subject you to criminal or civil
penalties. If you received this transmission in error, please
contact the sender immediately by replying to this email and then
delete the material from

any computer.

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

Email Confidentiality Notice: The information contained in this
transmission is confidential, proprietary or privileged and may be
subject to protection under the law, including the Health Insurance
Portability and Accountability Act (HIPAA). The message is intended
for the sole use of the individual or entity to whom it is addressed.
If you are not the intended recipient, you are hereby notified that
any use, distribution, copying or printing of this message is strictly
prohibited and may subject you to criminal or civil penalties. If you
received this transmission in error, please contact the sender
immediately by replying to this email and then delete the material from any computer.
--
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.

Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA). The message is intended for the sole use of the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any use, distribution, copying or printing of this message is strictly prohibited and may subject you to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and then delete the material from any computer.