Guilherme Koerber · Dec 8, 2021

Export DDL from a Caché class

I need to generate a DDL file from a .cls class that already exists, the idea is to create a mirror table in SQL. Is it possible to do this export or do I need to do the CREATE TABLE manually?

Product version: Ensemble 2018.1
1 179
Discussion (4)1
Log in or sign up to continue

See the sources of method %SYSTEM.SQL:Export() for a description of the parameters.

Only instead of 0, use 1, for example:

SAMPLES>w $$Export^%qarDDLExport("Sample","*","C:\Temp\Sample.sql","WNS",1,0,0,0,0)

I managed to export with the command. Thank you very much!