SAP Knowledge Base Article - Preview

2998323 - How to select * from ROW type?


There is a user defined function that returns a ROW type result. It is possible to query this result by specifying the names of the columns of that ROW.
But if the column names of that ROW are unknown, it is impossible to query it using a SELECT statement.
Is there a way to find out the actual column names of a ROW type?



 SAP SQL Anywhere 17


SAP SQL Anywhere 17.0


sp_parse_json , KBA , BC-SYB-SQA-SRV , SQL Anywhere - Server , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.