| 1 |
#!/bin/sh
|
| 2 |
|
| 3 |
if [ -z "$FIREBIRD" ]; then
|
| 4 |
echo "FIREBIRD not defined"
|
| 5 |
exit
|
| 6 |
fi
|
| 7 |
|
| 8 |
$FIREBIRD/bin/isql -user SYSDBA -pass masterkey employee <<EOT
|
| 9 |
create or alter function MyRowCount (
|
| 10 |
table_name varchar(31)
|
| 11 |
) returns integer
|
| 12 |
external name 'fbudrtests!row_count'
|
| 13 |
engine udr;
|
| 14 |
create or alter function BadRowCount (
|
| 15 |
table_name varchar(31)
|
| 16 |
) returns integer
|
| 17 |
external name 'fbudrtests!bad_row_count'
|
| 18 |
engine udr;
|
| 19 |
create or alter function UDRInfo (
|
| 20 |
) returns VarChar(31)
|
| 21 |
external name 'fbudrtests!return_info!Hello World'
|
| 22 |
engine udr;
|
| 23 |
create or alter procedure MyTestProc (
|
| 24 |
EMP_NO SMALLINT
|
| 25 |
) returns (Salary Numeric(10,2), FullName VarChar(36))
|
| 26 |
external name 'fbudrtests!test_proc'
|
| 27 |
engine udr;
|
| 28 |
create or alter procedure MySelectProc ()
|
| 29 |
returns (FullName VarChar(36), Salary Numeric(10,2), AccSalary Numeric(10,2) )
|
| 30 |
external name 'fbudrtests!select_proc'
|
| 31 |
engine udr;
|
| 32 |
Alter Table EMPLOYEE Add PREVIOUS_PHONE_EXT VarChar(4);
|
| 33 |
Create or Alter Trigger MyEmployeeUpdate Active Before Update On EMPLOYEE
|
| 34 |
external name 'fbudrtests!my_employee_update'
|
| 35 |
engine udr;
|
| 36 |
EOT
|
| 37 |
|
