Object EVAR Commands
SQL/MX Connectivity Service Administrative Command Reference—526350-005
6-12
Considerations—INFO EVAR
Considerations—INFO EVAR
INFO EVAR is not a sensitive command.
The asterisk (*) wild card is supported for evar-name.
INFO EVAR displays every EVAR with a name match. If more than one match is
found, no warning is generated.
INFO EVAR displays the EVARs in the order that they are applied.
When an EVAR does not fit on a 79-character line, it is folded at the most
reasonable blank space (if possible), with subsequent lines indented four spaces.
Example—INFO EVAR
This example displays an EVAR of type define, with the name GROUP in the DS
TDM_Default_DataSource. You can use the equal (=) sign in the name, but it is not
required.
CS>info evar *."TDM_Default_DataSource".GROUP, type define;
-- INFO EVAR \ODBC.*.TDM_Default_DataSource.=GROUP Report
ADD DEFINE =GROUP, CLASS MAP, FILE $DATA03.PERSNL.GROUP
This example uses wild cards and is type all. This is the default DS, and it has no
EVARs defined.
CS>info evar *."TDM_Default_DataSource".*, type all;
-- INFO EVAR \ODBC.*.TDM_Default_DataSource.* Report
Resource Management Policies:
None
Defines:
None
Controls:
None
Sets:
None
This example uses wild cards and the type is all. This DS has some of each EVAR
defined. Note the control table EVARS:
CS>info evar *."TDM_Default_DataSource".*, type all;
-- INFO EVAR \ODBC.*.TDM_Default_DataSource.* Report
Resource Management Policies:
ESTIMATED COST Limit: 123456 Action: STOP
Defines:
ADD DEFINE =EMPLOYEE, CLASS MAP, FILE $DATA01.PERSNL.EMPLOYEE
ADD DEFINE =DEPT, CLASS MAP, FILE $DATA02.PERSNL.DEPT
Controls:
CONTROL QUERY DEFAULT HIST_NO_STATS_ROWCOUNT '123456789'
Comentarios a estos manuales