Array in SQL Cursor
Posted: Tue Aug 30, 2011 3:53 pm
If we have few values which needs to excluded from the selection and if the values are changing every time, can we use Array name in WHERE cluase of sql, after reading the valuese in to array in COBOL program?
Select * from <table name>
where col1 not in (:ws-array-name)
Throwing the error ws-array-name as UNUSABLE or UNDECLARED HOST VARIABLE
Select * from <table name>
where col1 not in (:ws-array-name)
Throwing the error ws-array-name as UNUSABLE or UNDECLARED HOST VARIABLE