Re: ProC Hosts arrays
From: Maciej <mprzewozny_at_gmail.com>
Date: 5 Jul 2006 08:43:32 -0700
Message-ID: <1152114212.838700.217760_at_m79g2000cwm.googlegroups.com>
exec sql end declare section;
Date: 5 Jul 2006 08:43:32 -0700
Message-ID: <1152114212.838700.217760_at_m79g2000cwm.googlegroups.com>
I would try pointers:
double col[2][2];
exec sql begin declare section;
double *pcol00 = &col[0][0]; double *pcol01 = &col[0][1]; double *pcol10 = &col[1][0]; double *pcol11 = &col[1][1];
exec sql end declare section;
exec sql
select col_1, col_2, col_3, col_4
into :pcol00, :pcol01, :pcol10, :pcol11
from etc;
You can also use bulk fetch to fill the host arrays. That works well if one of the dimensions is related to cardinality.
Maciej Received on Wed Jul 05 2006 - 17:43:32 CEST