SAP Knowledge Base Article - Preview

2998323 - How to select * from ROW type?

Symptom

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?


Read more...

Environment

 SAP SQL Anywhere 17

Product

SAP SQL Anywhere 17.0

Keywords

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.