ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/testsuite/resources/Test10.sql
(Generate patch)

Comparing ibx/trunk/testsuite/resources/Test10.sql (file contents):
Revision 347 by tony, Thu Feb 25 11:56:36 2021 UTC vs.
Revision 348 by tony, Wed Oct 6 09:38:14 2021 UTC

# Line 987 | Line 987 | CREATE VIEW DEPTLIST (
987    SALARY,
988    FULL_NAME,
989    DEPT_PATH,
990 <  DEPT_KEY_PATH
990 >  DEPT_KEY_PATH,
991 >  "Payment Status"
992   ) AS
993   with recursive Depts As (
994   Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT  as VarChar(256)) as DEPT_PATH,
# Line 1001 | Line 1002 | JOIN Depts On D.HEAD_DEPT = Depts.DEPT_N
1002   )
1003  
1004   Select distinct A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,
1005 < A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH
1005 > A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH,
1006 > CASE When A.SALARY > 10000 then 'higher paid' else 'lower paid' End
1007   From EMPLOYEE A
1008   JOIN Depts D On D.DEPT_NO = A.DEPT_NO
1009   ;
# Line 1131 | Line 1133 | begin
1133  
1134          procedure get_lines returns (lines fb$out_type);
1135   end
1136 < ^
1136 > ^
1137  
1138   CREATE PACKAGE SELECT$TEST                                                    
1139   AS
# Line 1139 | Line 1141 | AS
1141   Begin
1142    Procedure ShowItems(IPARAM Integer) RETURNS (OutParam integer);
1143   End
1144 < ^
1144 > ^
1145  
1146 < SET TERM ; ^
1146 > SET TERM ;^
1147   COMMIT WORK;
1148   SET AUTODDL ON;
1149   COMMIT WORK;
# Line 1210 | Line 1212 | BEGIN SUSPEND; EXIT; END
1212  
1213   ^
1214  
1215 + CREATE PROCEDURE EMPLOYEE_PAY_STATUS
1216 + (
1217 +  EMP_NO SMALLINT
1218 + )
1219 + RETURNS
1220 + (
1221 +  PAY_STATUS VARCHAR(6) CHARACTER SET NONE
1222 + )
1223 + AS
1224 + BEGIN EXIT; END
1225 +
1226 + ^
1227 +
1228 +
1229   CREATE PROCEDURE GET_EMP_PROJ
1230   (
1231    EMP_NO SMALLINT
# Line 1304 | Line 1320 | BEGIN EXIT; END
1320  
1321   ^
1322  
1323 < SET TERM ; ^
1323 > SET TERM ;^
1324   COMMIT WORK;
1325   SET AUTODDL ON;
1326   COMMIT WORK;
# Line 1320 | Line 1336 | CREATE FUNCTION F (X INTEGER)
1336   ^
1337  
1338  
1339 < SET TERM ; ^
1339 > SET TERM ;^
1340   COMMIT WORK;
1341   SET AUTODDL ON;
1342   SET TERM ^ ;
# Line 1333 | Line 1349 | ACTIVE ON CONNECT POSITION 0
1349   as
1350   begin
1351   End
1352 < ^
1352 > ^
1353   CREATE TRIGGER "BEFORE CREATE TABLE"
1354   ACTIVE BEFORE CREATE TABLE POSITION 0
1355   AS BEGIN END
1356 < ^
1356 > ^
1357   CREATE TRIGGER "AFTER CREATE TABLE"
1358   ACTIVE AFTER CREATE TABLE POSITION 0
1359   AS BEGIN END
1360 < ^
1360 > ^
1361   CREATE TRIGGER "BEFORE ALTER TABLE"
1362   ACTIVE BEFORE ALTER TABLE POSITION 0
1363   AS BEGIN END
1364 < ^
1364 > ^
1365   CREATE TRIGGER "AFTER ALTER TABLE"
1366   ACTIVE AFTER ALTER TABLE POSITION 0
1367   AS BEGIN END
1368 < ^
1368 > ^
1369   CREATE TRIGGER "AFTER CREATE/Alter TABLE"
1370   ACTIVE AFTER CREATE TABLE OR ALTER TABLE POSITION 0
1371   AS BEGIN END
1372 < ^
1372 > ^
1373   CREATE TRIGGER "BEFORE DROP TABLE"
1374   ACTIVE BEFORE Drop TABLE POSITION 0
1375   AS BEGIN END
1376 < ^
1376 > ^
1377   CREATE TRIGGER "AFTER DROP TABLE"
1378   ACTIVE AFTER Drop TABLE POSITION 0
1379   AS BEGIN END
1380 < ^
1380 > ^
1381   CREATE TRIGGER "BEFORE CREATE PROCEDURE"
1382   ACTIVE BEFORE CREATE PROCEDURE POSITION 0
1383   AS BEGIN END
1384 < ^
1384 > ^
1385   CREATE TRIGGER "AFTER CREATE PROCEDURE"
1386   ACTIVE AFTER CREATE PROCEDURE POSITION 0
1387   AS BEGIN END
1388 < ^
1388 > ^
1389   CREATE TRIGGER "BEFORE ALTER PROCEDURE"
1390   ACTIVE BEFORE ALTER PROCEDURE POSITION 0
1391   AS BEGIN END
1392 < ^
1392 > ^
1393   CREATE TRIGGER "AFTER ALTER PROCEDURE"
1394   ACTIVE AFTER ALTER PROCEDURE POSITION 0
1395   AS BEGIN END
1396 < ^
1396 > ^
1397   CREATE TRIGGER "BEFORE DROP PROCEDURE"
1398   ACTIVE BEFORE Drop PROCEDURE POSITION 0
1399   AS BEGIN END
1400 < ^
1400 > ^
1401   CREATE TRIGGER "AFTER DROP PROCEDURE"
1402   ACTIVE AFTER Drop PROCEDURE POSITION 0
1403   AS BEGIN END
1404 < ^
1404 > ^
1405   CREATE TRIGGER "BEFORE CREATE FUNCTION"
1406   ACTIVE BEFORE CREATE FUNCTION POSITION 0
1407   AS BEGIN END
1408 < ^
1408 > ^
1409   CREATE TRIGGER "AFTER CREATE FUNCTION"
1410   ACTIVE AFTER CREATE FUNCTION POSITION 0
1411   AS BEGIN END
1412 < ^
1412 > ^
1413   CREATE TRIGGER "BEFORE ALTER FUNCTION"
1414   ACTIVE BEFORE ALTER FUNCTION POSITION 0
1415   AS BEGIN END
1416 < ^
1416 > ^
1417   CREATE TRIGGER "AFTER ALTER FUNCTION"
1418   ACTIVE AFTER ALTER FUNCTION POSITION 0
1419   AS BEGIN END
1420 < ^
1420 > ^
1421   CREATE TRIGGER "BEFORE DROP FUNCTION"
1422   ACTIVE BEFORE Drop FUNCTION POSITION 0
1423   AS BEGIN END
1424 < ^
1424 > ^
1425   CREATE TRIGGER "AFTER DROP FUNCTION"
1426   ACTIVE AFTER Drop FUNCTION POSITION 0
1427   AS BEGIN END
1428 < ^
1428 > ^
1429   CREATE TRIGGER "BEFORE CREATE TRIGGER"
1430   ACTIVE BEFORE CREATE TRIGGER POSITION 0
1431   AS BEGIN END
1432 < ^
1432 > ^
1433   CREATE TRIGGER "AFTER CREATE TRIGGER"
1434   ACTIVE AFTER CREATE TRIGGER POSITION 0
1435   AS BEGIN END
1436 < ^
1436 > ^
1437   CREATE TRIGGER "BEFORE ALTER TRIGGER"
1438   ACTIVE BEFORE ALTER TRIGGER POSITION 0
1439   AS BEGIN END
1440 < ^
1440 > ^
1441   CREATE TRIGGER "AFTER ALTER TRIGGER"
1442   ACTIVE AFTER ALTER TRIGGER POSITION 0
1443   AS BEGIN END
1444 < ^
1444 > ^
1445   CREATE TRIGGER "BEFORE DROP TRIGGER"
1446   ACTIVE BEFORE Drop TRIGGER POSITION 0
1447   AS BEGIN END
1448 < ^
1448 > ^
1449   CREATE TRIGGER "AFTER DROP TRIGGER"
1450   ACTIVE AFTER Drop TRIGGER POSITION 0
1451   AS BEGIN END
1452 < ^
1452 > ^
1453   CREATE TRIGGER "BEFORE CREATE EXCEPTION"
1454   ACTIVE BEFORE CREATE EXCEPTION POSITION 0
1455   AS BEGIN END
1456 < ^
1456 > ^
1457   CREATE TRIGGER "AFTER CREATE EXCEPTION"
1458   ACTIVE AFTER CREATE EXCEPTION POSITION 0
1459   AS BEGIN END
1460 < ^
1460 > ^
1461   CREATE TRIGGER "BEFORE ALTER EXCEPTION"
1462   ACTIVE BEFORE ALTER EXCEPTION POSITION 0
1463   AS BEGIN END
1464 < ^
1464 > ^
1465   CREATE TRIGGER "AFTER ALTER EXCEPTION"
1466   ACTIVE AFTER ALTER EXCEPTION POSITION 0
1467   AS BEGIN END
1468 < ^
1468 > ^
1469   CREATE TRIGGER "BEFORE DROP EXCEPTION"
1470   ACTIVE BEFORE Drop EXCEPTION POSITION 0
1471   AS BEGIN END
1472 < ^
1472 > ^
1473   CREATE TRIGGER "AFTER DROP EXCEPTION"
1474   ACTIVE AFTER Drop EXCEPTION POSITION 0
1475   AS BEGIN END
1476 < ^
1476 > ^
1477   CREATE TRIGGER "BEFORE CREATE VIEW"
1478   ACTIVE BEFORE CREATE VIEW POSITION 0
1479   AS BEGIN END
1480 < ^
1480 > ^
1481   CREATE TRIGGER "AFTER CREATE VIEW"
1482   ACTIVE AFTER CREATE VIEW POSITION 0
1483   AS BEGIN END
1484 < ^
1484 > ^
1485   CREATE TRIGGER "BEFORE ALTER VIEW"
1486   ACTIVE BEFORE ALTER VIEW POSITION 0
1487   AS BEGIN END
1488 < ^
1488 > ^
1489   CREATE TRIGGER "AFTER ALTER VIEW"
1490   ACTIVE AFTER ALTER VIEW POSITION 0
1491   AS BEGIN END
1492 < ^
1492 > ^
1493   CREATE TRIGGER "BEFORE DROP VIEW"
1494   ACTIVE BEFORE Drop VIEW POSITION 0
1495   AS BEGIN END
1496 < ^
1496 > ^
1497   CREATE TRIGGER "AFTER DROP VIEW"
1498   ACTIVE AFTER Drop VIEW POSITION 0
1499   AS BEGIN END
1500 < ^
1500 > ^
1501   CREATE TRIGGER "BEFORE CREATE DOMAIN"
1502   ACTIVE BEFORE CREATE DOMAIN POSITION 0
1503   AS BEGIN END
1504 < ^
1504 > ^
1505   CREATE TRIGGER "AFTER CREATE DOMAIN"
1506   ACTIVE AFTER CREATE DOMAIN POSITION 0
1507   AS BEGIN END
1508 < ^
1508 > ^
1509   CREATE TRIGGER "BEFORE ALTER DOMAIN"
1510   ACTIVE BEFORE ALTER DOMAIN POSITION 0
1511   AS BEGIN END
1512 < ^
1512 > ^
1513   CREATE TRIGGER "AFTER ALTER DOMAIN"
1514   ACTIVE AFTER ALTER DOMAIN POSITION 0
1515   AS BEGIN END
1516 < ^
1516 > ^
1517   CREATE TRIGGER "BEFORE DROP DOMAIN"
1518   ACTIVE BEFORE Drop DOMAIN POSITION 0
1519   AS BEGIN END
1520 < ^
1520 > ^
1521   CREATE TRIGGER "AFTER DROP DOMAIN"
1522   ACTIVE AFTER Drop DOMAIN POSITION 0
1523   AS BEGIN END
1524 < ^
1524 > ^
1525   CREATE TRIGGER "BEFORE CREATE ROLE"
1526   ACTIVE BEFORE CREATE ROLE POSITION 0
1527   AS BEGIN END
1528 < ^
1528 > ^
1529   CREATE TRIGGER "AFTER CREATE ROLE"
1530   ACTIVE AFTER CREATE ROLE POSITION 0
1531   AS BEGIN END
1532 < ^
1532 > ^
1533   CREATE TRIGGER "BEFORE ALTER ROLE"
1534   ACTIVE BEFORE ALTER ROLE POSITION 0
1535   AS BEGIN END
1536 < ^
1536 > ^
1537   CREATE TRIGGER "AFTER ALTER ROLE"
1538   ACTIVE AFTER ALTER ROLE POSITION 0
1539   AS BEGIN END
1540 < ^
1540 > ^
1541   CREATE TRIGGER "BEFORE DROP ROLE"
1542   ACTIVE BEFORE Drop ROLE POSITION 0
1543   AS BEGIN END
1544 < ^
1544 > ^
1545   CREATE TRIGGER "AFTER DROP ROLE"
1546   ACTIVE AFTER Drop ROLE POSITION 0
1547   AS BEGIN END
1548 < ^
1548 > ^
1549   CREATE TRIGGER "BEFORE CREATE INDEX"
1550   ACTIVE BEFORE CREATE INDEX POSITION 0
1551   AS BEGIN END
1552 < ^
1552 > ^
1553   CREATE TRIGGER "AFTER CREATE INDEX"
1554   ACTIVE AFTER CREATE INDEX POSITION 0
1555   AS BEGIN END
1556 < ^
1556 > ^
1557   CREATE TRIGGER "BEFORE ALTER INDEX"
1558   ACTIVE BEFORE ALTER INDEX POSITION 0
1559   AS BEGIN END
1560 < ^
1560 > ^
1561   CREATE TRIGGER "AFTER ALTER INDEX"
1562   ACTIVE AFTER ALTER INDEX POSITION 0
1563   AS BEGIN END
1564 < ^
1564 > ^
1565   CREATE TRIGGER "BEFORE DROP INDEX"
1566   ACTIVE BEFORE Drop INDEX POSITION 0
1567   AS BEGIN END
1568 < ^
1568 > ^
1569   CREATE TRIGGER "AFTER DROP INDEX"
1570   ACTIVE AFTER Drop INDEX POSITION 0
1571   AS BEGIN END
1572 < ^
1572 > ^
1573   CREATE TRIGGER "BEFORE CREATE SEQUENCE"
1574   ACTIVE BEFORE CREATE SEQUENCE POSITION 0
1575   AS BEGIN END
1576 < ^
1576 > ^
1577   CREATE TRIGGER "AFTER CREATE SEQUENCE"
1578   ACTIVE AFTER CREATE SEQUENCE POSITION 0
1579   AS BEGIN END
1580 < ^
1580 > ^
1581   CREATE TRIGGER "BEFORE ALTER SEQUENCE"
1582   ACTIVE BEFORE ALTER SEQUENCE POSITION 0
1583   AS BEGIN END
1584 < ^
1584 > ^
1585   CREATE TRIGGER "AFTER ALTER SEQUENCE"
1586   ACTIVE AFTER ALTER SEQUENCE POSITION 0
1587   AS BEGIN END
1588 < ^
1588 > ^
1589   CREATE TRIGGER "BEFORE DROP SEQUENCE"
1590   ACTIVE BEFORE Drop SEQUENCE POSITION 0
1591   AS BEGIN END
1592 < ^
1592 > ^
1593   CREATE TRIGGER "AFTER DROP SEQUENCE"
1594   ACTIVE AFTER Drop SEQUENCE POSITION 0
1595   AS BEGIN END
1596 < ^
1596 > ^
1597   CREATE TRIGGER "BEFORE CREATE USER"
1598   ACTIVE BEFORE CREATE USER POSITION 0
1599   AS BEGIN END
1600 < ^
1600 > ^
1601   CREATE TRIGGER "AFTER CREATE USER"
1602   ACTIVE AFTER CREATE USER POSITION 0
1603   AS BEGIN END
1604 < ^
1604 > ^
1605   CREATE TRIGGER "BEFORE ALTER USER"
1606   ACTIVE BEFORE ALTER USER POSITION 0
1607   AS BEGIN END
1608 < ^
1608 > ^
1609   CREATE TRIGGER "AFTER ALTER USER"
1610   ACTIVE AFTER ALTER USER POSITION 0
1611   AS BEGIN END
1612 < ^
1612 > ^
1613   CREATE TRIGGER "BEFORE DROP USER"
1614   ACTIVE BEFORE Drop USER POSITION 0
1615   AS BEGIN END
1616 < ^
1616 > ^
1617   CREATE TRIGGER "AFTER DROP USER"
1618   ACTIVE AFTER Drop USER POSITION 0
1619   AS BEGIN END
1620 < ^
1620 > ^
1621   CREATE TRIGGER "BEFORE CREATE COLLATION"
1622   ACTIVE BEFORE CREATE COLLATION POSITION 0
1623   AS BEGIN END
1624 < ^
1624 > ^
1625   CREATE TRIGGER "AFTER CREATE COLLATION"
1626   ACTIVE AFTER CREATE COLLATION POSITION 0
1627   AS BEGIN END
1628 < ^
1628 > ^
1629   CREATE TRIGGER "BEFORE DROP COLLATION"
1630   ACTIVE BEFORE Drop COLLATION POSITION 0
1631   AS BEGIN END
1632 < ^
1632 > ^
1633   CREATE TRIGGER "AFTER DROP COLLATION"
1634   ACTIVE AFTER Drop COLLATION POSITION 0
1635   AS BEGIN END
1636 < ^
1636 > ^
1637   CREATE TRIGGER "BEFORE ALTER CHARACTER SET"
1638   ACTIVE BEFORE ALTER CHARACTER SET POSITION 0
1639   AS BEGIN END
1640 < ^
1640 > ^
1641   CREATE TRIGGER "AFTER ALTER CHARACTER SET"
1642   ACTIVE AFTER ALTER CHARACTER SET POSITION 0
1643   AS BEGIN END
1644 < ^
1644 > ^
1645   CREATE TRIGGER "BEFORE CREATE PACKAGE"
1646   ACTIVE BEFORE CREATE PACKAGE POSITION 0
1647   AS BEGIN END
1648 < ^
1648 > ^
1649   CREATE TRIGGER "AFTER CREATE PACKAGE"
1650   ACTIVE AFTER CREATE PACKAGE POSITION 0
1651   AS BEGIN END
1652 < ^
1652 > ^
1653   CREATE TRIGGER "BEFORE ALTER PACKAGE"
1654   ACTIVE BEFORE ALTER PACKAGE POSITION 0
1655   AS BEGIN END
1656 < ^
1656 > ^
1657   CREATE TRIGGER "AFTER ALTER PACKAGE"
1658   ACTIVE AFTER ALTER PACKAGE POSITION 0
1659   AS BEGIN END
1660 < ^
1660 > ^
1661   CREATE TRIGGER "BEFORE DROP PACKAGE"
1662   ACTIVE BEFORE Drop PACKAGE POSITION 0
1663   AS BEGIN END
1664 < ^
1664 > ^
1665   CREATE TRIGGER "AFTER DROP PACKAGE"
1666   ACTIVE AFTER Drop PACKAGE POSITION 0
1667   AS BEGIN END
1668 < ^
1668 > ^
1669   CREATE TRIGGER "BEFORE CREATE PACKAGE BODY"
1670   ACTIVE BEFORE CREATE PACKAGE BODY POSITION 0
1671   AS BEGIN END
1672 < ^
1672 > ^
1673   CREATE TRIGGER "AFTER CREATE PACKAGE BODY"
1674   ACTIVE AFTER CREATE PACKAGE BODY POSITION 0
1675   AS BEGIN END
1676 < ^
1676 > ^
1677   CREATE TRIGGER "BEFORE DROP PACKAGE BODY"
1678   ACTIVE BEFORE Drop PACKAGE BODY POSITION 0
1679   AS BEGIN END
1680 < ^
1680 > ^
1681   CREATE TRIGGER "AFTER DROP PACKAGE BODY"
1682   ACTIVE AFTER Drop PACKAGE BODY POSITION 0
1683   AS BEGIN END
1684 < ^
1684 > ^
1685   CREATE TRIGGER "BEFORE ANY DDL STATEMENT"
1686   ACTIVE BEFORE ANY DDL STATEMENT POSITION 0
1687   AS BEGIN END
1688 < ^
1688 > ^
1689   CREATE TRIGGER "AFTER ANY DDL STATEMENT"
1690   ACTIVE AFTER ANY DDL STATEMENT POSITION 0
1691   AS BEGIN END
1692 < ^
1692 > ^
1693   CREATE TRIGGER SET_CUST_NO FOR CUSTOMER
1694   ACTIVE BEFORE INSERT POSITION 0
1695   AS
# Line 1681 | Line 1697 | BEGIN
1697      if (new.cust_no is null) then
1698      new.cust_no = gen_id(cust_no_gen, 1);
1699   END
1700 < ^
1700 > ^
1701   CREATE TRIGGER SET_EMP_NO FOR EMPLOYEE
1702   ACTIVE BEFORE INSERT POSITION 0
1703   AS
# Line 1689 | Line 1705 | BEGIN
1705      if (new.emp_no is null) then
1706      new.emp_no = gen_id(emp_no_gen, 1);
1707   END
1708 < ^
1708 > ^
1709   CREATE TRIGGER SAVE_SALARY_CHANGE FOR EMPLOYEE
1710   ACTIVE AFTER UPDATE POSITION 0
1711   AS
# Line 1704 | Line 1720 | BEGIN
1720              old.salary,
1721              (new.salary - old.salary) * 100 / old.salary);
1722   END
1723 < ^
1723 > ^
1724   CREATE TRIGGER POST_NEW_ORDER FOR SALES
1725   ACTIVE AFTER INSERT POSITION 0
1726   AS
1727   BEGIN
1728      POST_EVENT 'new_order';
1729   END
1730 < ^
1731 < COMMIT WORK ^
1730 > ^
1731 > COMMIT WORK^
1732   SET TERM ;^
1733   COMMIT WORK;
1734   SET AUTODDL OFF;
# Line 1777 | Line 1793 | begin
1793                  execute procedure clear;
1794          end
1795   end
1796 < ^
1796 > ^
1797  
1798   CREATE PACKAGE BODY SELECT$TEST                                                    
1799   AS
# Line 1789 | Line 1805 | Begin
1805      SUSPEND;
1806    End
1807   End
1808 < ^
1808 > ^
1809  
1810 < SET TERM ; ^
1810 > SET TERM ;^
1811   COMMIT WORK;
1812   SET AUTODDL ON;
1813   COMMIT WORK;
# Line 1827 | Line 1843 | BEGIN
1843      SUSPEND;
1844    END
1845   END
1846 < ^
1846 > ^
1847  
1848  
1849   ALTER PROCEDURE ADD_EMP_PROJ
# Line 1843 | Line 1859 | BEGIN
1859                  EXCEPTION unknown_emp_id;
1860          END
1861   END
1862 < ^
1847 <
1862 > ^
1863  
1864   ALTER PROCEDURE ALL_LANGS
1865   RETURNS
# Line 1872 | Line 1887 | BEGIN
1887              SUSPEND;
1888          END
1889      END
1890 < ^
1890 > ^
1891  
1892  
1893   ALTER PROCEDURE DELETE_EMPLOYEE
# Line 1886 | Line 1901 | BEGIN
1901  
1902          /*
1903           *      If there are any sales records referencing this employee,
1904 <         *      can't delete the employee until the sales are re-assigned
1904 >         *      cannot delete the employee until the sales are re-assigned
1905           *      to another employee or changed to NULL.
1906           */
1907          SELECT count(po_number)
# Line 1932 | Line 1947 | BEGIN
1947          WHERE emp_no = :emp_num;
1948  
1949   END
1950 < ^
1950 > ^
1951  
1952  
1953   ALTER PROCEDURE DEPT_BUDGET
# Line 1969 | Line 1984 | BEGIN
1984  
1985          SUSPEND;
1986   END
1987 < ^
1987 > ^
1988  
1989 + ALTER PROCEDURE EMPLOYEE_PAY_STATUS
1990 + (
1991 +  EMP_NUM SMALLINT
1992 + )
1993 + RETURNS
1994 + (
1995 +  PAY_STATUS VARCHAR(6) CHARACTER SET NONE,
1996 +  SALARY NUMERIC(10,2)
1997 + )
1998 + AS
1999 + BEGIN
2000 +  Select SALARY, Case
2001 +   When SALARY > 10000 and SALARY <= 100000 then 'higher'
2002 +   When SALARY > 100000 then 'gross'
2003 +   else 'lower' End
2004 +  From employee
2005 +    WHERE emp_no = :EMP_NUM
2006 +   into :SALARY, :PAY_STATUS;
2007 + END
2008 + ^
2009  
2010   ALTER PROCEDURE GET_EMP_PROJ
2011   (
# Line 1989 | Line 2024 | BEGIN
2024          DO
2025                  SUSPEND;
2026   END
2027 < ^
2027 > ^
2028  
2029  
2030   ALTER PROCEDURE "Has Space"
# Line 1998 | Line 2033 | ALTER PROCEDURE "Has Space"
2033   )
2034   AS
2035   Begin End
2036 < ^
2036 > ^
2037  
2038  
2039   ALTER PROCEDURE MAIL_LABEL
# Line 2069 | Line 2104 | BEGIN
2104  
2105          SUSPEND;
2106   END
2107 < ^
2107 > ^
2108  
2109  
2110   ALTER PROCEDURE ORG_CHART
# Line 2112 | Line 2147 | BEGIN
2147                  SUSPEND;
2148          END
2149   END
2150 < ^
2150 > ^
2151  
2152  
2153   ALTER PROCEDURE SHIP_ORDER
# Line 2172 | Line 2207 | BEGIN
2207          WHERE po_number = :po_num;
2208  
2209   END
2210 < ^
2210 > ^
2211  
2212  
2213   ALTER PROCEDURE SUB_TOT_BUDGET
# Line 2194 | Line 2229 | BEGIN
2229                  INTO :tot_budget, :avg_budget, :min_budget, :max_budget;
2230          SUSPEND;
2231   END
2232 < ^
2232 > ^
2233  
2234  
2235   ALTER PROCEDURE "UC SPACE"
# Line 2203 | Line 2238 | ALTER PROCEDURE "UC SPACE"
2238   )
2239   AS
2240   Begin End
2241 < ^
2241 > ^
2242  
2243  
2244   ALTER PROCEDURE "iCASE"
2245   AS
2246   Begin End
2247 < ^
2247 > ^
2248  
2249 < SET TERM ; ^
2249 > SET TERM ;^
2250   COMMIT WORK;
2251   SET AUTODDL ON;
2252   COMMIT WORK;
# Line 2229 | Line 2264 | END
2264   ^
2265  
2266  
2267 < SET TERM ; ^
2267 > SET TERM ;^
2268   COMMIT WORK;
2269   SET AUTODDL ON;
2270  

Diff Legend

– Removed lines
+ Added lines
< Changed lines
> Changed lines