I now know that I cannot use client application written in embedded
SQL to receive record sets, that only an application using CLI can
receive record sets (see my previous question titled "How to use
returned result sets from a client app?"). If I do not change client
app to use CLI, is there a way for a stored procedure to return a
whole row of data without using record set? By the way, there could be
as many as 150 columns in a row in my tables, and I may not know how
many columns will be returned beforehand (meaning, it depends on which
table I query).

Thanks in advance for any help.