| 29 |
|
returns (FullName VarChar(36), Salary Numeric(10,2), AccSalary Numeric(10,2) ) |
| 30 |
|
external name 'fbudrtests!select_proc' |
| 31 |
|
engine udr; |
| 32 |
+ |
create or alter procedure MyReadText ( |
| 33 |
+ |
path varchar(200) not null /*relative to udr directory */ |
| 34 |
+ |
) returns ( |
| 35 |
+ |
text varchar(100) not null |
| 36 |
+ |
) |
| 37 |
+ |
external name 'fbudrtests!read_txt' |
| 38 |
+ |
engine udr; |
| 39 |
|
Alter Table EMPLOYEE Add PREVIOUS_PHONE_EXT VarChar(4); |
| 40 |
|
Create or Alter Trigger MyEmployeeUpdate Active Before Update On EMPLOYEE |
| 41 |
|
external name 'fbudrtests!my_employee_update' |
