A procedure command is the unit of execution of a procedure.
Definition
This tab allows the command row to be defined.
Properties |
Description |
---|---|
Name 이름 |
command 이름 |
Log Counter |
어떤 카운터 (삽입, 업데이트, 삭제 또는 오류)가 본 명령에 의해 처리된 행의 수를 기록할 것인지를 보여줍니다. |
Log level |
중요도 |
Ignore Errors |
오류가 날 경우, 경고로 처리하여 작업이 중지되지 않고 계속할 수 있도록 하기 위해 |
Command |
대상명령과 원본 명령을 나눈것은 다중연결시 서로다른 명령을 사용하기 위해서 이다.procedure. |
Technology |
명령이 실행될 기반 기술 |
Transaction Isolation |
하나의 트랜잭션이 진행될 동안 다른 client가 침범하였을 경우의 격리정도를 선택할 수 있다.
|
Context |
Execution context of the query. If "Execution context" is left, the command will be executed in the execution context chosen on launching or on the step. |
Schema |
Logical schema for execution. This logical schema, linked to the context, allows the physical execution schema to be defined. |
Transaction |
You can execute commands on several concurrent transactions (numbered from 0 to 9) or work off-transaction by choosing the option "Autocommit". The latter may be more efficient. |
Commit |
If your command is being executed in a transaction (numbered 0 to 9), you can decide to continue or to commit the current transaction according to the following modes:
|
Command |
The text of the command expressed in a native language or in a standard language (such as SQL, PL/SQL, Transact-SQL, shell, etc). You can use the expression editor, accessible through the button to the right of the text. Warning: If the command seems to be made of random characters, then the procedure is encrypted. For more details about encryption and decryption, please read Encrypt a KM or a Procedure. Contact also the procedure's provider. |
Options
This tab allows you to specify whether the procedure command is to be executed or not, according to the value of a procedure option.
Properties |
Description |
---|---|
Always execute |
The procedure command is executed regardless of the options values. |
Options |
This chart shows all options. The checkbox preceding each option shows that the procedure command is executed if the (checkbox-type) option has the value "yes". |