Array elements and "IS NULL"

[dlangschied]

I am having issues with my SQL 89 to 92 code conversion on array elements.

I have code that looks for the presence of unpopulated data fields in an array.

Here is a snippet:
where so_end_eff[2] IS NULL

Error message:
Syntax error in SQL statement at or about "IS NULL" (10713)

I am unsure how to correct this

 

[tamhas]

In SQL92 you want to be using PROELEMENT for arrays.

 

[dlangschied]

Thanks! I will give this a try