| 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 |
Select MyRowCount('EMPLOYEE') from RDB\$Database;
|
| 10 |
Select MyRowCount('DEPARTMENT') from RDB\$Database;
|
| 11 |
select MyRowCount('BAD') from RDB\$Database;
|
| 12 |
Select UDRINFO() from RDB\$Database;
|
| 13 |
Execute Procedure MYTESTPROC(24);
|
| 14 |
Select * From MySelectProc;
|
| 15 |
Update EMPLOYEE Set PHONE_EXT = '999' Where EMP_NO = 2;
|
| 16 |
Select PHONE_EXT,PREVIOUS_PHONE_EXT FROM EMPLOYEE Where EMP_NO = 2;
|
| 17 |
Update EMPLOYEE Set PHONE_EXT = '250' Where EMP_NO = 2;
|
| 18 |
Select PHONE_EXT,PREVIOUS_PHONE_EXT FROM EMPLOYEE Where EMP_NO = 2;
|
| 19 |
EOT
|
