Thanks, Jevgeni.

I tried your suggestion but unfortunately with no luck.
I have no trouble fetching a single column into a single
variable - it's when fetching multiple columns into a
struct that I can't get to work.

Phil
>
> EXEC SQL BEGIN DECLARE SECTION;
>
> >  empDS hostDS[10];
>
> EXEC SQL END DECLARE SECTION;
>
> In other words, variables, that you are going to fetch into, must be declared
> inside this section....
>
> Below is a working program :
>
> EXEC SQL BEGIN DECLARE SECTION;
>   char user[4];
> EXEC SQL END DECLARE SECTION;
>
> EXEC SQL INCLUDE SQLCA;
>
> int main(int argc, char *argv[])
> {
>   memcpy(user, argv[1], 4);
>
>   EXEC SQL DELETE FROM GDPF
>            WHERE GDUSID = :user;
>   EXEC SQL UPDATE OCPF SET OCCOA = '   '
>            WHERE OCUSID = :user;
>
>   return(0);
> }
>
> HTH,
>
> Jevgeni Astanovski
> IT support department manager
> Sampo bank
> Tallinn, Estonia.


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].