I am doing a left outer join in an embedded SQL. Results are read into a data structure. Problem is that if join is not made, data structure gets null and blows up. Is there a way to avoid this?
PHP Code:
SELECT
char (F2.USER,10),
F1.USER
FROM INVH F1
LEFT OUTER JOIN INVD F2
on (F2.DOC = F1.DOC)
PHP Code:
Message . . . . : Indicator variable required.
Cause . . . . . : A FETCH, embedded SELECT, CALL, GET DESCRIPTOR, or a SET
or VALUES INTO statement has resulted in a null value, but an indicator
variable was not specified for host variable USER. The relative position of
the host variable in the INTO clause or parameter list is 8. If the host
variable name is *N, a descriptor area was specified.
If this error occurs on a GET DESCRIPTOR statement, the null value is
being returned but the INDICATOR item was not specified on the GET
DESCRIPTOR statement.
Comment