RE: [C400-L] Embedded SQL - SQLC

[sublime78ska@xxxxxxxxx]

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.