ProC Hosts arrays

Steve Rainbird · *nix forums beginner Joined: 02 Nov 2005 Posts: 8

I don't know why but proc does not allow 2 dimensional host arrays.

I need to do the following

double col[2][2]

select col_1,col_2,col_3,col_4
into col[1][1],col[1][2],col[2][1],col[2][2]
from etc

But this is not allowed in proc.

Any ideas?

--
Steve

Remove "nospam" from email address to reply to me personally

mprzewozny@gmail.com · *nix forums beginner Joined: 18 Apr 2006 Posts: 4

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

Google