Why &lt;UNDEFINED&gt; on SQL

Question

Thembelani Mlalazi · Jan 15, 2019

I have an sql statement that I would like to execute but I get the error

"zSearchChanges+5^MergeHyland.TypeTwoUtil.1 *KeyID"

and here is my sq

l  "&sql(SELECT Key INTO :KeyID FROM MergeHyland.TypeTwoDimesionalTable WHERE Key = :Key)" any ideas why

Discussion (2)3

John Murray · Jan 15, 2019

My guess is you're not testing the SQLCODE variable's result before you try and access the KeyID host variable.

0 0

Timothy Leavitt · Jan 15, 2019

You should check the SQLCODE from running that statement. If SQLCODE is 100 (no record exists with the specified key), KeyID may not be defined.

0 0