CHAR_MAP=STRING results in 1403 error on FETCH

From: Edward A Thompson <ed4becky_2000_at_yahoo.com>
Date: 9 Nov 2001 06:05:27 -0800
Message-ID: <d913df37.0111090605.3078fa8@posting.google.com>

Using dynamic SQL method 3, could not figure out why SELECT x FROM t where z = :v1;
did not work when using
OPEN x USING :var;

but if I did this...
SELECT x FROM t WHERE z = '%s';, and substituted %s with the value of var,
then OPEN (without USING), it worked fine.

narrowed it down to the CHAR_MAP=STRING compiler option. When I removed it, all was well on first approach.

var is defined as a host variable:
char var[5];
and initilized with:
strcpy(var, somecharptr);

Can anyone offer some insight and/or a work around? Received on Fri Nov 09 2001 - 08:05:27 CST