public java.lang.String getCK(java.lang.String pPropertyName)
This method returns information relative to a condition of a datastore during a check procedure. It is accessible from a Check Knowledge Module only if the current task is tagged as "condition".
In an action, this method returns information related to the check constraint currently handled by the DDL command.
|
Parameter |
Type |
Description |
|---|---|---|
|
pPropertyName |
String |
Current string containing the name of the requested property. |
The following table lists the different values accepted by pPropertyName :
|
Value of the parameter |
Description |
|---|---|
|
ID |
Internal number of the check constraint. |
|
COND_ALIAS |
Alias of the table used in the SQL statement |
|
COND_NAME |
Name of the condition |
|
COND_TYPE |
Type of the condition |
|
COND_SQL |
SQL statement of the condition |
|
MESS |
Error message relative to the check constraint |
|
FULL_NAME |
Full name of the check constraint generated with the local object mask. |
|
COND_SQL_DDL
|
SQL statement of the condition with no table alias. |
|
<flexfield code> |
Flexfield value for this check constraint. |
The current condition is called: <%=snpRep.getCK("COND_NAME")%>
insert into MY_ERROR_TABLE
select *
from MY_CHECKED_TABLE
where (not (<%=odiRef.getCK("COND_SQL")%>))