Export DDL from a Caché class

Question

Question

Guilherme Koerber · Dec 8, 2021

#Data Import and Export #SQL #Caché #Ensemble

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

Discussion (9)3

Log in or sign up to continue

Vitaliy Serdtsev · Dec 8, 2021

Will an undocumented command suit you?

0 0

Vitaliy Serdtsev · Dec 8, 2021

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)

5 0

score 0 · Answer 1 · 2021-12-08T09:21:31-05:00

Guilherme Koerber · Dec 8, 2021

Yes

0 0

score 2 · Answer 2 · 2021-12-08T11:51:28-05:00

Guilherme Koerber · Dec 8, 2021

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

2 0

score 1 · Answer 3 · 2025-01-28T09:59:11-05:00

Marcio Jose Ped... · Jan 28

Here I`m, in 2025, using the same tip to solve a problem.
Thanks, Vitaliy, thanks, community.

1 0

score 0 · Answer 4 · 2025-03-30T19:36:14-04:00

Evgeny Shvarov · Mar 30

Very useful command, thank you @Vitaliy Serdtsev

0 0

score 2 · Answer 5 · 2025-03-30T20:24:22-04:00

While the suggested method should still work (haven't tested), I'd advise using the official method $system.SQL.Schema.ExportDDL()

See Class Reference for documentation details and samples.

score 0 · Answer 6 · 2025-03-31T01:24:02-04:00

Vitaliy Serdtsev · Mar 31

Initially, the question was asked in relation to Caché or/and Ensemble 2018.1, but not to IRIS.

0 0

score 0 · Answer 7 · 2025-03-31T05:49:17-04:00

Evgeny Shvarov · Mar 31

Thank you @Enrico Parisi , this is helpful!

0 0