sqlexcelhashtagintersystems-cache

SQL all fields with com # (SELECT * FROM)

I need run a generic SQL query with the character # between each field in the query result so that I can work with in Excel. I.E:

SELECT * FROM EMPLOYEE

RESULT

NAME#AGE#SALARY#EMAIL 
Bob#59#1700#bob@bob.com

How can I to do this?

Solution

  • In Caché you can export data with System Management Portal. You can read how you can do it in the documentation. enter image description here