[progress Communities] [progress Openedge Abl] Forum Post: Re: Data Definition Syntax -...

[marian.edu]

Thanks Rob, that’s indeed the kind of information I was looking for… For TDE I’ve already saw that in a .df file, having ‘update table’ statements in a file that is not incremental caught me by surprise but that’s fixed now… although as you say the TDE settings might not be changed from incremental .df, adding those statements there will render the incremental .df unusable or it will just be ignored? Is there a way to remove encryption on a table/lob/index, like using DELETE for triggers for instance??? Area on the other hand is specified in the ‘add table’ statement, can that be changed from incremental df? I guess not, so probably ‘area’ is not valid in ‘update table’ statement. Alternate buffer pools seems to go the TDE route, found that in an ‘update table’ statement in regular .df file, so not in add table. Can it be changed by loading an incremental df, if so what’s the syntax there? What I’m really missing is how local/global flag is used for indexes on multi-tenant tables, how the ‘add index’ syntax looks like… or it’s part of ‘update index’? Can that be changed from incremental df or still just using command line dba scripts? There might be a BNF for DDL somewhere, Gus once said there is one for ABL but haven’t seen unicorns so far… what I’m looking for is being able to parse all data definition files to load that in a database model (diagram), for that every possible constructs need to be supported by the parser or the load will fail. Afterwards, when comparing two models we should be able to generate incremental definition file so again what can be changed from there and what not? It might be that Progress will simply ignore invalid options used in DDL statements in incremental df (like changing the area or encryption in an ‘update table’) but it might well not like those and stop loading changes. Not much of a dba, if there is a place in documentation where I can find those kind of answers just point me to the relevant rtfm section please Marian Edu Acorn IT www.acorn-it.com www.akera.io +40 740 036 212

Continue reading...