Sqlcod = -000000305.

[dcutaia]

I am getting a SQLCOD = -000000305. when I debug my program. My sql statement is as follows:
C/EXEC SQL
C+ DECLARE M1 CURSOR FOR SELECT DISTINCT ICFAC,ICPROD,
C+ IFENO AS ICFENO,IDESC,IEDESC,IROHSC,IDRAW
C+ FROM CIC LEFT OUTER JOIN IIM on ICPROD = IPROD
C+ LEFT OUTER JOIN IIMX ON IPROD = IEPROD
C+ WHERE ICFAC = '09 ' AND ICPROD LIKE 'BTC40%'
C/END-EXEC

I put the SQL statement into the STRSQL
SELECT DISTINCT ICFAC,ICPROD,
IFENO AS ICFENO,IDESC,IEDESC,IROHSC,IDRAW
FROM CIC LEFT OUTER JOIN IIM on ICPROD = IPROD
LEFT OUTER JOIN IIMX ON IPROD = IEPROD
WHERE ICFAC = '09 ' AND ICPROD LIKE 'BTC40%'

and I get my valid data but in my program I get a -305.

Does anyone know why?

Thanks,

DAC

[tomholden]

Re: Sqlcod = -000000305.

text for SQL0305:

Indicator variable required.

you haven't accommodated for null indicators and it seems that either some of the fields you are selecting are null-capable or the statement can result in null values for some fields. add indicators (10i 0) to your field selection list.