644 |
|
Current memory = 19,651,152 |
645 |
|
Delta memory = 13,040 |
646 |
|
Max memory = 19,779,424 |
647 |
< |
Elapsed time= 0.027 sec |
648 |
< |
Cpu = 0.010 sec |
647 |
> |
Elapsed time= 0.022 sec |
648 |
> |
Cpu = 0.000 sec |
649 |
|
Buffers = 2048 |
650 |
|
Reads = 2 |
651 |
|
Writes = 0 |
1445 |
|
isc_dpb_lc_ctype = UTF8 |
1446 |
|
|
1447 |
|
Before Disconnect |
1448 |
< |
inet://localhost/employee Disconnected after 18 ms |
1448 |
> |
inet://localhost/employee Disconnected after 21 ms |
1449 |
|
Before Connect |
1450 |
|
Connected to inet://localhost/employee |
1451 |
|
DPB: Item Count = 3 |
1454 |
|
isc_dpb_lc_ctype = UTF8 |
1455 |
|
|
1456 |
|
Before Disconnect |
1457 |
< |
inet://localhost/employee Disconnected after 3952 ms |
1457 |
> |
inet://localhost/employee Disconnected after 4015 ms |
1458 |
|
Idle Timer Expired for Test_Database_02 |
1459 |
|
Database Closed |
1460 |
|
Transaction Events |
1494 |
|
Transaction Ended after 2000 ms |
1495 |
|
Idle Timer Expired for Test_Transaction_02 |
1496 |
|
Before Disconnect |
1497 |
< |
inet://localhost/employee Disconnected after 2029 ms |
1497 |
> |
inet://localhost/employee Disconnected after 2040 ms |
1498 |
|
SQL Dialect Downgrade test |
1499 |
|
Before Connect |
1500 |
|
Connected to inet://localhost//tmp/ibx-testsuite/testsuite1.fdb |
1506 |
|
|
1507 |
|
inet://localhost//tmp/ibx-testsuite/testsuite1.fdb created |
1508 |
|
Before Disconnect |
1509 |
< |
inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 21 ms |
1509 |
> |
inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 20 ms |
1510 |
|
Before Connect |
1511 |
|
Warning: SQL Dialect Downgrade of inet://localhost//tmp/ibx-testsuite/testsuite1.fdb |
1512 |
|
Connected to inet://localhost//tmp/ibx-testsuite/testsuite1.fdb |
1516 |
|
isc_dpb_lc_ctype = UTF8 |
1517 |
|
|
1518 |
|
Before Disconnect |
1519 |
< |
inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 28 ms |
1519 |
> |
inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 36 ms |
1520 |
|
|
1521 |
|
|
1522 |
|
------------------------------------------------------ |
3172 |
|
Delta memory = 13,072 |
3173 |
|
Max memory = 19,729,584 |
3174 |
|
Elapsed time= 0.023 sec |
3175 |
< |
Cpu = 0.010 sec |
3175 |
> |
Cpu = 0.020 sec |
3176 |
|
Buffers = 2048 |
3177 |
|
Reads = 2 |
3178 |
|
Writes = 0 |
4075 |
|
|
4076 |
|
/* Stored procedures Definitions*/ |
4077 |
|
|
4078 |
< |
CREATE PROCEDURE SHOW_LANGS |
4078 |
> |
CREATE PROCEDURE SHOW_LANGS |
4079 |
|
( |
4080 |
|
CODE VARCHAR(5) CHARACTER SET NONE, |
4081 |
|
GRADE SMALLINT, |
4088 |
|
AS |
4089 |
|
BEGIN SUSPEND; EXIT; END |
4090 |
|
^ |
4091 |
< |
|
4092 |
< |
CREATE PROCEDURE ADD_EMP_PROJ |
4091 |
> |
CREATE PROCEDURE ADD_EMP_PROJ |
4092 |
|
( |
4093 |
|
EMP_NO SMALLINT, |
4094 |
|
PROJ_ID CHAR(5) CHARACTER SET NONE |
4096 |
|
AS |
4097 |
|
BEGIN SUSPEND; EXIT; END |
4098 |
|
^ |
4099 |
< |
|
4101 |
< |
CREATE PROCEDURE ALL_LANGS |
4099 |
> |
CREATE PROCEDURE ALL_LANGS |
4100 |
|
RETURNS |
4101 |
|
( |
4102 |
|
CODE VARCHAR(5) CHARACTER SET NONE, |
4107 |
|
AS |
4108 |
|
BEGIN SUSPEND; EXIT; END |
4109 |
|
^ |
4110 |
< |
|
4113 |
< |
CREATE PROCEDURE DELETE_EMPLOYEE |
4110 |
> |
CREATE PROCEDURE DELETE_EMPLOYEE |
4111 |
|
( |
4112 |
|
EMP_NUM INTEGER |
4113 |
|
) |
4114 |
|
AS |
4115 |
|
BEGIN SUSPEND; EXIT; END |
4116 |
|
^ |
4117 |
< |
|
4121 |
< |
CREATE PROCEDURE DEPT_BUDGET |
4117 |
> |
CREATE PROCEDURE DEPT_BUDGET |
4118 |
|
( |
4119 |
|
DNO CHAR(3) CHARACTER SET NONE |
4120 |
|
) |
4125 |
|
AS |
4126 |
|
BEGIN SUSPEND; EXIT; END |
4127 |
|
^ |
4128 |
< |
|
4133 |
< |
CREATE PROCEDURE GET_EMP_PROJ |
4128 |
> |
CREATE PROCEDURE GET_EMP_PROJ |
4129 |
|
( |
4130 |
|
EMP_NO SMALLINT |
4131 |
|
) |
4136 |
|
AS |
4137 |
|
BEGIN SUSPEND; EXIT; END |
4138 |
|
^ |
4139 |
< |
|
4145 |
< |
CREATE PROCEDURE MAIL_LABEL |
4139 |
> |
CREATE PROCEDURE MAIL_LABEL |
4140 |
|
( |
4141 |
|
CUST_NO INTEGER |
4142 |
|
) |
4152 |
|
AS |
4153 |
|
BEGIN SUSPEND; EXIT; END |
4154 |
|
^ |
4155 |
< |
|
4162 |
< |
CREATE PROCEDURE ORG_CHART |
4155 |
> |
CREATE PROCEDURE ORG_CHART |
4156 |
|
RETURNS |
4157 |
|
( |
4158 |
|
HEAD_DEPT CHAR(25) CHARACTER SET NONE, |
4164 |
|
AS |
4165 |
|
BEGIN SUSPEND; EXIT; END |
4166 |
|
^ |
4167 |
< |
|
4175 |
< |
CREATE PROCEDURE SHIP_ORDER |
4167 |
> |
CREATE PROCEDURE SHIP_ORDER |
4168 |
|
( |
4169 |
|
PO_NUM CHAR(8) CHARACTER SET NONE |
4170 |
|
) |
4171 |
|
AS |
4172 |
|
BEGIN SUSPEND; EXIT; END |
4173 |
|
^ |
4174 |
< |
|
4183 |
< |
CREATE PROCEDURE SUB_TOT_BUDGET |
4174 |
> |
CREATE PROCEDURE SUB_TOT_BUDGET |
4175 |
|
( |
4176 |
|
HEAD_DEPT CHAR(3) CHARACTER SET NONE |
4177 |
|
) |
4185 |
|
AS |
4186 |
|
BEGIN SUSPEND; EXIT; END |
4187 |
|
^ |
4197 |
– |
|
4188 |
|
SET TERM ; ^ |
4189 |
|
COMMIT WORK; |
4190 |
|
SET AUTODDL ON; |
4240 |
|
/* Stored procedure Bodies */ |
4241 |
|
|
4242 |
|
|
4243 |
< |
ALTER PROCEDURE SHOW_LANGS |
4243 |
> |
ALTER PROCEDURE SHOW_LANGS |
4244 |
|
( |
4245 |
|
CODE VARCHAR(5) CHARACTER SET NONE, |
4246 |
|
GRADE SMALLINT, |
4266 |
|
SUSPEND; |
4267 |
|
END |
4268 |
|
END |
4269 |
< |
^ |
4280 |
< |
|
4269 |
> |
^ |
4270 |
|
|
4271 |
< |
ALTER PROCEDURE ADD_EMP_PROJ |
4271 |
> |
ALTER PROCEDURE ADD_EMP_PROJ |
4272 |
|
( |
4273 |
|
EMP_NO SMALLINT, |
4274 |
|
PROJ_ID CHAR(5) CHARACTER SET NONE |
4282 |
|
END |
4283 |
|
SUSPEND; |
4284 |
|
END |
4285 |
< |
^ |
4297 |
< |
|
4285 |
> |
^ |
4286 |
|
|
4287 |
< |
ALTER PROCEDURE ALL_LANGS |
4287 |
> |
ALTER PROCEDURE ALL_LANGS |
4288 |
|
RETURNS |
4289 |
|
( |
4290 |
|
CODE VARCHAR(5) CHARACTER SET NONE, |
4310 |
|
SUSPEND; |
4311 |
|
END |
4312 |
|
END |
4313 |
< |
^ |
4326 |
< |
|
4313 |
> |
^ |
4314 |
|
|
4315 |
< |
ALTER PROCEDURE DELETE_EMPLOYEE |
4315 |
> |
ALTER PROCEDURE DELETE_EMPLOYEE |
4316 |
|
( |
4317 |
|
EMP_NUM INTEGER |
4318 |
|
) |
4371 |
|
|
4372 |
|
SUSPEND; |
4373 |
|
END |
4374 |
< |
^ |
4388 |
< |
|
4374 |
> |
^ |
4375 |
|
|
4376 |
< |
ALTER PROCEDURE DEPT_BUDGET |
4376 |
> |
ALTER PROCEDURE DEPT_BUDGET |
4377 |
|
( |
4378 |
|
DNO CHAR(3) CHARACTER SET NONE |
4379 |
|
) |
4407 |
|
|
4408 |
|
SUSPEND; |
4409 |
|
END |
4410 |
< |
^ |
4425 |
< |
|
4410 |
> |
^ |
4411 |
|
|
4412 |
< |
ALTER PROCEDURE GET_EMP_PROJ |
4412 |
> |
ALTER PROCEDURE GET_EMP_PROJ |
4413 |
|
( |
4414 |
|
EMP_NO SMALLINT |
4415 |
|
) |
4426 |
|
DO |
4427 |
|
SUSPEND; |
4428 |
|
END |
4429 |
< |
^ |
4445 |
< |
|
4429 |
> |
^ |
4430 |
|
|
4431 |
< |
ALTER PROCEDURE MAIL_LABEL |
4431 |
> |
ALTER PROCEDURE MAIL_LABEL |
4432 |
|
( |
4433 |
|
CUST_NO INTEGER |
4434 |
|
) |
4496 |
|
|
4497 |
|
SUSPEND; |
4498 |
|
END |
4499 |
< |
^ |
4516 |
< |
|
4499 |
> |
^ |
4500 |
|
|
4501 |
< |
ALTER PROCEDURE ORG_CHART |
4501 |
> |
ALTER PROCEDURE ORG_CHART |
4502 |
|
RETURNS |
4503 |
|
( |
4504 |
|
HEAD_DEPT CHAR(25) CHARACTER SET NONE, |
4538 |
|
SUSPEND; |
4539 |
|
END |
4540 |
|
END |
4541 |
< |
^ |
4559 |
< |
|
4541 |
> |
^ |
4542 |
|
|
4543 |
< |
ALTER PROCEDURE SHIP_ORDER |
4543 |
> |
ALTER PROCEDURE SHIP_ORDER |
4544 |
|
( |
4545 |
|
PO_NUM CHAR(8) CHARACTER SET NONE |
4546 |
|
) |
4601 |
|
|
4602 |
|
SUSPEND; |
4603 |
|
END |
4604 |
< |
^ |
4623 |
< |
|
4604 |
> |
^ |
4605 |
|
|
4606 |
< |
ALTER PROCEDURE SUB_TOT_BUDGET |
4606 |
> |
ALTER PROCEDURE SUB_TOT_BUDGET |
4607 |
|
( |
4608 |
|
HEAD_DEPT CHAR(3) CHARACTER SET NONE |
4609 |
|
) |
4622 |
|
INTO :tot_budget, :avg_budget, :min_budget, :max_budget; |
4623 |
|
SUSPEND; |
4624 |
|
END |
4625 |
< |
^ |
4645 |
< |
|
4625 |
> |
^ |
4626 |
|
SET TERM ; ^ |
4627 |
|
COMMIT WORK; |
4628 |
|
SET AUTODDL ON; |
5666 |
|
SALARY, |
5667 |
|
FULL_NAME, |
5668 |
|
DEPT_PATH, |
5669 |
< |
DEPT_KEY_PATH |
5669 |
> |
DEPT_KEY_PATH, |
5670 |
> |
"Payment Status" |
5671 |
|
) AS |
5672 |
|
with recursive Depts As ( |
5673 |
|
Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH, |
5681 |
|
) |
5682 |
|
|
5683 |
|
Select distinct A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE, |
5684 |
< |
A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH |
5684 |
> |
A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH, |
5685 |
> |
CASE When A.SALARY > 10000 then 'higher paid' else 'lower paid' End |
5686 |
|
From EMPLOYEE A |
5687 |
|
JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
5688 |
|
; |
5812 |
|
|
5813 |
|
procedure get_lines returns (lines fb$out_type); |
5814 |
|
end |
5815 |
< |
^ |
5815 |
> |
^ |
5816 |
|
|
5817 |
|
CREATE PACKAGE SELECT$TEST |
5818 |
|
AS |
5820 |
|
Begin |
5821 |
|
Procedure ShowItems(IPARAM Integer) RETURNS (OutParam integer); |
5822 |
|
End |
5823 |
< |
^ |
5823 |
> |
^ |
5824 |
|
|
5825 |
< |
SET TERM ; ^ |
5825 |
> |
SET TERM ;^ |
5826 |
|
COMMIT WORK; |
5827 |
|
SET AUTODDL ON; |
5828 |
|
COMMIT WORK; |
5891 |
|
|
5892 |
|
^ |
5893 |
|
|
5894 |
+ |
CREATE PROCEDURE EMPLOYEE_PAY_STATUS |
5895 |
+ |
( |
5896 |
+ |
EMP_NO SMALLINT |
5897 |
+ |
) |
5898 |
+ |
RETURNS |
5899 |
+ |
( |
5900 |
+ |
PAY_STATUS VARCHAR(6) CHARACTER SET NONE |
5901 |
+ |
) |
5902 |
+ |
AS |
5903 |
+ |
BEGIN EXIT; END |
5904 |
+ |
|
5905 |
+ |
^ |
5906 |
+ |
|
5907 |
+ |
|
5908 |
|
CREATE PROCEDURE GET_EMP_PROJ |
5909 |
|
( |
5910 |
|
EMP_NO SMALLINT |
5999 |
|
|
6000 |
|
^ |
6001 |
|
|
6002 |
< |
SET TERM ; ^ |
6002 |
> |
SET TERM ;^ |
6003 |
|
COMMIT WORK; |
6004 |
|
SET AUTODDL ON; |
6005 |
|
COMMIT WORK; |
6015 |
|
^ |
6016 |
|
|
6017 |
|
|
6018 |
< |
SET TERM ; ^ |
6018 |
> |
SET TERM ;^ |
6019 |
|
COMMIT WORK; |
6020 |
|
SET AUTODDL ON; |
6021 |
|
SET TERM ^ ; |
6028 |
|
as |
6029 |
|
begin |
6030 |
|
End |
6031 |
< |
^ |
6031 |
> |
^ |
6032 |
|
CREATE TRIGGER "BEFORE CREATE TABLE" |
6033 |
|
ACTIVE BEFORE CREATE TABLE POSITION 0 |
6034 |
|
AS BEGIN END |
6035 |
< |
^ |
6035 |
> |
^ |
6036 |
|
CREATE TRIGGER "AFTER CREATE TABLE" |
6037 |
|
ACTIVE AFTER CREATE TABLE POSITION 0 |
6038 |
|
AS BEGIN END |
6039 |
< |
^ |
6039 |
> |
^ |
6040 |
|
CREATE TRIGGER "BEFORE ALTER TABLE" |
6041 |
|
ACTIVE BEFORE ALTER TABLE POSITION 0 |
6042 |
|
AS BEGIN END |
6043 |
< |
^ |
6043 |
> |
^ |
6044 |
|
CREATE TRIGGER "AFTER ALTER TABLE" |
6045 |
|
ACTIVE AFTER ALTER TABLE POSITION 0 |
6046 |
|
AS BEGIN END |
6047 |
< |
^ |
6047 |
> |
^ |
6048 |
|
CREATE TRIGGER "AFTER CREATE/Alter TABLE" |
6049 |
|
ACTIVE AFTER CREATE TABLE OR ALTER TABLE POSITION 0 |
6050 |
|
AS BEGIN END |
6051 |
< |
^ |
6051 |
> |
^ |
6052 |
|
CREATE TRIGGER "BEFORE DROP TABLE" |
6053 |
|
ACTIVE BEFORE Drop TABLE POSITION 0 |
6054 |
|
AS BEGIN END |
6055 |
< |
^ |
6055 |
> |
^ |
6056 |
|
CREATE TRIGGER "AFTER DROP TABLE" |
6057 |
|
ACTIVE AFTER Drop TABLE POSITION 0 |
6058 |
|
AS BEGIN END |
6059 |
< |
^ |
6059 |
> |
^ |
6060 |
|
CREATE TRIGGER "BEFORE CREATE PROCEDURE" |
6061 |
|
ACTIVE BEFORE CREATE PROCEDURE POSITION 0 |
6062 |
|
AS BEGIN END |
6063 |
< |
^ |
6063 |
> |
^ |
6064 |
|
CREATE TRIGGER "AFTER CREATE PROCEDURE" |
6065 |
|
ACTIVE AFTER CREATE PROCEDURE POSITION 0 |
6066 |
|
AS BEGIN END |
6067 |
< |
^ |
6067 |
> |
^ |
6068 |
|
CREATE TRIGGER "BEFORE ALTER PROCEDURE" |
6069 |
|
ACTIVE BEFORE ALTER PROCEDURE POSITION 0 |
6070 |
|
AS BEGIN END |
6071 |
< |
^ |
6071 |
> |
^ |
6072 |
|
CREATE TRIGGER "AFTER ALTER PROCEDURE" |
6073 |
|
ACTIVE AFTER ALTER PROCEDURE POSITION 0 |
6074 |
|
AS BEGIN END |
6075 |
< |
^ |
6075 |
> |
^ |
6076 |
|
CREATE TRIGGER "BEFORE DROP PROCEDURE" |
6077 |
|
ACTIVE BEFORE Drop PROCEDURE POSITION 0 |
6078 |
|
AS BEGIN END |
6079 |
< |
^ |
6079 |
> |
^ |
6080 |
|
CREATE TRIGGER "AFTER DROP PROCEDURE" |
6081 |
|
ACTIVE AFTER Drop PROCEDURE POSITION 0 |
6082 |
|
AS BEGIN END |
6083 |
< |
^ |
6083 |
> |
^ |
6084 |
|
CREATE TRIGGER "BEFORE CREATE FUNCTION" |
6085 |
|
ACTIVE BEFORE CREATE FUNCTION POSITION 0 |
6086 |
|
AS BEGIN END |
6087 |
< |
^ |
6087 |
> |
^ |
6088 |
|
CREATE TRIGGER "AFTER CREATE FUNCTION" |
6089 |
|
ACTIVE AFTER CREATE FUNCTION POSITION 0 |
6090 |
|
AS BEGIN END |
6091 |
< |
^ |
6091 |
> |
^ |
6092 |
|
CREATE TRIGGER "BEFORE ALTER FUNCTION" |
6093 |
|
ACTIVE BEFORE ALTER FUNCTION POSITION 0 |
6094 |
|
AS BEGIN END |
6095 |
< |
^ |
6095 |
> |
^ |
6096 |
|
CREATE TRIGGER "AFTER ALTER FUNCTION" |
6097 |
|
ACTIVE AFTER ALTER FUNCTION POSITION 0 |
6098 |
|
AS BEGIN END |
6099 |
< |
^ |
6099 |
> |
^ |
6100 |
|
CREATE TRIGGER "BEFORE DROP FUNCTION" |
6101 |
|
ACTIVE BEFORE Drop FUNCTION POSITION 0 |
6102 |
|
AS BEGIN END |
6103 |
< |
^ |
6103 |
> |
^ |
6104 |
|
CREATE TRIGGER "AFTER DROP FUNCTION" |
6105 |
|
ACTIVE AFTER Drop FUNCTION POSITION 0 |
6106 |
|
AS BEGIN END |
6107 |
< |
^ |
6107 |
> |
^ |
6108 |
|
CREATE TRIGGER "BEFORE CREATE TRIGGER" |
6109 |
|
ACTIVE BEFORE CREATE TRIGGER POSITION 0 |
6110 |
|
AS BEGIN END |
6111 |
< |
^ |
6111 |
> |
^ |
6112 |
|
CREATE TRIGGER "AFTER CREATE TRIGGER" |
6113 |
|
ACTIVE AFTER CREATE TRIGGER POSITION 0 |
6114 |
|
AS BEGIN END |
6115 |
< |
^ |
6115 |
> |
^ |
6116 |
|
CREATE TRIGGER "BEFORE ALTER TRIGGER" |
6117 |
|
ACTIVE BEFORE ALTER TRIGGER POSITION 0 |
6118 |
|
AS BEGIN END |
6119 |
< |
^ |
6119 |
> |
^ |
6120 |
|
CREATE TRIGGER "AFTER ALTER TRIGGER" |
6121 |
|
ACTIVE AFTER ALTER TRIGGER POSITION 0 |
6122 |
|
AS BEGIN END |
6123 |
< |
^ |
6123 |
> |
^ |
6124 |
|
CREATE TRIGGER "BEFORE DROP TRIGGER" |
6125 |
|
ACTIVE BEFORE Drop TRIGGER POSITION 0 |
6126 |
|
AS BEGIN END |
6127 |
< |
^ |
6127 |
> |
^ |
6128 |
|
CREATE TRIGGER "AFTER DROP TRIGGER" |
6129 |
|
ACTIVE AFTER Drop TRIGGER POSITION 0 |
6130 |
|
AS BEGIN END |
6131 |
< |
^ |
6131 |
> |
^ |
6132 |
|
CREATE TRIGGER "BEFORE CREATE EXCEPTION" |
6133 |
|
ACTIVE BEFORE CREATE EXCEPTION POSITION 0 |
6134 |
|
AS BEGIN END |
6135 |
< |
^ |
6135 |
> |
^ |
6136 |
|
CREATE TRIGGER "AFTER CREATE EXCEPTION" |
6137 |
|
ACTIVE AFTER CREATE EXCEPTION POSITION 0 |
6138 |
|
AS BEGIN END |
6139 |
< |
^ |
6139 |
> |
^ |
6140 |
|
CREATE TRIGGER "BEFORE ALTER EXCEPTION" |
6141 |
|
ACTIVE BEFORE ALTER EXCEPTION POSITION 0 |
6142 |
|
AS BEGIN END |
6143 |
< |
^ |
6143 |
> |
^ |
6144 |
|
CREATE TRIGGER "AFTER ALTER EXCEPTION" |
6145 |
|
ACTIVE AFTER ALTER EXCEPTION POSITION 0 |
6146 |
|
AS BEGIN END |
6147 |
< |
^ |
6147 |
> |
^ |
6148 |
|
CREATE TRIGGER "BEFORE DROP EXCEPTION" |
6149 |
|
ACTIVE BEFORE Drop EXCEPTION POSITION 0 |
6150 |
|
AS BEGIN END |
6151 |
< |
^ |
6151 |
> |
^ |
6152 |
|
CREATE TRIGGER "AFTER DROP EXCEPTION" |
6153 |
|
ACTIVE AFTER Drop EXCEPTION POSITION 0 |
6154 |
|
AS BEGIN END |
6155 |
< |
^ |
6155 |
> |
^ |
6156 |
|
CREATE TRIGGER "BEFORE CREATE VIEW" |
6157 |
|
ACTIVE BEFORE CREATE VIEW POSITION 0 |
6158 |
|
AS BEGIN END |
6159 |
< |
^ |
6159 |
> |
^ |
6160 |
|
CREATE TRIGGER "AFTER CREATE VIEW" |
6161 |
|
ACTIVE AFTER CREATE VIEW POSITION 0 |
6162 |
|
AS BEGIN END |
6163 |
< |
^ |
6163 |
> |
^ |
6164 |
|
CREATE TRIGGER "BEFORE ALTER VIEW" |
6165 |
|
ACTIVE BEFORE ALTER VIEW POSITION 0 |
6166 |
|
AS BEGIN END |
6167 |
< |
^ |
6167 |
> |
^ |
6168 |
|
CREATE TRIGGER "AFTER ALTER VIEW" |
6169 |
|
ACTIVE AFTER ALTER VIEW POSITION 0 |
6170 |
|
AS BEGIN END |
6171 |
< |
^ |
6171 |
> |
^ |
6172 |
|
CREATE TRIGGER "BEFORE DROP VIEW" |
6173 |
|
ACTIVE BEFORE Drop VIEW POSITION 0 |
6174 |
|
AS BEGIN END |
6175 |
< |
^ |
6175 |
> |
^ |
6176 |
|
CREATE TRIGGER "AFTER DROP VIEW" |
6177 |
|
ACTIVE AFTER Drop VIEW POSITION 0 |
6178 |
|
AS BEGIN END |
6179 |
< |
^ |
6179 |
> |
^ |
6180 |
|
CREATE TRIGGER "BEFORE CREATE DOMAIN" |
6181 |
|
ACTIVE BEFORE CREATE DOMAIN POSITION 0 |
6182 |
|
AS BEGIN END |
6183 |
< |
^ |
6183 |
> |
^ |
6184 |
|
CREATE TRIGGER "AFTER CREATE DOMAIN" |
6185 |
|
ACTIVE AFTER CREATE DOMAIN POSITION 0 |
6186 |
|
AS BEGIN END |
6187 |
< |
^ |
6187 |
> |
^ |
6188 |
|
CREATE TRIGGER "BEFORE ALTER DOMAIN" |
6189 |
|
ACTIVE BEFORE ALTER DOMAIN POSITION 0 |
6190 |
|
AS BEGIN END |
6191 |
< |
^ |
6191 |
> |
^ |
6192 |
|
CREATE TRIGGER "AFTER ALTER DOMAIN" |
6193 |
|
ACTIVE AFTER ALTER DOMAIN POSITION 0 |
6194 |
|
AS BEGIN END |
6195 |
< |
^ |
6195 |
> |
^ |
6196 |
|
CREATE TRIGGER "BEFORE DROP DOMAIN" |
6197 |
|
ACTIVE BEFORE Drop DOMAIN POSITION 0 |
6198 |
|
AS BEGIN END |
6199 |
< |
^ |
6199 |
> |
^ |
6200 |
|
CREATE TRIGGER "AFTER DROP DOMAIN" |
6201 |
|
ACTIVE AFTER Drop DOMAIN POSITION 0 |
6202 |
|
AS BEGIN END |
6203 |
< |
^ |
6203 |
> |
^ |
6204 |
|
CREATE TRIGGER "BEFORE CREATE ROLE" |
6205 |
|
ACTIVE BEFORE CREATE ROLE POSITION 0 |
6206 |
|
AS BEGIN END |
6207 |
< |
^ |
6207 |
> |
^ |
6208 |
|
CREATE TRIGGER "AFTER CREATE ROLE" |
6209 |
|
ACTIVE AFTER CREATE ROLE POSITION 0 |
6210 |
|
AS BEGIN END |
6211 |
< |
^ |
6211 |
> |
^ |
6212 |
|
CREATE TRIGGER "BEFORE ALTER ROLE" |
6213 |
|
ACTIVE BEFORE ALTER ROLE POSITION 0 |
6214 |
|
AS BEGIN END |
6215 |
< |
^ |
6215 |
> |
^ |
6216 |
|
CREATE TRIGGER "AFTER ALTER ROLE" |
6217 |
|
ACTIVE AFTER ALTER ROLE POSITION 0 |
6218 |
|
AS BEGIN END |
6219 |
< |
^ |
6219 |
> |
^ |
6220 |
|
CREATE TRIGGER "BEFORE DROP ROLE" |
6221 |
|
ACTIVE BEFORE Drop ROLE POSITION 0 |
6222 |
|
AS BEGIN END |
6223 |
< |
^ |
6223 |
> |
^ |
6224 |
|
CREATE TRIGGER "AFTER DROP ROLE" |
6225 |
|
ACTIVE AFTER Drop ROLE POSITION 0 |
6226 |
|
AS BEGIN END |
6227 |
< |
^ |
6227 |
> |
^ |
6228 |
|
CREATE TRIGGER "BEFORE CREATE INDEX" |
6229 |
|
ACTIVE BEFORE CREATE INDEX POSITION 0 |
6230 |
|
AS BEGIN END |
6231 |
< |
^ |
6231 |
> |
^ |
6232 |
|
CREATE TRIGGER "AFTER CREATE INDEX" |
6233 |
|
ACTIVE AFTER CREATE INDEX POSITION 0 |
6234 |
|
AS BEGIN END |
6235 |
< |
^ |
6235 |
> |
^ |
6236 |
|
CREATE TRIGGER "BEFORE ALTER INDEX" |
6237 |
|
ACTIVE BEFORE ALTER INDEX POSITION 0 |
6238 |
|
AS BEGIN END |
6239 |
< |
^ |
6239 |
> |
^ |
6240 |
|
CREATE TRIGGER "AFTER ALTER INDEX" |
6241 |
|
ACTIVE AFTER ALTER INDEX POSITION 0 |
6242 |
|
AS BEGIN END |
6243 |
< |
^ |
6243 |
> |
^ |
6244 |
|
CREATE TRIGGER "BEFORE DROP INDEX" |
6245 |
|
ACTIVE BEFORE Drop INDEX POSITION 0 |
6246 |
|
AS BEGIN END |
6247 |
< |
^ |
6247 |
> |
^ |
6248 |
|
CREATE TRIGGER "AFTER DROP INDEX" |
6249 |
|
ACTIVE AFTER Drop INDEX POSITION 0 |
6250 |
|
AS BEGIN END |
6251 |
< |
^ |
6251 |
> |
^ |
6252 |
|
CREATE TRIGGER "BEFORE CREATE SEQUENCE" |
6253 |
|
ACTIVE BEFORE CREATE SEQUENCE POSITION 0 |
6254 |
|
AS BEGIN END |
6255 |
< |
^ |
6255 |
> |
^ |
6256 |
|
CREATE TRIGGER "AFTER CREATE SEQUENCE" |
6257 |
|
ACTIVE AFTER CREATE SEQUENCE POSITION 0 |
6258 |
|
AS BEGIN END |
6259 |
< |
^ |
6259 |
> |
^ |
6260 |
|
CREATE TRIGGER "BEFORE ALTER SEQUENCE" |
6261 |
|
ACTIVE BEFORE ALTER SEQUENCE POSITION 0 |
6262 |
|
AS BEGIN END |
6263 |
< |
^ |
6263 |
> |
^ |
6264 |
|
CREATE TRIGGER "AFTER ALTER SEQUENCE" |
6265 |
|
ACTIVE AFTER ALTER SEQUENCE POSITION 0 |
6266 |
|
AS BEGIN END |
6267 |
< |
^ |
6267 |
> |
^ |
6268 |
|
CREATE TRIGGER "BEFORE DROP SEQUENCE" |
6269 |
|
ACTIVE BEFORE Drop SEQUENCE POSITION 0 |
6270 |
|
AS BEGIN END |
6271 |
< |
^ |
6271 |
> |
^ |
6272 |
|
CREATE TRIGGER "AFTER DROP SEQUENCE" |
6273 |
|
ACTIVE AFTER Drop SEQUENCE POSITION 0 |
6274 |
|
AS BEGIN END |
6275 |
< |
^ |
6275 |
> |
^ |
6276 |
|
CREATE TRIGGER "BEFORE CREATE USER" |
6277 |
|
ACTIVE BEFORE CREATE USER POSITION 0 |
6278 |
|
AS BEGIN END |
6279 |
< |
^ |
6279 |
> |
^ |
6280 |
|
CREATE TRIGGER "AFTER CREATE USER" |
6281 |
|
ACTIVE AFTER CREATE USER POSITION 0 |
6282 |
|
AS BEGIN END |
6283 |
< |
^ |
6283 |
> |
^ |
6284 |
|
CREATE TRIGGER "BEFORE ALTER USER" |
6285 |
|
ACTIVE BEFORE ALTER USER POSITION 0 |
6286 |
|
AS BEGIN END |
6287 |
< |
^ |
6287 |
> |
^ |
6288 |
|
CREATE TRIGGER "AFTER ALTER USER" |
6289 |
|
ACTIVE AFTER ALTER USER POSITION 0 |
6290 |
|
AS BEGIN END |
6291 |
< |
^ |
6291 |
> |
^ |
6292 |
|
CREATE TRIGGER "BEFORE DROP USER" |
6293 |
|
ACTIVE BEFORE Drop USER POSITION 0 |
6294 |
|
AS BEGIN END |
6295 |
< |
^ |
6295 |
> |
^ |
6296 |
|
CREATE TRIGGER "AFTER DROP USER" |
6297 |
|
ACTIVE AFTER Drop USER POSITION 0 |
6298 |
|
AS BEGIN END |
6299 |
< |
^ |
6299 |
> |
^ |
6300 |
|
CREATE TRIGGER "BEFORE CREATE COLLATION" |
6301 |
|
ACTIVE BEFORE CREATE COLLATION POSITION 0 |
6302 |
|
AS BEGIN END |
6303 |
< |
^ |
6303 |
> |
^ |
6304 |
|
CREATE TRIGGER "AFTER CREATE COLLATION" |
6305 |
|
ACTIVE AFTER CREATE COLLATION POSITION 0 |
6306 |
|
AS BEGIN END |
6307 |
< |
^ |
6307 |
> |
^ |
6308 |
|
CREATE TRIGGER "BEFORE DROP COLLATION" |
6309 |
|
ACTIVE BEFORE Drop COLLATION POSITION 0 |
6310 |
|
AS BEGIN END |
6311 |
< |
^ |
6311 |
> |
^ |
6312 |
|
CREATE TRIGGER "AFTER DROP COLLATION" |
6313 |
|
ACTIVE AFTER Drop COLLATION POSITION 0 |
6314 |
|
AS BEGIN END |
6315 |
< |
^ |
6315 |
> |
^ |
6316 |
|
CREATE TRIGGER "BEFORE ALTER CHARACTER SET" |
6317 |
|
ACTIVE BEFORE ALTER CHARACTER SET POSITION 0 |
6318 |
|
AS BEGIN END |
6319 |
< |
^ |
6319 |
> |
^ |
6320 |
|
CREATE TRIGGER "AFTER ALTER CHARACTER SET" |
6321 |
|
ACTIVE AFTER ALTER CHARACTER SET POSITION 0 |
6322 |
|
AS BEGIN END |
6323 |
< |
^ |
6323 |
> |
^ |
6324 |
|
CREATE TRIGGER "BEFORE CREATE PACKAGE" |
6325 |
|
ACTIVE BEFORE CREATE PACKAGE POSITION 0 |
6326 |
|
AS BEGIN END |
6327 |
< |
^ |
6327 |
> |
^ |
6328 |
|
CREATE TRIGGER "AFTER CREATE PACKAGE" |
6329 |
|
ACTIVE AFTER CREATE PACKAGE POSITION 0 |
6330 |
|
AS BEGIN END |
6331 |
< |
^ |
6331 |
> |
^ |
6332 |
|
CREATE TRIGGER "BEFORE ALTER PACKAGE" |
6333 |
|
ACTIVE BEFORE ALTER PACKAGE POSITION 0 |
6334 |
|
AS BEGIN END |
6335 |
< |
^ |
6335 |
> |
^ |
6336 |
|
CREATE TRIGGER "AFTER ALTER PACKAGE" |
6337 |
|
ACTIVE AFTER ALTER PACKAGE POSITION 0 |
6338 |
|
AS BEGIN END |
6339 |
< |
^ |
6339 |
> |
^ |
6340 |
|
CREATE TRIGGER "BEFORE DROP PACKAGE" |
6341 |
|
ACTIVE BEFORE Drop PACKAGE POSITION 0 |
6342 |
|
AS BEGIN END |
6343 |
< |
^ |
6343 |
> |
^ |
6344 |
|
CREATE TRIGGER "AFTER DROP PACKAGE" |
6345 |
|
ACTIVE AFTER Drop PACKAGE POSITION 0 |
6346 |
|
AS BEGIN END |
6347 |
< |
^ |
6347 |
> |
^ |
6348 |
|
CREATE TRIGGER "BEFORE CREATE PACKAGE BODY" |
6349 |
|
ACTIVE BEFORE CREATE PACKAGE BODY POSITION 0 |
6350 |
|
AS BEGIN END |
6351 |
< |
^ |
6351 |
> |
^ |
6352 |
|
CREATE TRIGGER "AFTER CREATE PACKAGE BODY" |
6353 |
|
ACTIVE AFTER CREATE PACKAGE BODY POSITION 0 |
6354 |
|
AS BEGIN END |
6355 |
< |
^ |
6355 |
> |
^ |
6356 |
|
CREATE TRIGGER "BEFORE DROP PACKAGE BODY" |
6357 |
|
ACTIVE BEFORE Drop PACKAGE BODY POSITION 0 |
6358 |
|
AS BEGIN END |
6359 |
< |
^ |
6359 |
> |
^ |
6360 |
|
CREATE TRIGGER "AFTER DROP PACKAGE BODY" |
6361 |
|
ACTIVE AFTER Drop PACKAGE BODY POSITION 0 |
6362 |
|
AS BEGIN END |
6363 |
< |
^ |
6363 |
> |
^ |
6364 |
|
CREATE TRIGGER "BEFORE ANY DDL STATEMENT" |
6365 |
|
ACTIVE BEFORE ANY DDL STATEMENT POSITION 0 |
6366 |
|
AS BEGIN END |
6367 |
< |
^ |
6367 |
> |
^ |
6368 |
|
CREATE TRIGGER "AFTER ANY DDL STATEMENT" |
6369 |
|
ACTIVE AFTER ANY DDL STATEMENT POSITION 0 |
6370 |
|
AS BEGIN END |
6371 |
< |
^ |
6371 |
> |
^ |
6372 |
|
CREATE TRIGGER SET_CUST_NO FOR CUSTOMER |
6373 |
|
ACTIVE BEFORE INSERT POSITION 0 |
6374 |
|
AS |
6376 |
|
if (new.cust_no is null) then |
6377 |
|
new.cust_no = gen_id(cust_no_gen, 1); |
6378 |
|
END |
6379 |
< |
^ |
6379 |
> |
^ |
6380 |
|
CREATE TRIGGER SET_EMP_NO FOR EMPLOYEE |
6381 |
|
ACTIVE BEFORE INSERT POSITION 0 |
6382 |
|
AS |
6384 |
|
if (new.emp_no is null) then |
6385 |
|
new.emp_no = gen_id(emp_no_gen, 1); |
6386 |
|
END |
6387 |
< |
^ |
6387 |
> |
^ |
6388 |
|
CREATE TRIGGER SAVE_SALARY_CHANGE FOR EMPLOYEE |
6389 |
|
ACTIVE AFTER UPDATE POSITION 0 |
6390 |
|
AS |
6399 |
|
old.salary, |
6400 |
|
(new.salary - old.salary) * 100 / old.salary); |
6401 |
|
END |
6402 |
< |
^ |
6402 |
> |
^ |
6403 |
|
CREATE TRIGGER POST_NEW_ORDER FOR SALES |
6404 |
|
ACTIVE AFTER INSERT POSITION 0 |
6405 |
|
AS |
6406 |
|
BEGIN |
6407 |
|
POST_EVENT 'new_order'; |
6408 |
|
END |
6409 |
< |
^ |
6410 |
< |
COMMIT WORK ^ |
6409 |
> |
^ |
6410 |
> |
COMMIT WORK^ |
6411 |
|
SET TERM ;^ |
6412 |
|
COMMIT WORK; |
6413 |
|
SET AUTODDL OFF; |
6472 |
|
execute procedure clear; |
6473 |
|
end |
6474 |
|
end |
6475 |
< |
^ |
6475 |
> |
^ |
6476 |
|
|
6477 |
|
CREATE PACKAGE BODY SELECT$TEST |
6478 |
|
AS |
6484 |
|
SUSPEND; |
6485 |
|
End |
6486 |
|
End |
6487 |
< |
^ |
6487 |
> |
^ |
6488 |
|
|
6489 |
< |
SET TERM ; ^ |
6489 |
> |
SET TERM ;^ |
6490 |
|
COMMIT WORK; |
6491 |
|
SET AUTODDL ON; |
6492 |
|
COMMIT WORK; |
6522 |
|
SUSPEND; |
6523 |
|
END |
6524 |
|
END |
6525 |
< |
^ |
6525 |
> |
^ |
6526 |
|
|
6527 |
|
|
6528 |
|
ALTER PROCEDURE ADD_EMP_PROJ |
6538 |
|
EXCEPTION unknown_emp_id; |
6539 |
|
END |
6540 |
|
END |
6541 |
< |
^ |
6546 |
< |
|
6541 |
> |
^ |
6542 |
|
|
6543 |
|
ALTER PROCEDURE ALL_LANGS |
6544 |
|
RETURNS |
6566 |
|
SUSPEND; |
6567 |
|
END |
6568 |
|
END |
6569 |
< |
^ |
6569 |
> |
^ |
6570 |
|
|
6571 |
|
|
6572 |
|
ALTER PROCEDURE DELETE_EMPLOYEE |
6580 |
|
|
6581 |
|
/* |
6582 |
|
* If there are any sales records referencing this employee, |
6583 |
< |
* can't delete the employee until the sales are re-assigned |
6583 |
> |
* cannot delete the employee until the sales are re-assigned |
6584 |
|
* to another employee or changed to NULL. |
6585 |
|
*/ |
6586 |
|
SELECT count(po_number) |
6626 |
|
WHERE emp_no = :emp_num; |
6627 |
|
|
6628 |
|
END |
6629 |
< |
^ |
6629 |
> |
^ |
6630 |
|
|
6631 |
|
|
6632 |
|
ALTER PROCEDURE DEPT_BUDGET |
6663 |
|
|
6664 |
|
SUSPEND; |
6665 |
|
END |
6666 |
< |
^ |
6666 |
> |
^ |
6667 |
|
|
6668 |
+ |
ALTER PROCEDURE EMPLOYEE_PAY_STATUS |
6669 |
+ |
( |
6670 |
+ |
EMP_NUM SMALLINT |
6671 |
+ |
) |
6672 |
+ |
RETURNS |
6673 |
+ |
( |
6674 |
+ |
PAY_STATUS VARCHAR(6) CHARACTER SET NONE, |
6675 |
+ |
SALARY NUMERIC(10,2) |
6676 |
+ |
) |
6677 |
+ |
AS |
6678 |
+ |
BEGIN |
6679 |
+ |
Select SALARY, Case |
6680 |
+ |
When SALARY > 10000 and SALARY <= 100000 then 'higher' |
6681 |
+ |
When SALARY > 100000 then 'gross' |
6682 |
+ |
else 'lower' End |
6683 |
+ |
From employee |
6684 |
+ |
WHERE emp_no = :EMP_NUM |
6685 |
+ |
into :SALARY, :PAY_STATUS; |
6686 |
+ |
END |
6687 |
+ |
^ |
6688 |
|
|
6689 |
|
ALTER PROCEDURE GET_EMP_PROJ |
6690 |
|
( |
6703 |
|
DO |
6704 |
|
SUSPEND; |
6705 |
|
END |
6706 |
< |
^ |
6706 |
> |
^ |
6707 |
|
|
6708 |
|
|
6709 |
|
ALTER PROCEDURE "Has Space" |
6712 |
|
) |
6713 |
|
AS |
6714 |
|
Begin End |
6715 |
< |
^ |
6715 |
> |
^ |
6716 |
|
|
6717 |
|
|
6718 |
|
ALTER PROCEDURE MAIL_LABEL |
6783 |
|
|
6784 |
|
SUSPEND; |
6785 |
|
END |
6786 |
< |
^ |
6786 |
> |
^ |
6787 |
|
|
6788 |
|
|
6789 |
|
ALTER PROCEDURE ORG_CHART |
6826 |
|
SUSPEND; |
6827 |
|
END |
6828 |
|
END |
6829 |
< |
^ |
6829 |
> |
^ |
6830 |
|
|
6831 |
|
|
6832 |
|
ALTER PROCEDURE SHIP_ORDER |
6886 |
|
WHERE po_number = :po_num; |
6887 |
|
|
6888 |
|
END |
6889 |
< |
^ |
6889 |
> |
^ |
6890 |
|
|
6891 |
|
|
6892 |
|
ALTER PROCEDURE SUB_TOT_BUDGET |
6908 |
|
INTO :tot_budget, :avg_budget, :min_budget, :max_budget; |
6909 |
|
SUSPEND; |
6910 |
|
END |
6911 |
< |
^ |
6911 |
> |
^ |
6912 |
|
|
6913 |
|
|
6914 |
|
ALTER PROCEDURE "UC SPACE" |
6917 |
|
) |
6918 |
|
AS |
6919 |
|
Begin End |
6920 |
< |
^ |
6920 |
> |
^ |
6921 |
|
|
6922 |
|
|
6923 |
|
ALTER PROCEDURE "iCASE" |
6924 |
|
AS |
6925 |
|
Begin End |
6926 |
< |
^ |
6926 |
> |
^ |
6927 |
|
|
6928 |
< |
SET TERM ; ^ |
6928 |
> |
SET TERM ;^ |
6929 |
|
COMMIT WORK; |
6930 |
|
SET AUTODDL ON; |
6931 |
|
COMMIT WORK; |
6943 |
|
^ |
6944 |
|
|
6945 |
|
|
6946 |
< |
SET TERM ; ^ |
6946 |
> |
SET TERM ;^ |
6947 |
|
COMMIT WORK; |
6948 |
|
SET AUTODDL ON; |
6949 |
|
|
6957 |
|
/* Role: TESTROLE, Owner: SYSDBA */ |
6958 |
|
|
6959 |
|
CREATE ROLE TESTROLE SET SYSTEM PRIVILEGES TO CREATE_DATABASE; |
6960 |
< |
Error processing SQL statement: On Line 2246 Character 1: Dynamic SQL Error |
6960 |
> |
Error processing SQL statement: On Line 2281 Character 1: Dynamic SQL Error |
6961 |
|
-SQL error code = -104 |
6962 |
|
-Token unknown - line 1, column 22 |
6963 |
|
-SET When Executing: CREATE ROLE TESTROLE SET SYSTEM PRIVILEGES TO CREATE_DATABASE |
7991 |
|
SALARY, |
7992 |
|
FULL_NAME, |
7993 |
|
DEPT_PATH, |
7994 |
< |
DEPT_KEY_PATH |
7994 |
> |
DEPT_KEY_PATH, |
7995 |
> |
"Payment Status" |
7996 |
|
) AS |
7997 |
|
with recursive Depts As ( |
7998 |
|
Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH, |
8006 |
|
) |
8007 |
|
|
8008 |
|
Select distinct A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE, |
8009 |
< |
A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH |
8009 |
> |
A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH, |
8010 |
> |
CASE When A.SALARY > 10000 then 'higher paid' else 'lower paid' End |
8011 |
|
From EMPLOYEE A |
8012 |
|
JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
8013 |
|
; |
8156 |
|
|
8157 |
|
/* Stored procedures Definitions*/ |
8158 |
|
|
8159 |
< |
CREATE PROCEDURE SHOW_LANGS |
8159 |
> |
CREATE PROCEDURE SHOW_LANGS |
8160 |
|
( |
8161 |
|
CODE VARCHAR(5) CHARACTER SET NONE, |
8162 |
|
GRADE SMALLINT, |
8169 |
|
AS |
8170 |
|
BEGIN SUSPEND; EXIT; END |
8171 |
|
^ |
8172 |
< |
|
8156 |
< |
CREATE PROCEDURE ADD_EMP_PROJ |
8172 |
> |
CREATE PROCEDURE ADD_EMP_PROJ |
8173 |
|
( |
8174 |
|
EMP_NO SMALLINT, |
8175 |
|
PROJ_ID CHAR(5) CHARACTER SET NONE |
8177 |
|
AS |
8178 |
|
BEGIN EXIT; END |
8179 |
|
^ |
8180 |
< |
|
8165 |
< |
CREATE PROCEDURE ALL_LANGS |
8180 |
> |
CREATE PROCEDURE ALL_LANGS |
8181 |
|
RETURNS |
8182 |
|
( |
8183 |
|
CODE VARCHAR(5) CHARACTER SET NONE, |
8188 |
|
AS |
8189 |
|
BEGIN SUSPEND; EXIT; END |
8190 |
|
^ |
8191 |
< |
|
8177 |
< |
CREATE PROCEDURE DELETE_EMPLOYEE |
8191 |
> |
CREATE PROCEDURE DELETE_EMPLOYEE |
8192 |
|
( |
8193 |
|
EMP_NUM INTEGER |
8194 |
|
) |
8195 |
|
AS |
8196 |
|
BEGIN EXIT; END |
8197 |
|
^ |
8198 |
< |
|
8185 |
< |
CREATE PROCEDURE DEPT_BUDGET |
8198 |
> |
CREATE PROCEDURE DEPT_BUDGET |
8199 |
|
( |
8200 |
|
DNO CHAR(3) CHARACTER SET NONE |
8201 |
|
) |
8206 |
|
AS |
8207 |
|
BEGIN SUSPEND; EXIT; END |
8208 |
|
^ |
8209 |
< |
|
8210 |
< |
CREATE PROCEDURE GET_EMP_PROJ |
8209 |
> |
CREATE PROCEDURE EMPLOYEE_PAY_STATUS |
8210 |
> |
( |
8211 |
> |
EMP_NUM SMALLINT |
8212 |
> |
) |
8213 |
> |
RETURNS |
8214 |
> |
( |
8215 |
> |
PAY_STATUS VARCHAR(6) CHARACTER SET NONE, |
8216 |
> |
SALARY NUMERIC(10, 2) |
8217 |
> |
) |
8218 |
> |
AS |
8219 |
> |
BEGIN EXIT; END |
8220 |
> |
^ |
8221 |
> |
CREATE PROCEDURE GET_EMP_PROJ |
8222 |
|
( |
8223 |
|
EMP_NO SMALLINT |
8224 |
|
) |
8229 |
|
AS |
8230 |
|
BEGIN SUSPEND; EXIT; END |
8231 |
|
^ |
8232 |
< |
|
8209 |
< |
CREATE PROCEDURE "Has Space" |
8232 |
> |
CREATE PROCEDURE "Has Space" |
8233 |
|
( |
8234 |
|
ARG1 INTEGER |
8235 |
|
) |
8236 |
|
AS |
8237 |
|
BEGIN EXIT; END |
8238 |
|
^ |
8239 |
< |
|
8217 |
< |
CREATE PROCEDURE MAIL_LABEL |
8239 |
> |
CREATE PROCEDURE MAIL_LABEL |
8240 |
|
( |
8241 |
|
CUST_NO INTEGER |
8242 |
|
) |
8252 |
|
AS |
8253 |
|
BEGIN SUSPEND; EXIT; END |
8254 |
|
^ |
8255 |
< |
|
8234 |
< |
CREATE PROCEDURE ORG_CHART |
8255 |
> |
CREATE PROCEDURE ORG_CHART |
8256 |
|
RETURNS |
8257 |
|
( |
8258 |
|
HEAD_DEPT CHAR(25) CHARACTER SET NONE, |
8264 |
|
AS |
8265 |
|
BEGIN SUSPEND; EXIT; END |
8266 |
|
^ |
8267 |
< |
|
8247 |
< |
CREATE PROCEDURE SHIP_ORDER |
8267 |
> |
CREATE PROCEDURE SHIP_ORDER |
8268 |
|
( |
8269 |
|
PO_NUM CHAR(8) CHARACTER SET NONE |
8270 |
|
) |
8271 |
|
AS |
8272 |
|
BEGIN EXIT; END |
8273 |
|
^ |
8274 |
< |
|
8255 |
< |
CREATE PROCEDURE SUB_TOT_BUDGET |
8274 |
> |
CREATE PROCEDURE SUB_TOT_BUDGET |
8275 |
|
( |
8276 |
|
HEAD_DEPT CHAR(3) CHARACTER SET NONE |
8277 |
|
) |
8285 |
|
AS |
8286 |
|
BEGIN SUSPEND; EXIT; END |
8287 |
|
^ |
8288 |
< |
|
8270 |
< |
CREATE PROCEDURE "UC SPACE" |
8288 |
> |
CREATE PROCEDURE "UC SPACE" |
8289 |
|
( |
8290 |
|
ARG1 INTEGER |
8291 |
|
) |
8292 |
|
AS |
8293 |
|
BEGIN EXIT; END |
8294 |
|
^ |
8295 |
< |
|
8278 |
< |
CREATE PROCEDURE "iCASE" |
8295 |
> |
CREATE PROCEDURE "iCASE" |
8296 |
|
AS |
8297 |
|
BEGIN EXIT; END |
8298 |
|
^ |
8282 |
– |
|
8299 |
|
SET TERM ; ^ |
8300 |
|
COMMIT WORK; |
8301 |
|
SET AUTODDL ON; |
8792 |
|
/* Stored procedure Bodies */ |
8793 |
|
|
8794 |
|
|
8795 |
< |
ALTER PROCEDURE SHOW_LANGS |
8795 |
> |
ALTER PROCEDURE SHOW_LANGS |
8796 |
|
( |
8797 |
|
CODE VARCHAR(5) CHARACTER SET NONE, |
8798 |
|
GRADE SMALLINT, |
8818 |
|
SUSPEND; |
8819 |
|
END |
8820 |
|
END |
8821 |
< |
^ |
8806 |
< |
|
8821 |
> |
^ |
8822 |
|
|
8823 |
< |
ALTER PROCEDURE ADD_EMP_PROJ |
8823 |
> |
ALTER PROCEDURE ADD_EMP_PROJ |
8824 |
|
( |
8825 |
|
EMP_NO SMALLINT, |
8826 |
|
PROJ_ID CHAR(5) CHARACTER SET NONE |
8833 |
|
EXCEPTION unknown_emp_id; |
8834 |
|
END |
8835 |
|
END |
8836 |
< |
^ |
8822 |
< |
|
8836 |
> |
^ |
8837 |
|
|
8838 |
< |
ALTER PROCEDURE ALL_LANGS |
8838 |
> |
ALTER PROCEDURE ALL_LANGS |
8839 |
|
RETURNS |
8840 |
|
( |
8841 |
|
CODE VARCHAR(5) CHARACTER SET NONE, |
8861 |
|
SUSPEND; |
8862 |
|
END |
8863 |
|
END |
8864 |
< |
^ |
8851 |
< |
|
8864 |
> |
^ |
8865 |
|
|
8866 |
< |
ALTER PROCEDURE DELETE_EMPLOYEE |
8866 |
> |
ALTER PROCEDURE DELETE_EMPLOYEE |
8867 |
|
( |
8868 |
|
EMP_NUM INTEGER |
8869 |
|
) |
8874 |
|
|
8875 |
|
/* |
8876 |
|
* If there are any sales records referencing this employee, |
8877 |
< |
* can't delete the employee until the sales are re-assigned |
8877 |
> |
* cannot delete the employee until the sales are re-assigned |
8878 |
|
* to another employee or changed to NULL. |
8879 |
|
*/ |
8880 |
|
SELECT count(po_number) |
8920 |
|
WHERE emp_no = :emp_num; |
8921 |
|
|
8922 |
|
END |
8923 |
< |
^ |
8911 |
< |
|
8923 |
> |
^ |
8924 |
|
|
8925 |
< |
ALTER PROCEDURE DEPT_BUDGET |
8925 |
> |
ALTER PROCEDURE DEPT_BUDGET |
8926 |
|
( |
8927 |
|
DNO CHAR(3) CHARACTER SET NONE |
8928 |
|
) |
8956 |
|
|
8957 |
|
SUSPEND; |
8958 |
|
END |
8959 |
< |
^ |
8959 |
> |
^ |
8960 |
|
|
8961 |
+ |
ALTER PROCEDURE EMPLOYEE_PAY_STATUS |
8962 |
+ |
( |
8963 |
+ |
EMP_NUM SMALLINT |
8964 |
+ |
) |
8965 |
+ |
RETURNS |
8966 |
+ |
( |
8967 |
+ |
PAY_STATUS VARCHAR(6) CHARACTER SET NONE, |
8968 |
+ |
SALARY NUMERIC(10, 2) |
8969 |
+ |
) |
8970 |
+ |
AS |
8971 |
+ |
BEGIN |
8972 |
+ |
Select SALARY, Case |
8973 |
+ |
When SALARY > 10000 and SALARY <= 100000 then 'higher' |
8974 |
+ |
When SALARY > 100000 then 'gross' |
8975 |
+ |
else 'lower' End |
8976 |
+ |
From employee |
8977 |
+ |
WHERE emp_no = :EMP_NUM |
8978 |
+ |
into :SALARY, :PAY_STATUS; |
8979 |
+ |
END |
8980 |
+ |
^ |
8981 |
|
|
8982 |
< |
ALTER PROCEDURE GET_EMP_PROJ |
8982 |
> |
ALTER PROCEDURE GET_EMP_PROJ |
8983 |
|
( |
8984 |
|
EMP_NO SMALLINT |
8985 |
|
) |
8996 |
|
DO |
8997 |
|
SUSPEND; |
8998 |
|
END |
8999 |
< |
^ |
8968 |
< |
|
8999 |
> |
^ |
9000 |
|
|
9001 |
< |
ALTER PROCEDURE "Has Space" |
9001 |
> |
ALTER PROCEDURE "Has Space" |
9002 |
|
( |
9003 |
|
ARG1 INTEGER |
9004 |
|
) |
9005 |
|
AS |
9006 |
|
Begin End |
9007 |
< |
^ |
8977 |
< |
|
9007 |
> |
^ |
9008 |
|
|
9009 |
< |
ALTER PROCEDURE MAIL_LABEL |
9009 |
> |
ALTER PROCEDURE MAIL_LABEL |
9010 |
|
( |
9011 |
|
CUST_NO INTEGER |
9012 |
|
) |
9074 |
|
|
9075 |
|
SUSPEND; |
9076 |
|
END |
9077 |
< |
^ |
9048 |
< |
|
9077 |
> |
^ |
9078 |
|
|
9079 |
< |
ALTER PROCEDURE ORG_CHART |
9079 |
> |
ALTER PROCEDURE ORG_CHART |
9080 |
|
RETURNS |
9081 |
|
( |
9082 |
|
HEAD_DEPT CHAR(25) CHARACTER SET NONE, |
9116 |
|
SUSPEND; |
9117 |
|
END |
9118 |
|
END |
9119 |
< |
^ |
9091 |
< |
|
9119 |
> |
^ |
9120 |
|
|
9121 |
< |
ALTER PROCEDURE SHIP_ORDER |
9121 |
> |
ALTER PROCEDURE SHIP_ORDER |
9122 |
|
( |
9123 |
|
PO_NUM CHAR(8) CHARACTER SET NONE |
9124 |
|
) |
9175 |
|
WHERE po_number = :po_num; |
9176 |
|
|
9177 |
|
END |
9178 |
< |
^ |
9151 |
< |
|
9178 |
> |
^ |
9179 |
|
|
9180 |
< |
ALTER PROCEDURE SUB_TOT_BUDGET |
9180 |
> |
ALTER PROCEDURE SUB_TOT_BUDGET |
9181 |
|
( |
9182 |
|
HEAD_DEPT CHAR(3) CHARACTER SET NONE |
9183 |
|
) |
9196 |
|
INTO :tot_budget, :avg_budget, :min_budget, :max_budget; |
9197 |
|
SUSPEND; |
9198 |
|
END |
9199 |
< |
^ |
9173 |
< |
|
9199 |
> |
^ |
9200 |
|
|
9201 |
< |
ALTER PROCEDURE "UC SPACE" |
9201 |
> |
ALTER PROCEDURE "UC SPACE" |
9202 |
|
( |
9203 |
|
ARG1 INTEGER |
9204 |
|
) |
9205 |
|
AS |
9206 |
|
Begin End |
9207 |
< |
^ |
9182 |
< |
|
9207 |
> |
^ |
9208 |
|
|
9209 |
< |
ALTER PROCEDURE "iCASE" |
9209 |
> |
ALTER PROCEDURE "iCASE" |
9210 |
|
AS |
9211 |
|
Begin End |
9212 |
< |
^ |
9188 |
< |
|
9212 |
> |
^ |
9213 |
|
SET TERM ; ^ |
9214 |
|
COMMIT WORK; |
9215 |
|
SET AUTODDL ON; |
10264 |
|
SALARY, |
10265 |
|
FULL_NAME, |
10266 |
|
DEPT_PATH, |
10267 |
< |
DEPT_KEY_PATH |
10267 |
> |
DEPT_KEY_PATH, |
10268 |
> |
"Payment Status" |
10269 |
|
) AS |
10270 |
|
with recursive Depts As ( |
10271 |
|
Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH, |
10279 |
|
) |
10280 |
|
|
10281 |
|
Select distinct A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE, |
10282 |
< |
A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH |
10282 |
> |
A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH, |
10283 |
> |
CASE When A.SALARY > 10000 then 'higher paid' else 'lower paid' End |
10284 |
|
From EMPLOYEE A |
10285 |
|
JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
10286 |
|
; |
10429 |
|
|
10430 |
|
/* Stored procedures Definitions*/ |
10431 |
|
|
10432 |
< |
CREATE PROCEDURE SHOW_LANGS |
10432 |
> |
CREATE PROCEDURE SHOW_LANGS |
10433 |
|
( |
10434 |
|
CODE VARCHAR(5) CHARACTER SET NONE, |
10435 |
|
GRADE SMALLINT, |
10442 |
|
AS |
10443 |
|
BEGIN SUSPEND; EXIT; END |
10444 |
|
^ |
10445 |
< |
|
10420 |
< |
CREATE PROCEDURE ADD_EMP_PROJ |
10445 |
> |
CREATE PROCEDURE ADD_EMP_PROJ |
10446 |
|
( |
10447 |
|
EMP_NO SMALLINT, |
10448 |
|
PROJ_ID CHAR(5) CHARACTER SET NONE |
10450 |
|
AS |
10451 |
|
BEGIN EXIT; END |
10452 |
|
^ |
10453 |
< |
|
10429 |
< |
CREATE PROCEDURE ALL_LANGS |
10453 |
> |
CREATE PROCEDURE ALL_LANGS |
10454 |
|
RETURNS |
10455 |
|
( |
10456 |
|
CODE VARCHAR(5) CHARACTER SET NONE, |
10461 |
|
AS |
10462 |
|
BEGIN SUSPEND; EXIT; END |
10463 |
|
^ |
10464 |
< |
|
10441 |
< |
CREATE PROCEDURE DELETE_EMPLOYEE |
10464 |
> |
CREATE PROCEDURE DELETE_EMPLOYEE |
10465 |
|
( |
10466 |
|
EMP_NUM INTEGER |
10467 |
|
) |
10468 |
|
AS |
10469 |
|
BEGIN EXIT; END |
10470 |
|
^ |
10471 |
< |
|
10449 |
< |
CREATE PROCEDURE DEPT_BUDGET |
10471 |
> |
CREATE PROCEDURE DEPT_BUDGET |
10472 |
|
( |
10473 |
|
DNO CHAR(3) CHARACTER SET NONE |
10474 |
|
) |
10479 |
|
AS |
10480 |
|
BEGIN SUSPEND; EXIT; END |
10481 |
|
^ |
10482 |
< |
|
10483 |
< |
CREATE PROCEDURE GET_EMP_PROJ |
10482 |
> |
CREATE PROCEDURE EMPLOYEE_PAY_STATUS |
10483 |
> |
( |
10484 |
> |
EMP_NUM SMALLINT |
10485 |
> |
) |
10486 |
> |
RETURNS |
10487 |
> |
( |
10488 |
> |
PAY_STATUS VARCHAR(6) CHARACTER SET NONE, |
10489 |
> |
SALARY NUMERIC(10, 2) |
10490 |
> |
) |
10491 |
> |
AS |
10492 |
> |
BEGIN EXIT; END |
10493 |
> |
^ |
10494 |
> |
CREATE PROCEDURE GET_EMP_PROJ |
10495 |
|
( |
10496 |
|
EMP_NO SMALLINT |
10497 |
|
) |
10502 |
|
AS |
10503 |
|
BEGIN SUSPEND; EXIT; END |
10504 |
|
^ |
10505 |
< |
|
10473 |
< |
CREATE PROCEDURE "Has Space" |
10505 |
> |
CREATE PROCEDURE "Has Space" |
10506 |
|
( |
10507 |
|
ARG1 INTEGER |
10508 |
|
) |
10509 |
|
AS |
10510 |
|
BEGIN EXIT; END |
10511 |
|
^ |
10512 |
< |
|
10481 |
< |
CREATE PROCEDURE MAIL_LABEL |
10512 |
> |
CREATE PROCEDURE MAIL_LABEL |
10513 |
|
( |
10514 |
|
CUST_NO INTEGER |
10515 |
|
) |
10525 |
|
AS |
10526 |
|
BEGIN SUSPEND; EXIT; END |
10527 |
|
^ |
10528 |
< |
|
10498 |
< |
CREATE PROCEDURE ORG_CHART |
10528 |
> |
CREATE PROCEDURE ORG_CHART |
10529 |
|
RETURNS |
10530 |
|
( |
10531 |
|
HEAD_DEPT CHAR(25) CHARACTER SET NONE, |
10537 |
|
AS |
10538 |
|
BEGIN SUSPEND; EXIT; END |
10539 |
|
^ |
10540 |
< |
|
10511 |
< |
CREATE PROCEDURE SHIP_ORDER |
10540 |
> |
CREATE PROCEDURE SHIP_ORDER |
10541 |
|
( |
10542 |
|
PO_NUM CHAR(8) CHARACTER SET NONE |
10543 |
|
) |
10544 |
|
AS |
10545 |
|
BEGIN EXIT; END |
10546 |
|
^ |
10547 |
< |
|
10519 |
< |
CREATE PROCEDURE SUB_TOT_BUDGET |
10547 |
> |
CREATE PROCEDURE SUB_TOT_BUDGET |
10548 |
|
( |
10549 |
|
HEAD_DEPT CHAR(3) CHARACTER SET NONE |
10550 |
|
) |
10558 |
|
AS |
10559 |
|
BEGIN SUSPEND; EXIT; END |
10560 |
|
^ |
10561 |
< |
|
10534 |
< |
CREATE PROCEDURE "UC SPACE" |
10561 |
> |
CREATE PROCEDURE "UC SPACE" |
10562 |
|
( |
10563 |
|
ARG1 INTEGER |
10564 |
|
) |
10565 |
|
AS |
10566 |
|
BEGIN EXIT; END |
10567 |
|
^ |
10568 |
< |
|
10542 |
< |
CREATE PROCEDURE "iCASE" |
10568 |
> |
CREATE PROCEDURE "iCASE" |
10569 |
|
AS |
10570 |
|
BEGIN EXIT; END |
10571 |
|
^ |
10546 |
– |
|
10572 |
|
SET TERM ; ^ |
10573 |
|
COMMIT WORK; |
10574 |
|
SET AUTODDL ON; |
11065 |
|
/* Stored procedure Bodies */ |
11066 |
|
|
11067 |
|
|
11068 |
< |
ALTER PROCEDURE SHOW_LANGS |
11068 |
> |
ALTER PROCEDURE SHOW_LANGS |
11069 |
|
( |
11070 |
|
CODE VARCHAR(5) CHARACTER SET NONE, |
11071 |
|
GRADE SMALLINT, |
11091 |
|
SUSPEND; |
11092 |
|
END |
11093 |
|
END |
11094 |
< |
^ |
11070 |
< |
|
11094 |
> |
^ |
11095 |
|
|
11096 |
< |
ALTER PROCEDURE ADD_EMP_PROJ |
11096 |
> |
ALTER PROCEDURE ADD_EMP_PROJ |
11097 |
|
( |
11098 |
|
EMP_NO SMALLINT, |
11099 |
|
PROJ_ID CHAR(5) CHARACTER SET NONE |
11106 |
|
EXCEPTION unknown_emp_id; |
11107 |
|
END |
11108 |
|
END |
11109 |
< |
^ |
11086 |
< |
|
11109 |
> |
^ |
11110 |
|
|
11111 |
< |
ALTER PROCEDURE ALL_LANGS |
11111 |
> |
ALTER PROCEDURE ALL_LANGS |
11112 |
|
RETURNS |
11113 |
|
( |
11114 |
|
CODE VARCHAR(5) CHARACTER SET NONE, |
11134 |
|
SUSPEND; |
11135 |
|
END |
11136 |
|
END |
11137 |
< |
^ |
11115 |
< |
|
11137 |
> |
^ |
11138 |
|
|
11139 |
< |
ALTER PROCEDURE DELETE_EMPLOYEE |
11139 |
> |
ALTER PROCEDURE DELETE_EMPLOYEE |
11140 |
|
( |
11141 |
|
EMP_NUM INTEGER |
11142 |
|
) |
11147 |
|
|
11148 |
|
/* |
11149 |
|
* If there are any sales records referencing this employee, |
11150 |
< |
* can't delete the employee until the sales are re-assigned |
11150 |
> |
* cannot delete the employee until the sales are re-assigned |
11151 |
|
* to another employee or changed to NULL. |
11152 |
|
*/ |
11153 |
|
SELECT count(po_number) |
11193 |
|
WHERE emp_no = :emp_num; |
11194 |
|
|
11195 |
|
END |
11196 |
< |
^ |
11175 |
< |
|
11196 |
> |
^ |
11197 |
|
|
11198 |
< |
ALTER PROCEDURE DEPT_BUDGET |
11198 |
> |
ALTER PROCEDURE DEPT_BUDGET |
11199 |
|
( |
11200 |
|
DNO CHAR(3) CHARACTER SET NONE |
11201 |
|
) |
11229 |
|
|
11230 |
|
SUSPEND; |
11231 |
|
END |
11232 |
< |
^ |
11232 |
> |
^ |
11233 |
|
|
11234 |
+ |
ALTER PROCEDURE EMPLOYEE_PAY_STATUS |
11235 |
+ |
( |
11236 |
+ |
EMP_NUM SMALLINT |
11237 |
+ |
) |
11238 |
+ |
RETURNS |
11239 |
+ |
( |
11240 |
+ |
PAY_STATUS VARCHAR(6) CHARACTER SET NONE, |
11241 |
+ |
SALARY NUMERIC(10, 2) |
11242 |
+ |
) |
11243 |
+ |
AS |
11244 |
+ |
BEGIN |
11245 |
+ |
Select SALARY, Case |
11246 |
+ |
When SALARY > 10000 and SALARY <= 100000 then 'higher' |
11247 |
+ |
When SALARY > 100000 then 'gross' |
11248 |
+ |
else 'lower' End |
11249 |
+ |
From employee |
11250 |
+ |
WHERE emp_no = :EMP_NUM |
11251 |
+ |
into :SALARY, :PAY_STATUS; |
11252 |
+ |
END |
11253 |
+ |
^ |
11254 |
|
|
11255 |
< |
ALTER PROCEDURE GET_EMP_PROJ |
11255 |
> |
ALTER PROCEDURE GET_EMP_PROJ |
11256 |
|
( |
11257 |
|
EMP_NO SMALLINT |
11258 |
|
) |
11269 |
|
DO |
11270 |
|
SUSPEND; |
11271 |
|
END |
11272 |
< |
^ |
11232 |
< |
|
11272 |
> |
^ |
11273 |
|
|
11274 |
< |
ALTER PROCEDURE "Has Space" |
11274 |
> |
ALTER PROCEDURE "Has Space" |
11275 |
|
( |
11276 |
|
ARG1 INTEGER |
11277 |
|
) |
11278 |
|
AS |
11279 |
|
Begin End |
11280 |
< |
^ |
11241 |
< |
|
11280 |
> |
^ |
11281 |
|
|
11282 |
< |
ALTER PROCEDURE MAIL_LABEL |
11282 |
> |
ALTER PROCEDURE MAIL_LABEL |
11283 |
|
( |
11284 |
|
CUST_NO INTEGER |
11285 |
|
) |
11347 |
|
|
11348 |
|
SUSPEND; |
11349 |
|
END |
11350 |
< |
^ |
11312 |
< |
|
11350 |
> |
^ |
11351 |
|
|
11352 |
< |
ALTER PROCEDURE ORG_CHART |
11352 |
> |
ALTER PROCEDURE ORG_CHART |
11353 |
|
RETURNS |
11354 |
|
( |
11355 |
|
HEAD_DEPT CHAR(25) CHARACTER SET NONE, |
11389 |
|
SUSPEND; |
11390 |
|
END |
11391 |
|
END |
11392 |
< |
^ |
11355 |
< |
|
11392 |
> |
^ |
11393 |
|
|
11394 |
< |
ALTER PROCEDURE SHIP_ORDER |
11394 |
> |
ALTER PROCEDURE SHIP_ORDER |
11395 |
|
( |
11396 |
|
PO_NUM CHAR(8) CHARACTER SET NONE |
11397 |
|
) |
11448 |
|
WHERE po_number = :po_num; |
11449 |
|
|
11450 |
|
END |
11451 |
< |
^ |
11415 |
< |
|
11451 |
> |
^ |
11452 |
|
|
11453 |
< |
ALTER PROCEDURE SUB_TOT_BUDGET |
11453 |
> |
ALTER PROCEDURE SUB_TOT_BUDGET |
11454 |
|
( |
11455 |
|
HEAD_DEPT CHAR(3) CHARACTER SET NONE |
11456 |
|
) |
11469 |
|
INTO :tot_budget, :avg_budget, :min_budget, :max_budget; |
11470 |
|
SUSPEND; |
11471 |
|
END |
11472 |
< |
^ |
11437 |
< |
|
11472 |
> |
^ |
11473 |
|
|
11474 |
< |
ALTER PROCEDURE "UC SPACE" |
11474 |
> |
ALTER PROCEDURE "UC SPACE" |
11475 |
|
( |
11476 |
|
ARG1 INTEGER |
11477 |
|
) |
11478 |
|
AS |
11479 |
|
Begin End |
11480 |
< |
^ |
11446 |
< |
|
11480 |
> |
^ |
11481 |
|
|
11482 |
< |
ALTER PROCEDURE "iCASE" |
11482 |
> |
ALTER PROCEDURE "iCASE" |
11483 |
|
AS |
11484 |
|
Begin End |
11485 |
< |
^ |
11452 |
< |
|
11485 |
> |
^ |
11486 |
|
SET TERM ; ^ |
11487 |
|
COMMIT WORK; |
11488 |
|
SET AUTODDL ON; |
11589 |
|
< |
11590 |
|
236d224 |
11591 |
|
< |
11592 |
< |
1122c1110 |
11592 |
> |
990c978 |
11593 |
> |
< DEPT_KEY_PATH, |
11594 |
> |
--- |
11595 |
> |
> DEPT_KEY_PATH, |
11596 |
> |
1124c1112 |
11597 |
|
< CREATE PACKAGE FB$OUT |
11598 |
|
--- |
11599 |
|
> CREATE PACKAGE FB$OUT |
11600 |
|
1136c1124 |
11601 |
+ |
< ^ |
11602 |
+ |
--- |
11603 |
+ |
> ^ |
11604 |
+ |
1138c1126 |
11605 |
|
< CREATE PACKAGE SELECT$TEST |
11606 |
|
--- |
11607 |
|
> CREATE PACKAGE SELECT$TEST |
11608 |
< |
1165d1152 |
11608 |
> |
1144c1132 |
11609 |
> |
< ^ |
11610 |
> |
--- |
11611 |
> |
> ^ |
11612 |
> |
1146c1134 |
11613 |
> |
< SET TERM ;^ |
11614 |
> |
--- |
11615 |
> |
> SET TERM ; ^ |
11616 |
> |
1155c1143 |
11617 |
> |
< CREATE PROCEDURE SHOW_LANGS |
11618 |
> |
--- |
11619 |
> |
> CREATE PROCEDURE SHOW_LANGS |
11620 |
> |
1167d1154 |
11621 |
|
< |
11622 |
< |
1175d1161 |
11622 |
> |
1169,1170c1156 |
11623 |
|
< |
11624 |
< |
1188d1173 |
11624 |
> |
< CREATE PROCEDURE ADD_EMP_PROJ |
11625 |
> |
--- |
11626 |
> |
> CREATE PROCEDURE ADD_EMP_PROJ |
11627 |
> |
1177d1162 |
11628 |
> |
< |
11629 |
> |
1179,1180c1164 |
11630 |
> |
< |
11631 |
> |
< CREATE PROCEDURE ALL_LANGS |
11632 |
> |
--- |
11633 |
> |
> CREATE PROCEDURE ALL_LANGS |
11634 |
> |
1190d1173 |
11635 |
> |
< |
11636 |
> |
1192,1193c1175 |
11637 |
|
< |
11638 |
< |
1197d1181 |
11638 |
> |
< CREATE PROCEDURE DELETE_EMPLOYEE |
11639 |
> |
--- |
11640 |
> |
> CREATE PROCEDURE DELETE_EMPLOYEE |
11641 |
> |
1199d1180 |
11642 |
|
< |
11643 |
< |
1210d1193 |
11643 |
> |
1201,1202c1182 |
11644 |
|
< |
11645 |
< |
1223d1205 |
11645 |
> |
< CREATE PROCEDURE DEPT_BUDGET |
11646 |
> |
--- |
11647 |
> |
> CREATE PROCEDURE DEPT_BUDGET |
11648 |
> |
1212d1191 |
11649 |
|
< |
11650 |
< |
1232d1213 |
11650 |
> |
1214d1192 |
11651 |
|
< |
11652 |
< |
1250d1230 |
11652 |
> |
1217c1195 |
11653 |
> |
< EMP_NO SMALLINT |
11654 |
> |
--- |
11655 |
> |
> EMP_NUM SMALLINT |
11656 |
> |
1221c1199,1200 |
11657 |
> |
< PAY_STATUS VARCHAR(6) CHARACTER SET NONE |
11658 |
> |
--- |
11659 |
> |
> PAY_STATUS VARCHAR(6) CHARACTER SET NONE, |
11660 |
> |
> SALARY NUMERIC(10, 2) |
11661 |
> |
1225d1203 |
11662 |
|
< |
11663 |
< |
1264d1243 |
11663 |
> |
1227,1229c1205 |
11664 |
|
< |
11585 |
– |
1273d1251 |
11665 |
|
< |
11666 |
< |
1289d1266 |
11666 |
> |
< CREATE PROCEDURE GET_EMP_PROJ |
11667 |
> |
--- |
11668 |
> |
> CREATE PROCEDURE GET_EMP_PROJ |
11669 |
> |
1239d1214 |
11670 |
|
< |
11671 |
< |
1298d1274 |
11671 |
> |
1241,1242c1216 |
11672 |
> |
< |
11673 |
> |
< CREATE PROCEDURE "Has Space" |
11674 |
> |
--- |
11675 |
> |
> CREATE PROCEDURE "Has Space" |
11676 |
> |
1248d1221 |
11677 |
> |
< |
11678 |
> |
1250,1251c1223 |
11679 |
> |
< |
11680 |
> |
< CREATE PROCEDURE MAIL_LABEL |
11681 |
> |
--- |
11682 |
> |
> CREATE PROCEDURE MAIL_LABEL |
11683 |
> |
1266d1237 |
11684 |
> |
< |
11685 |
> |
1268,1269c1239 |
11686 |
> |
< |
11687 |
> |
< CREATE PROCEDURE ORG_CHART |
11688 |
> |
--- |
11689 |
> |
> CREATE PROCEDURE ORG_CHART |
11690 |
> |
1280d1249 |
11691 |
> |
< |
11692 |
> |
1282,1283c1251 |
11693 |
> |
< |
11694 |
> |
< CREATE PROCEDURE SHIP_ORDER |
11695 |
> |
--- |
11696 |
> |
> CREATE PROCEDURE SHIP_ORDER |
11697 |
> |
1289d1256 |
11698 |
> |
< |
11699 |
> |
1291,1292c1258 |
11700 |
> |
< |
11701 |
> |
< CREATE PROCEDURE SUB_TOT_BUDGET |
11702 |
> |
--- |
11703 |
> |
> CREATE PROCEDURE SUB_TOT_BUDGET |
11704 |
> |
1305d1270 |
11705 |
> |
< |
11706 |
> |
1307,1308c1272 |
11707 |
> |
< |
11708 |
> |
< CREATE PROCEDURE "UC SPACE" |
11709 |
> |
--- |
11710 |
> |
> CREATE PROCEDURE "UC SPACE" |
11711 |
> |
1314d1277 |
11712 |
> |
< |
11713 |
> |
1316,1317c1279 |
11714 |
> |
< |
11715 |
> |
< CREATE PROCEDURE "iCASE" |
11716 |
> |
--- |
11717 |
> |
> CREATE PROCEDURE "iCASE" |
11718 |
> |
1320d1281 |
11719 |
|
< |
11720 |
< |
1304d1279 |
11720 |
> |
1322,1323c1283 |
11721 |
|
< |
11722 |
< |
1319d1293 |
11722 |
> |
< SET TERM ;^ |
11723 |
> |
--- |
11724 |
> |
> SET TERM ; ^ |
11725 |
> |
1335d1294 |
11726 |
|
< |
11727 |
< |
1723c1697 |
11727 |
> |
1339c1298 |
11728 |
> |
< SET TERM ;^ |
11729 |
> |
--- |
11730 |
> |
> SET TERM ; ^ |
11731 |
> |
1352c1311 |
11732 |
> |
< ^ |
11733 |
> |
--- |
11734 |
> |
> ^ |
11735 |
> |
1356c1315 |
11736 |
> |
< ^ |
11737 |
> |
--- |
11738 |
> |
> ^ |
11739 |
> |
1360c1319 |
11740 |
> |
< ^ |
11741 |
> |
--- |
11742 |
> |
> ^ |
11743 |
> |
1364c1323 |
11744 |
> |
< ^ |
11745 |
> |
--- |
11746 |
> |
> ^ |
11747 |
> |
1368c1327 |
11748 |
> |
< ^ |
11749 |
> |
--- |
11750 |
> |
> ^ |
11751 |
> |
1372c1331 |
11752 |
> |
< ^ |
11753 |
> |
--- |
11754 |
> |
> ^ |
11755 |
> |
1376c1335 |
11756 |
> |
< ^ |
11757 |
> |
--- |
11758 |
> |
> ^ |
11759 |
> |
1380c1339 |
11760 |
> |
< ^ |
11761 |
> |
--- |
11762 |
> |
> ^ |
11763 |
> |
1384c1343 |
11764 |
> |
< ^ |
11765 |
> |
--- |
11766 |
> |
> ^ |
11767 |
> |
1388c1347 |
11768 |
> |
< ^ |
11769 |
> |
--- |
11770 |
> |
> ^ |
11771 |
> |
1392c1351 |
11772 |
> |
< ^ |
11773 |
> |
--- |
11774 |
> |
> ^ |
11775 |
> |
1396c1355 |
11776 |
> |
< ^ |
11777 |
> |
--- |
11778 |
> |
> ^ |
11779 |
> |
1400c1359 |
11780 |
> |
< ^ |
11781 |
> |
--- |
11782 |
> |
> ^ |
11783 |
> |
1404c1363 |
11784 |
> |
< ^ |
11785 |
> |
--- |
11786 |
> |
> ^ |
11787 |
> |
1408c1367 |
11788 |
> |
< ^ |
11789 |
> |
--- |
11790 |
> |
> ^ |
11791 |
> |
1412c1371 |
11792 |
> |
< ^ |
11793 |
> |
--- |
11794 |
> |
> ^ |
11795 |
> |
1416c1375 |
11796 |
> |
< ^ |
11797 |
> |
--- |
11798 |
> |
> ^ |
11799 |
> |
1420c1379 |
11800 |
> |
< ^ |
11801 |
> |
--- |
11802 |
> |
> ^ |
11803 |
> |
1424c1383 |
11804 |
> |
< ^ |
11805 |
> |
--- |
11806 |
> |
> ^ |
11807 |
> |
1428c1387 |
11808 |
> |
< ^ |
11809 |
> |
--- |
11810 |
> |
> ^ |
11811 |
> |
1432c1391 |
11812 |
> |
< ^ |
11813 |
> |
--- |
11814 |
> |
> ^ |
11815 |
> |
1436c1395 |
11816 |
> |
< ^ |
11817 |
> |
--- |
11818 |
> |
> ^ |
11819 |
> |
1440c1399 |
11820 |
> |
< ^ |
11821 |
> |
--- |
11822 |
> |
> ^ |
11823 |
> |
1444c1403 |
11824 |
> |
< ^ |
11825 |
> |
--- |
11826 |
> |
> ^ |
11827 |
> |
1448c1407 |
11828 |
> |
< ^ |
11829 |
> |
--- |
11830 |
> |
> ^ |
11831 |
> |
1452c1411 |
11832 |
> |
< ^ |
11833 |
> |
--- |
11834 |
> |
> ^ |
11835 |
> |
1456c1415 |
11836 |
> |
< ^ |
11837 |
> |
--- |
11838 |
> |
> ^ |
11839 |
> |
1460c1419 |
11840 |
> |
< ^ |
11841 |
> |
--- |
11842 |
> |
> ^ |
11843 |
> |
1464c1423 |
11844 |
> |
< ^ |
11845 |
> |
--- |
11846 |
> |
> ^ |
11847 |
> |
1468c1427 |
11848 |
> |
< ^ |
11849 |
> |
--- |
11850 |
> |
> ^ |
11851 |
> |
1472c1431 |
11852 |
> |
< ^ |
11853 |
> |
--- |
11854 |
> |
> ^ |
11855 |
> |
1476c1435 |
11856 |
> |
< ^ |
11857 |
> |
--- |
11858 |
> |
> ^ |
11859 |
> |
1480c1439 |
11860 |
> |
< ^ |
11861 |
> |
--- |
11862 |
> |
> ^ |
11863 |
> |
1484c1443 |
11864 |
> |
< ^ |
11865 |
> |
--- |
11866 |
> |
> ^ |
11867 |
> |
1488c1447 |
11868 |
> |
< ^ |
11869 |
> |
--- |
11870 |
> |
> ^ |
11871 |
> |
1492c1451 |
11872 |
> |
< ^ |
11873 |
> |
--- |
11874 |
> |
> ^ |
11875 |
> |
1496c1455 |
11876 |
> |
< ^ |
11877 |
> |
--- |
11878 |
> |
> ^ |
11879 |
> |
1500c1459 |
11880 |
> |
< ^ |
11881 |
> |
--- |
11882 |
> |
> ^ |
11883 |
> |
1504c1463 |
11884 |
> |
< ^ |
11885 |
> |
--- |
11886 |
> |
> ^ |
11887 |
> |
1508c1467 |
11888 |
> |
< ^ |
11889 |
> |
--- |
11890 |
> |
> ^ |
11891 |
> |
1512c1471 |
11892 |
> |
< ^ |
11893 |
> |
--- |
11894 |
> |
> ^ |
11895 |
> |
1516c1475 |
11896 |
> |
< ^ |
11897 |
> |
--- |
11898 |
> |
> ^ |
11899 |
> |
1520c1479 |
11900 |
> |
< ^ |
11901 |
> |
--- |
11902 |
> |
> ^ |
11903 |
> |
1524c1483 |
11904 |
> |
< ^ |
11905 |
> |
--- |
11906 |
> |
> ^ |
11907 |
> |
1528c1487 |
11908 |
> |
< ^ |
11909 |
> |
--- |
11910 |
> |
> ^ |
11911 |
> |
1532c1491 |
11912 |
> |
< ^ |
11913 |
> |
--- |
11914 |
> |
> ^ |
11915 |
> |
1536c1495 |
11916 |
> |
< ^ |
11917 |
> |
--- |
11918 |
> |
> ^ |
11919 |
> |
1540c1499 |
11920 |
> |
< ^ |
11921 |
> |
--- |
11922 |
> |
> ^ |
11923 |
> |
1544c1503 |
11924 |
> |
< ^ |
11925 |
> |
--- |
11926 |
> |
> ^ |
11927 |
> |
1548c1507 |
11928 |
> |
< ^ |
11929 |
> |
--- |
11930 |
> |
> ^ |
11931 |
> |
1552c1511 |
11932 |
> |
< ^ |
11933 |
> |
--- |
11934 |
> |
> ^ |
11935 |
> |
1556c1515 |
11936 |
> |
< ^ |
11937 |
> |
--- |
11938 |
> |
> ^ |
11939 |
> |
1560c1519 |
11940 |
> |
< ^ |
11941 |
> |
--- |
11942 |
> |
> ^ |
11943 |
> |
1564c1523 |
11944 |
> |
< ^ |
11945 |
> |
--- |
11946 |
> |
> ^ |
11947 |
> |
1568c1527 |
11948 |
> |
< ^ |
11949 |
> |
--- |
11950 |
> |
> ^ |
11951 |
> |
1572c1531 |
11952 |
> |
< ^ |
11953 |
> |
--- |
11954 |
> |
> ^ |
11955 |
> |
1576c1535 |
11956 |
> |
< ^ |
11957 |
> |
--- |
11958 |
> |
> ^ |
11959 |
> |
1580c1539 |
11960 |
> |
< ^ |
11961 |
> |
--- |
11962 |
> |
> ^ |
11963 |
> |
1584c1543 |
11964 |
> |
< ^ |
11965 |
> |
--- |
11966 |
> |
> ^ |
11967 |
> |
1588c1547 |
11968 |
> |
< ^ |
11969 |
> |
--- |
11970 |
> |
> ^ |
11971 |
> |
1592c1551 |
11972 |
> |
< ^ |
11973 |
> |
--- |
11974 |
> |
> ^ |
11975 |
> |
1596c1555 |
11976 |
> |
< ^ |
11977 |
> |
--- |
11978 |
> |
> ^ |
11979 |
> |
1600c1559 |
11980 |
> |
< ^ |
11981 |
> |
--- |
11982 |
> |
> ^ |
11983 |
> |
1604c1563 |
11984 |
> |
< ^ |
11985 |
> |
--- |
11986 |
> |
> ^ |
11987 |
> |
1608c1567 |
11988 |
> |
< ^ |
11989 |
> |
--- |
11990 |
> |
> ^ |
11991 |
> |
1612c1571 |
11992 |
> |
< ^ |
11993 |
> |
--- |
11994 |
> |
> ^ |
11995 |
> |
1616c1575 |
11996 |
> |
< ^ |
11997 |
> |
--- |
11998 |
> |
> ^ |
11999 |
> |
1620c1579 |
12000 |
> |
< ^ |
12001 |
> |
--- |
12002 |
> |
> ^ |
12003 |
> |
1624c1583 |
12004 |
> |
< ^ |
12005 |
> |
--- |
12006 |
> |
> ^ |
12007 |
> |
1628c1587 |
12008 |
> |
< ^ |
12009 |
> |
--- |
12010 |
> |
> ^ |
12011 |
> |
1632c1591 |
12012 |
> |
< ^ |
12013 |
> |
--- |
12014 |
> |
> ^ |
12015 |
> |
1636c1595 |
12016 |
> |
< ^ |
12017 |
> |
--- |
12018 |
> |
> ^ |
12019 |
> |
1640c1599 |
12020 |
> |
< ^ |
12021 |
> |
--- |
12022 |
> |
> ^ |
12023 |
> |
1644c1603 |
12024 |
> |
< ^ |
12025 |
> |
--- |
12026 |
> |
> ^ |
12027 |
> |
1648c1607 |
12028 |
> |
< ^ |
12029 |
> |
--- |
12030 |
> |
> ^ |
12031 |
> |
1652c1611 |
12032 |
> |
< ^ |
12033 |
> |
--- |
12034 |
> |
> ^ |
12035 |
> |
1656c1615 |
12036 |
> |
< ^ |
12037 |
> |
--- |
12038 |
> |
> ^ |
12039 |
> |
1660c1619 |
12040 |
> |
< ^ |
12041 |
> |
--- |
12042 |
> |
> ^ |
12043 |
> |
1664c1623 |
12044 |
> |
< ^ |
12045 |
> |
--- |
12046 |
> |
> ^ |
12047 |
> |
1668c1627 |
12048 |
> |
< ^ |
12049 |
> |
--- |
12050 |
> |
> ^ |
12051 |
> |
1672c1631 |
12052 |
> |
< ^ |
12053 |
> |
--- |
12054 |
> |
> ^ |
12055 |
> |
1676c1635 |
12056 |
> |
< ^ |
12057 |
> |
--- |
12058 |
> |
> ^ |
12059 |
> |
1680c1639 |
12060 |
> |
< ^ |
12061 |
> |
--- |
12062 |
> |
> ^ |
12063 |
> |
1684c1643 |
12064 |
> |
< ^ |
12065 |
> |
--- |
12066 |
> |
> ^ |
12067 |
> |
1688c1647 |
12068 |
> |
< ^ |
12069 |
> |
--- |
12070 |
> |
> ^ |
12071 |
> |
1692c1651 |
12072 |
> |
< ^ |
12073 |
> |
--- |
12074 |
> |
> ^ |
12075 |
> |
1700c1659 |
12076 |
> |
< ^ |
12077 |
> |
--- |
12078 |
> |
> ^ |
12079 |
> |
1708c1667 |
12080 |
> |
< ^ |
12081 |
> |
--- |
12082 |
> |
> ^ |
12083 |
> |
1723c1682 |
12084 |
> |
< ^ |
12085 |
> |
--- |
12086 |
> |
> ^ |
12087 |
> |
1730,1731c1689,1690 |
12088 |
> |
< ^ |
12089 |
> |
< COMMIT WORK^ |
12090 |
> |
--- |
12091 |
> |
> ^ |
12092 |
> |
> COMMIT WORK ^ |
12093 |
> |
1739c1698 |
12094 |
|
< CREATE PACKAGE BODY FB$OUT |
12095 |
|
--- |
12096 |
|
> CREATE PACKAGE BODY FB$OUT |
12097 |
< |
1782c1756 |
12097 |
> |
1796c1755 |
12098 |
> |
< ^ |
12099 |
> |
--- |
12100 |
> |
> ^ |
12101 |
> |
1798c1757 |
12102 |
|
< CREATE PACKAGE BODY SELECT$TEST |
12103 |
|
--- |
12104 |
|
> CREATE PACKAGE BODY SELECT$TEST |
12105 |
< |
2242,2245d2215 |
12105 |
> |
1808c1767 |
12106 |
> |
< ^ |
12107 |
> |
--- |
12108 |
> |
> ^ |
12109 |
> |
1810c1769 |
12110 |
> |
< SET TERM ;^ |
12111 |
> |
--- |
12112 |
> |
> SET TERM ; ^ |
12113 |
> |
1820c1779 |
12114 |
> |
< ALTER PROCEDURE SHOW_LANGS |
12115 |
> |
--- |
12116 |
> |
> ALTER PROCEDURE SHOW_LANGS |
12117 |
> |
1848,1849c1807 |
12118 |
> |
< |
12119 |
> |
< ALTER PROCEDURE ADD_EMP_PROJ |
12120 |
> |
--- |
12121 |
> |
> ALTER PROCEDURE ADD_EMP_PROJ |
12122 |
> |
1864c1822 |
12123 |
> |
< ALTER PROCEDURE ALL_LANGS |
12124 |
> |
--- |
12125 |
> |
> ALTER PROCEDURE ALL_LANGS |
12126 |
> |
1892,1893c1850 |
12127 |
> |
< |
12128 |
> |
< ALTER PROCEDURE DELETE_EMPLOYEE |
12129 |
> |
--- |
12130 |
> |
> ALTER PROCEDURE DELETE_EMPLOYEE |
12131 |
> |
1952,1953c1909 |
12132 |
> |
< |
12133 |
> |
< ALTER PROCEDURE DEPT_BUDGET |
12134 |
> |
--- |
12135 |
> |
> ALTER PROCEDURE DEPT_BUDGET |
12136 |
> |
1996c1952 |
12137 |
> |
< SALARY NUMERIC(10,2) |
12138 |
> |
--- |
12139 |
> |
> SALARY NUMERIC(10, 2) |
12140 |
> |
2010c1966 |
12141 |
> |
< ALTER PROCEDURE GET_EMP_PROJ |
12142 |
> |
--- |
12143 |
> |
> ALTER PROCEDURE GET_EMP_PROJ |
12144 |
> |
2029,2030c1985 |
12145 |
> |
< |
12146 |
> |
< ALTER PROCEDURE "Has Space" |
12147 |
> |
--- |
12148 |
> |
> ALTER PROCEDURE "Has Space" |
12149 |
> |
2038,2039c1993 |
12150 |
> |
< |
12151 |
> |
< ALTER PROCEDURE MAIL_LABEL |
12152 |
> |
--- |
12153 |
> |
> ALTER PROCEDURE MAIL_LABEL |
12154 |
> |
2109,2110c2063 |
12155 |
> |
< |
12156 |
> |
< ALTER PROCEDURE ORG_CHART |
12157 |
> |
--- |
12158 |
> |
> ALTER PROCEDURE ORG_CHART |
12159 |
> |
2152,2153c2105 |
12160 |
> |
< |
12161 |
> |
< ALTER PROCEDURE SHIP_ORDER |
12162 |
> |
--- |
12163 |
> |
> ALTER PROCEDURE SHIP_ORDER |
12164 |
> |
2212,2213c2164 |
12165 |
> |
< |
12166 |
> |
< ALTER PROCEDURE SUB_TOT_BUDGET |
12167 |
> |
--- |
12168 |
> |
> ALTER PROCEDURE SUB_TOT_BUDGET |
12169 |
> |
2234,2235c2185 |
12170 |
> |
< |
12171 |
> |
< ALTER PROCEDURE "UC SPACE" |
12172 |
> |
--- |
12173 |
> |
> ALTER PROCEDURE "UC SPACE" |
12174 |
> |
2243,2244c2193 |
12175 |
> |
< |
12176 |
> |
< ALTER PROCEDURE "iCASE" |
12177 |
> |
--- |
12178 |
> |
> ALTER PROCEDURE "iCASE" |
12179 |
> |
2248,2249c2197 |
12180 |
> |
< |
12181 |
> |
< SET TERM ;^ |
12182 |
> |
--- |
12183 |
> |
> SET TERM ; ^ |
12184 |
> |
2267c2215 |
12185 |
> |
< SET TERM ;^ |
12186 |
> |
--- |
12187 |
> |
> SET TERM ; ^ |
12188 |
> |
2277,2280d2224 |
12189 |
|
< |
12190 |
|
< /* Role: TESTROLE, Owner: SYSDBA */ |
12191 |
|
< |
12244 |
|
Database Statistics for employee |
12245 |
|
|
12246 |
|
Database "/opt/firebird3.0.5/examples/empbuild/employee.fdb" |
12247 |
< |
Gstat execution time Mon Feb 22 10:35:32 2021 |
12247 |
> |
Gstat execution time Wed Oct 6 09:54:45 2021 |
12248 |
|
|
12249 |
|
Database header page information: |
12250 |
|
Flags 0 |
12251 |
< |
Generation 2198 |
12251 |
> |
Generation 3338 |
12252 |
|
System Change Number 0 |
12253 |
|
Page size 8192 |
12254 |
|
ODS version 12.0 |
12255 |
< |
Oldest transaction 2485 |
12256 |
< |
Oldest active 2486 |
12257 |
< |
Oldest snapshot 2486 |
12258 |
< |
Next transaction 2486 |
12255 |
> |
Oldest transaction 3763 |
12256 |
> |
Oldest active 3764 |
12257 |
> |
Oldest snapshot 3764 |
12258 |
> |
Next transaction 3764 |
12259 |
|
Sequence number 0 |
12260 |
< |
Next attachment ID 2248 |
12260 |
> |
Next attachment ID 3517 |
12261 |
|
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc |
12262 |
|
Shadow count 0 |
12263 |
|
Page buffers 0 |
12404 |
|
60 - 79% = 0 |
12405 |
|
80 - 99% = 0 |
12406 |
|
|
12407 |
< |
Gstat completion time Mon Feb 22 10:35:32 2021 |
12407 |
> |
Gstat completion time Wed Oct 6 09:54:45 2021 |
12408 |
|
|
12409 |
|
|
12410 |
|
|
12414 |
|
bin/fbguard: guardian starting /opt/firebird3.0.5/bin/firebird |
12415 |
|
|
12416 |
|
Online Validation |
12417 |
< |
10:35:32.67 Validation started |
12417 |
> |
09:54:46.38 Validation started |
12418 |
|
|
12419 |
< |
10:35:32.67 Relation 128 (COUNTRY) |
12420 |
< |
10:35:32.67 process pointer page 0 of 1 |
12421 |
< |
10:35:32.67 Index 1 (RDB$PRIMARY1) |
12422 |
< |
10:35:32.67 Relation 128 (COUNTRY) is ok |
12423 |
< |
|
12424 |
< |
10:35:32.67 Relation 129 (JOB) |
12425 |
< |
10:35:32.67 process pointer page 0 of 1 |
12426 |
< |
10:35:32.67 Index 1 (RDB$PRIMARY2) |
12427 |
< |
10:35:32.67 Index 2 (RDB$FOREIGN3) |
12428 |
< |
10:35:32.67 Index 3 (MAXSALX) |
12429 |
< |
10:35:32.67 Index 4 (MINSALX) |
12430 |
< |
10:35:32.67 Relation 129 (JOB) is ok |
12431 |
< |
|
12432 |
< |
10:35:32.67 Relation 130 (DEPARTMENT) |
12433 |
< |
10:35:32.67 process pointer page 0 of 1 |
12434 |
< |
10:35:32.67 Index 1 (RDB$4) |
12435 |
< |
10:35:32.67 Index 2 (RDB$PRIMARY5) |
12436 |
< |
10:35:32.67 Index 3 (RDB$FOREIGN6) |
12437 |
< |
10:35:32.67 Index 4 (BUDGETX) |
12438 |
< |
10:35:32.67 Index 5 (RDB$FOREIGN10) |
12439 |
< |
10:35:32.67 Relation 130 (DEPARTMENT) is ok |
12440 |
< |
|
12441 |
< |
10:35:32.67 Relation 131 (EMPLOYEE) |
12442 |
< |
10:35:32.67 process pointer page 0 of 1 |
12443 |
< |
10:35:32.67 Index 1 (RDB$PRIMARY7) |
12444 |
< |
10:35:32.67 Index 2 (RDB$FOREIGN8) |
12445 |
< |
10:35:32.67 Index 3 (RDB$FOREIGN9) |
12446 |
< |
10:35:32.67 Index 4 (NAMEX) |
12447 |
< |
10:35:32.67 Relation 131 (EMPLOYEE) is ok |
12448 |
< |
|
12449 |
< |
10:35:32.67 Relation 133 (PROJECT) |
12450 |
< |
10:35:32.67 process pointer page 0 of 1 |
12451 |
< |
10:35:32.67 Index 1 (RDB$11) |
12452 |
< |
10:35:32.67 Index 2 (RDB$PRIMARY12) |
12453 |
< |
10:35:32.67 Index 3 (RDB$FOREIGN13) |
12454 |
< |
10:35:32.67 Index 4 (PRODTYPEX) |
12455 |
< |
10:35:32.67 Relation 133 (PROJECT) is ok |
12456 |
< |
|
12457 |
< |
10:35:32.67 Relation 134 (EMPLOYEE_PROJECT) |
12458 |
< |
10:35:32.67 process pointer page 0 of 1 |
12459 |
< |
10:35:32.67 Index 1 (RDB$PRIMARY14) |
12460 |
< |
10:35:32.67 Index 2 (RDB$FOREIGN15) |
12461 |
< |
10:35:32.67 Index 3 (RDB$FOREIGN16) |
12462 |
< |
10:35:32.67 Relation 134 (EMPLOYEE_PROJECT) is ok |
12463 |
< |
|
12464 |
< |
10:35:32.67 Relation 135 (PROJ_DEPT_BUDGET) |
12465 |
< |
10:35:32.67 process pointer page 0 of 1 |
12466 |
< |
10:35:32.68 Index 1 (RDB$PRIMARY17) |
12467 |
< |
10:35:32.68 Index 2 (RDB$FOREIGN18) |
12468 |
< |
10:35:32.68 Index 3 (RDB$FOREIGN19) |
12469 |
< |
10:35:32.68 Relation 135 (PROJ_DEPT_BUDGET) is ok |
12470 |
< |
|
12471 |
< |
10:35:32.68 Relation 136 (SALARY_HISTORY) |
12472 |
< |
10:35:32.68 process pointer page 0 of 1 |
12473 |
< |
10:35:32.68 Index 1 (RDB$PRIMARY20) |
12474 |
< |
10:35:32.68 Index 2 (RDB$FOREIGN21) |
12475 |
< |
10:35:32.68 Index 3 (CHANGEX) |
12476 |
< |
10:35:32.68 Index 4 (UPDATERX) |
12477 |
< |
10:35:32.68 Relation 136 (SALARY_HISTORY) is ok |
12478 |
< |
|
12479 |
< |
10:35:32.68 Relation 137 (CUSTOMER) |
12480 |
< |
10:35:32.68 process pointer page 0 of 1 |
12481 |
< |
10:35:32.68 Index 1 (RDB$PRIMARY22) |
12482 |
< |
10:35:32.68 Index 2 (RDB$FOREIGN23) |
12483 |
< |
10:35:32.68 Index 3 (CUSTNAMEX) |
12484 |
< |
10:35:32.68 Index 4 (CUSTREGION) |
12485 |
< |
10:35:32.68 Relation 137 (CUSTOMER) is ok |
12486 |
< |
|
12487 |
< |
10:35:32.68 Relation 138 (SALES) |
12488 |
< |
10:35:32.68 process pointer page 0 of 1 |
12489 |
< |
10:35:32.68 Index 1 (RDB$PRIMARY24) |
12490 |
< |
10:35:32.68 Index 2 (RDB$FOREIGN25) |
12491 |
< |
10:35:32.68 Index 3 (RDB$FOREIGN26) |
12492 |
< |
10:35:32.68 Index 4 (NEEDX) |
12493 |
< |
10:35:32.68 Index 5 (QTYX) |
12494 |
< |
10:35:32.68 Index 6 (SALESTATX) |
12495 |
< |
10:35:32.68 Relation 138 (SALES) is ok |
12419 |
> |
09:54:46.39 Relation 128 (COUNTRY) |
12420 |
> |
09:54:46.39 process pointer page 0 of 1 |
12421 |
> |
09:54:46.39 Index 1 (RDB$PRIMARY1) |
12422 |
> |
09:54:46.39 Relation 128 (COUNTRY) is ok |
12423 |
> |
|
12424 |
> |
09:54:46.39 Relation 129 (JOB) |
12425 |
> |
09:54:46.39 process pointer page 0 of 1 |
12426 |
> |
09:54:46.39 Index 1 (RDB$PRIMARY2) |
12427 |
> |
09:54:46.39 Index 2 (RDB$FOREIGN3) |
12428 |
> |
09:54:46.39 Index 3 (MAXSALX) |
12429 |
> |
09:54:46.39 Index 4 (MINSALX) |
12430 |
> |
09:54:46.39 Relation 129 (JOB) is ok |
12431 |
> |
|
12432 |
> |
09:54:46.39 Relation 130 (DEPARTMENT) |
12433 |
> |
09:54:46.39 process pointer page 0 of 1 |
12434 |
> |
09:54:46.39 Index 1 (RDB$4) |
12435 |
> |
09:54:46.40 Index 2 (RDB$PRIMARY5) |
12436 |
> |
09:54:46.40 Index 3 (RDB$FOREIGN6) |
12437 |
> |
09:54:46.40 Index 4 (BUDGETX) |
12438 |
> |
09:54:46.40 Index 5 (RDB$FOREIGN10) |
12439 |
> |
09:54:46.40 Relation 130 (DEPARTMENT) is ok |
12440 |
> |
|
12441 |
> |
09:54:46.40 Relation 131 (EMPLOYEE) |
12442 |
> |
09:54:46.40 process pointer page 0 of 1 |
12443 |
> |
09:54:46.40 Index 1 (RDB$PRIMARY7) |
12444 |
> |
09:54:46.40 Index 2 (RDB$FOREIGN8) |
12445 |
> |
09:54:46.40 Index 3 (RDB$FOREIGN9) |
12446 |
> |
09:54:46.40 Index 4 (NAMEX) |
12447 |
> |
09:54:46.40 Relation 131 (EMPLOYEE) is ok |
12448 |
> |
|
12449 |
> |
09:54:46.40 Relation 133 (PROJECT) |
12450 |
> |
09:54:46.40 process pointer page 0 of 1 |
12451 |
> |
09:54:46.40 Index 1 (RDB$11) |
12452 |
> |
09:54:46.40 Index 2 (RDB$PRIMARY12) |
12453 |
> |
09:54:46.40 Index 3 (RDB$FOREIGN13) |
12454 |
> |
09:54:46.40 Index 4 (PRODTYPEX) |
12455 |
> |
09:54:46.40 Relation 133 (PROJECT) is ok |
12456 |
> |
|
12457 |
> |
09:54:46.40 Relation 134 (EMPLOYEE_PROJECT) |
12458 |
> |
09:54:46.40 process pointer page 0 of 1 |
12459 |
> |
09:54:46.40 Index 1 (RDB$PRIMARY14) |
12460 |
> |
09:54:46.40 Index 2 (RDB$FOREIGN15) |
12461 |
> |
09:54:46.40 Index 3 (RDB$FOREIGN16) |
12462 |
> |
09:54:46.40 Relation 134 (EMPLOYEE_PROJECT) is ok |
12463 |
> |
|
12464 |
> |
09:54:46.40 Relation 135 (PROJ_DEPT_BUDGET) |
12465 |
> |
09:54:46.40 process pointer page 0 of 1 |
12466 |
> |
09:54:46.40 Index 1 (RDB$PRIMARY17) |
12467 |
> |
09:54:46.40 Index 2 (RDB$FOREIGN18) |
12468 |
> |
09:54:46.40 Index 3 (RDB$FOREIGN19) |
12469 |
> |
09:54:46.40 Relation 135 (PROJ_DEPT_BUDGET) is ok |
12470 |
> |
|
12471 |
> |
09:54:46.40 Relation 136 (SALARY_HISTORY) |
12472 |
> |
09:54:46.40 process pointer page 0 of 1 |
12473 |
> |
09:54:46.40 Index 1 (RDB$PRIMARY20) |
12474 |
> |
09:54:46.40 Index 2 (RDB$FOREIGN21) |
12475 |
> |
09:54:46.40 Index 3 (CHANGEX) |
12476 |
> |
09:54:46.40 Index 4 (UPDATERX) |
12477 |
> |
09:54:46.41 Relation 136 (SALARY_HISTORY) is ok |
12478 |
> |
|
12479 |
> |
09:54:46.41 Relation 137 (CUSTOMER) |
12480 |
> |
09:54:46.41 process pointer page 0 of 1 |
12481 |
> |
09:54:46.41 Index 1 (RDB$PRIMARY22) |
12482 |
> |
09:54:46.41 Index 2 (RDB$FOREIGN23) |
12483 |
> |
09:54:46.41 Index 3 (CUSTNAMEX) |
12484 |
> |
09:54:46.41 Index 4 (CUSTREGION) |
12485 |
> |
09:54:46.41 Relation 137 (CUSTOMER) is ok |
12486 |
> |
|
12487 |
> |
09:54:46.41 Relation 138 (SALES) |
12488 |
> |
09:54:46.41 process pointer page 0 of 1 |
12489 |
> |
09:54:46.41 Index 1 (RDB$PRIMARY24) |
12490 |
> |
09:54:46.41 Index 2 (RDB$FOREIGN25) |
12491 |
> |
09:54:46.41 Index 3 (RDB$FOREIGN26) |
12492 |
> |
09:54:46.41 Index 4 (NEEDX) |
12493 |
> |
09:54:46.41 Index 5 (QTYX) |
12494 |
> |
09:54:46.41 Index 6 (SALESTATX) |
12495 |
> |
09:54:46.41 Relation 138 (SALES) is ok |
12496 |
|
|
12497 |
< |
10:35:32.68 Validation finished |
12497 |
> |
09:54:46.41 Validation finished |
12498 |
|
|
12499 |
|
|
12500 |
|
Normal Validation |
15668 |
|
MyText VarChar(1024), |
15669 |
|
Primary Key (RowID) |
15670 |
|
); |
15671 |
< |
Loading data into database table. Started at 22/2/2021 10:36:29.554 |
15672 |
< |
Data load completed at 22/2/2021 10:38:03.989 Elapsed Time = 94435 ms, 100000 records loaded |
15673 |
< |
MD5 checksum = c64feb9fc39310ba79ee10a629ac32ba |
15674 |
< |
Database Read started at 22/2/2021 10:38:03.997 |
15675 |
< |
Read Dataset completed at 22/2/2021 10:38:36.093 Elapsed Time = 32096 ms, 100000 records read |
15676 |
< |
MD5 checksum = c64feb9fc39310ba79ee10a629ac32ba |
15671 |
> |
Loading data into database table. Started at 06/10/2021 09:55:30.702 |
15672 |
> |
Data load completed at 06/10/2021 09:57:14.355 Elapsed Time = 103653 ms, 100000 records loaded |
15673 |
> |
Message Hash = aada768f1d5fa8c549d255798b6df8ab |
15674 |
> |
Database Read started at 06/10/2021 09:57:14.365 |
15675 |
> |
Read Dataset completed at 06/10/2021 09:57:44.461 Elapsed Time = 30096 ms, 100000 records read |
15676 |
> |
Message Hash = aada768f1d5fa8c549d255798b6df8ab |
15677 |
|
Test Completed successfully |
15678 |
< |
22/2/2021 10:38:36.093 Test 21 passes as long as the MD5 sums are identical |
15678 |
> |
06/10/2021 09:57:44.461 Test 21 passes as long as the checksums are identical |
15679 |
|
|
15680 |
|
|
15681 |
|
------------------------------------------------------ |