TMACUL

SPEL LANGUAGE (domset's) 13/10/2015

Blog Post created by TMACUL Champion on Jan 11, 2016

Sometimes it is necessary to consult a list of records of an object and it is important to know functioning of domset's. A domset defined as a list of values must be created. Therefore, the correct use of a domset directly influences the result and function of performance "sync_fetch" for example. In addition to various other functions similar listing ("select", "select_count", "fetch", etc.).

 

Basically, there are 02 types of Domsets: MList (Master) and RLIST (Restricted), and within these, two subtypes: and STATIC DYNAMIC.

And furthermore there may be other specific domset's of a factory that were created for a specific need of an application (Ex .: scoreboard on the cr object).

 

To see all domset's available on an object, use the command

bop_sinfo -l <object name>

 

 

As a rule, restricted domset's (RLIST) have "where" clause built into own operation. And because of this generate a subset of records from a domset MList. I will highlight two domset's the factory "imp":

 

MLIST_STATIC

List Cols: delete_flag

Sort Cols: sym, enum

 

RLIST_STATIC

Where : delete_flag = 0

List Cols: delete_flag

Sort Cols: sym, enum

 

The difference is: domsets RLIST only includes records "active".  Furthermore, MLIST's are usually faster - because the CA SDM maintains pointers object server memory columns in RAM instead of using a bank index. This is good and bad at the same time but I will not dwell here.

 

What is the difference between gift set STATIC and DYNAMIC?

Objetos de lista utilizando domsets estáticos quando criados NÃO sofrerão mudança de conteúdo mesmo quando durante o processo, algum registro for incluído, alterado ou excluído. Se ele fosse dinâmico, isso aconteceria e o resultado da busca se modificaria.

 

The object list always use static domset's when created NOT suffered content change even when process, some record is added, modified or deleted. If it were dynamic, it would happen and the search result would change.

 

 

Finishing, an interesting tip:

Many implementers often create a .MOD file certain object by declaring a STANDARD_LIST as in the example below:

 

MODIFY FACTORY in {

STANDARD_LISTS {

SORT_BY "open_date DESC,priority DESC";

};

};

 

This makes the SDM "replaces" all existing MList and RLIST domsets the objects and the results sometimes directly affect the product performance. Instead, choose customize the form "list _ ***. HTMPL" changing the PDM_MACRO "lsend" or manipulating the $ sort server variable. It is much more practical and enables different registry sorting settings according to the function (role) User.

 

 

was publish initially: 13 de outubro de 2015 às 16:06

From: CA SDM Brasil - Facebook

Author: Daniel Bighelini

 

Translated by Google attending to request by Timur

 

Do you would like to see in Portuguese, access : Leia em português:

LINGUAGEM SPEL (domset's) 13/10/2015

Outcomes