Export from Intersystems Caché Database

Question

I have a product based on the Intersystems Caché database, I do not see classes, no schemas, no tables, only global ones. Is there any smart way to export data from these global variables and get a “readable structure”?

Answer 1

First question: what version of Caché? Second question: what tools do you have? Terminal, Studio, Management Portal

If the data is in tables / classes, you should have access to it through ODBC, at least. If there are no tables / classes, the data is probably in Globals.

Globals ( ), , .

Globals , SQL.

EXTREEMELY , .: - (

Answer 2

Intersystems , " " , .

: * zw * d ^% G

Answer 3

Cache SMP Cache Studio? , - ( , , ). SMP - , . zw, node:

USER> zw ^GlobalName

http://docs.intersystems.com/cache20082/csp/docbook/DocBook.UI.Page.cls?KEY=RCOS_czwrite

?

Answer 4

, . , - /(zen/csp) . , , :/

Answer 5

, Navicat Tool Caché MySQL Postgres, DB, ODBC.

Answer 6

ODBC works with a cache. You can use the ODBC connection to export data to another file, for example, a set of free tables or text files.