Re: ESQL/C and EXECUTE PROCEDURE
Yup, it's plenty possible. Just add to the end of your example:
$EXECUTE p_exe INTO desc USING $var, $var ...
where $var's are your variables that go in place of the question marks.
HTH
- Thomas J. Girsch
Database Systems Manager
Arch Communications Group, Inc.
Petr Pomykacek wrote in message <01bd09a6$1915c480$c86855c1@pomyk>...
>Hi,
>Is posible in ESQL/C execute procedure dynamic with
>input and output parameters without using cursor.
>
>My exaple:
>
>$include sqlca;
>$include sqlda;
>main()
>{
>struct sqlda *desc;
>$ char xx[1024];
>$ database stores5;
>sprintf(xx,"EXECUTE PROCEDURE xx (?)");>
>/* What send value for input parametr ??*/
>
>$ prepare p_exe from $xx;>
>$ describe p_exe INTO desc;
>/*desc is output descriptor*/>