140 Rules
| ID | Name | Severity |
|---|---|---|
| 1106000 | Ensure unsupported PL/SQL packages are not used |
medium
|
| 1106002 | Ensure MERGE statement is not used |
medium
|
| 1106004 | Ensure CLOB data type is not used |
medium
|
| 1106006 | Ensure PL/SQL package UTL_FILE is not used |
medium
|
| 1106008 | Ensure PL/SQL package DBMS_SCHEDULER is not used |
medium
|
| 1106010 | Ensure PL/SQL package DBMS_RANDOM is not used |
medium
|
| 1106012 | Ensure PL/SQL package DBMS_OUTPUT is not used |
medium
|
| 1106014 | Ensure PL/SQL package DBMS_AUTO_INDEX is not used |
medium
|
| 1106016 | Ensure PL/SQL packages UTL_HTTP and UTL_SMTP are not used |
medium
|
| 1106018 | Ensure PL/SQL procedures DBMS_LOGMNR.ADD_LOGFILE and DBMS_LOGMNR.REMOVE_LOGFILE are not used |
medium
|
| 1106020 | Ensure LOB data types are not used |
medium
|
| 1106022 | Ensure you don't have unsupported option GENERATED BY DEFAULT for identity columns |
medium
|
| 1106024 | Ensure SHARDED tables are not used |
medium
|
| 1106026 | Ensure XMLType columns are not used |
medium
|
| 1106028 | Ensure CLUSTER clause in CREATE TABLE statements is not used |
medium
|
| 1106030 | Ensure INDEX-ORGANIZED TABLEs (IOT) are not used |
medium
|
| 1106032 | Ensure ROWID data type is not used |
medium
|
| 1106034 | Ensure EXTERNAL TABLEs are not used |
medium
|
| 1106036 | Ensure Database Links are not used |
medium
|
| 1106038 | Ensure Unused Column is not used |
medium
|
| 1106040 | Ensure READ ONLY Table is not used |
medium
|
| 1106042 | Ensure Invisible Index is not used |
medium
|
| 1106044 | Ensure PL/SQL packages UTL_MAIL and UTL_SMTP are not used |
medium
|
| 1106046 | Ensure CREATE FUNCTION is not used |
medium
|
| 1106048 | Ensure CREATE PROCEDURE is not used |
medium
|
| 1106050 | Ensure CREATE TRIGGER is not used |
medium
|
| 1106052 | Ensure BLOB data type is not used |
medium
|
| 1106054 | Ensure CLOB data type is not used |
medium
|
| 1106056 | Ensure DBCLOB data type is not used |
medium
|
| 1106058 | Ensure VARCHAR(n) FOR BIT DATA data type is not used |
medium
|
| 1106060 | Ensure NVARCHAR data type is not used |
medium
|
| 1106062 | Ensure NCHAR data type is not used |
medium
|
| 1106064 | Ensure NCHAR VARYING data type is not used |
medium
|
| 1106066 | Ensure GRAPHIC data type is not used |
medium
|
| 1106068 | Ensure FLOAT data type is not used |
medium
|
| 1106070 | Ensure DECFLOAT data type is not used |
medium
|
| 1106072 | Ensure Db2 Scalar Function DATE is not used |
medium
|
| 1106074 | Ensure Db2 Scalar Function SMALLINT is not used |
medium
|
| 1106076 | Ensure Db2 Scalar Function LCASE is not used |
medium
|
| 1106078 | Ensure Db2 Scalar Function POSSTR is not used |
medium
|
| 1106080 | Ensure Db2 Scalar Function RAND is not used |
medium
|
| 1106082 | Ensure Db2 Scalar Function TIMESTAMP is not used |
medium
|
| 1106084 | Ensure Db2 Scalar Function CHAR is not used |
medium
|
| 1106086 | Ensure Db2 Scalar Function CONCAT is not used |
medium
|
| 1106088 | Ensure Db2 Scalar Function YEAR is not used |
medium
|
| 1106090 | Ensure Db2 Scalar Function MONTH is not used |
medium
|
| 1106092 | Ensure Db2 Scalar Functions DAY/DAYS are not used |
medium
|
| 1106094 | Ensure Db2 Scalar Functions DECIMAL/DEC are not used |
medium
|
| 1106096 | Ensure PARTITION is not used in ALTER TABLE statements |
medium
|
| 1106098 | Ensure CASE Expression is not used |
medium
|
| 1106100 | Ensure DECLARE cursor is not used |
medium
|
| 1106102 | Ensure Db2 DECLARE variable is not used |
medium
|
| 1106104 | Ensure SYSIBM.SYSDUMMY1 table is not used |
medium
|
| 1106106 | Ensure VALUES statement is not used |
medium
|
| 1106108 | Ensure Db2 SET variable is not used |
medium
|
| 1106110 | Ensure MERGE statement is not used |
medium
|
| 1106112 | Ensure FROM keyword is used in DELETE Statement |
medium
|
| 1106114 | Ensure VARBINARY data type is not used |
medium
|
| 1106116 | Ensure TINYINT data type is not used |
medium
|
| 1106118 | Ensure TIMESTAMP data type is not used |
medium
|
| 1106120 | Ensure SMALLMONEY data type is not used |
medium
|
| 1106122 | Ensure ROWVERSION data type is not used |
medium
|
| 1106124 | Ensure NVARCHAR data type is not used |
medium
|
| 1106126 | Ensure NTEXT data type is not used |
medium
|
| 1106128 | Ensure NCHAR data type is not used |
medium
|
| 1106130 | Ensure DATETIMEOFFSET data type is not used |
medium
|
| 1106132 | Ensure SQL server Scalar Function CONVERT is not used |
medium
|
| 1106134 | Ensure SQL server Scalar Function DATEADD is not used |
medium
|
| 1106136 | Ensure SQL server Scalar Function DATEDIFF is not used |
medium
|
| 1106138 | Ensure SQL server Scalar Function GETDATE is not used |
medium
|
| 1106140 | Ensure SQL server Scalar Function ISNULL is not used |
medium
|
| 1106142 | Ensure IDENTITY Columns is not used |
medium
|
| 1106144 | Ensure SQL Server SET/SELECT variable is not used |
medium
|
| 1106146 | Ensure SQL Server DECLARE variable is not used |
medium
|
| 1106148 | Ensure VALUES statement is not used |
medium
|
| 1106150 | Ensure SYSIBM.SYSDUMMY1 table is not used |
medium
|
| 1106152 | Ensure TIMESTAMP data type is not used |
medium
|
| 1106154 | Ensure VARCHAR(n) with implicit default values is not used |
medium
|
| 1106156 | Ensure NUMERIC(p, s) with implicit default values is not used |
medium
|
| 1106158 | Ensure INTEGER with implicit default values is not used |
medium
|
| 1106160 | Ensure DECIMAL(p, s) with implicit default values is not used |
medium
|
| 1106162 | Ensure DATE with implicit default values is not used |
medium
|
| 1106164 | Ensure CHAR(n) with implicit default values is not used |
medium
|
| 1106166 | Ensure FOR BIT DATA column clause is not used |
medium
|
| 1106168 | Ensure FOR SBCS | MIXED DATA column clause is not used |
medium
|
| 1106170 | Ensure CCSID ASCII | UNICODE | EBCDIC column clause is not used |
medium
|
| 1106172 | Ensure CCSID num column clause is not used |
medium
|
| 1106174 | Ensure GENERATED AS IDENTITY is not used |
medium
|
| 1106176 | Ensure Db2 Built-in Function CURRENT DATE is not used |
medium
|
| 1106178 | Ensure Db2 Built-in Function ABSVAL is not used |
medium
|
| 1106180 | Ensure Db2 Built-in Function ATANH(exp) is not used |
medium
|
| 1106182 | Ensure Db2 Built-in Function BIGINT(exp) is not used |
medium
|
| 1106184 | Ensure Db2 Built-in Function BLOB(exp [,size]) is not used |
medium
|
| 1106186 | Ensure Db2 Built-in Function CEILING(num) is not used |
medium
|
| 1106188 | Ensure Db2 Built-in Function CHAR(date, USA) is not used |
medium
|
| 1106190 | Ensure Db2 Built-in Function CHAR(string, num) is not used |
medium
|
| 1106192 | Ensure Db2 Built-in Function CHARACTER_LENGTH(string) is not used |
medium
|
| 1106194 | Ensure Db2 Built-in Function CHAR_LENGTH(string) is not used |
medium
|
| 1106196 | Ensure Db2 Built-in Function CURRENT DATE is not used |
medium
|
| 1106198 | Ensure Db2 NEXTVAL | NEXT VALUE FOR seq_name is not used |
medium
|
| 1106200 | Ensure Db2 Data Type RESULT_SET_LOCATOR is not used |
medium
|
| 1106202 | Ensure Db2 Scalar Function CONCAT is not used |
medium
|
| 1106204 | Ensure Db2 Data Type BIGINT is not used |
medium
|
| 1106206 | Ensure Db2 Data Type XML is not used |
medium
|
| 1106208 | Ensure Db2 Data Type REAL is not used |
medium
|
| 1106210 | Ensure Db2 Data Type SMALLINT is not used |
medium
|
| 1106212 | Ensure Db2 Data Type TIME is not used |
medium
|
| 1106214 | Ensure Db2 Data Type CLOB(n) is not used |
medium
|
| 1106216 | Ensure Db2 Data Type DBCLOB(n) is not used |
medium
|
| 1106218 | Ensure Db2 Data Type NCLOB(n) is not used |
medium
|
| 1106220 | Ensure Db2 Data Type FLOAT(p) is not used |
medium
|
| 1106222 | Ensure Db2 Data Type GRAPHIC(n) is not used |
medium
|
| 1106224 | Ensure Db2 Data Type NCHAR VARYING(n) is not used |
medium
|
| 1106226 | Ensure Db2 Data Type VARCHAR(n) FOR BIT DATA is not used |
medium
|
| 1106228 | Ensure Db2 Data Type NVARCHAR(n) is not used |
medium
|
| 1106230 | Ensure Db2 Data Type VARGRAPHIC(n) is not used |
medium
|
| 1106232 | Ensure Db2 Data Type CHAR(n) FOR BIT DATA is not used |
medium
|
| 1106234 | Ensure Db2 Data Type VARCHAR(n) is not used |
medium
|
| 1106236 | Ensure Db2 Data Type NUMERIC(p,s) | NUM(p,s) is not used |
medium
|
| 1106238 | Ensure Db2 Data Type INTEGER, INT is not used |
medium
|
| 1106240 | Ensure Db2 Data Type DOUBLE [PRECISION] is not used |
medium
|
| 1106242 | Ensure Db2 Data Type DECIMAL(p,s) | DEC(p,s) is not used |
medium
|
| 1106244 | Ensure Db2 Data Type DECFLOAT(16 | 34) is not used |
medium
|
| 1106246 | Ensure Db2 Data Type CHARACTER VARYING(n) is not used |
medium
|
| 1106248 | Ensure BLOB data type is not used |
medium
|
| 1106250 | Ensure NCLOB data type is not used |
medium
|
| 1106252 | Ensure DBCLOB data type is not used |
medium
|
| 1106254 | Ensure GRAPHIC data type is not used |
medium
|
| 1106256 | Ensure FOR BIT DATA statement is not used |
medium
|
| 1106258 | Ensure TIMESTAMP data type is not used |
medium
|
| 1106260 | Ensure Db2 Scalar Function CURRENT DATE is not used |
medium
|
| 1106262 | Ensure Db2 Scalar Function LCASE is not used |
medium
|
| 1106264 | Ensure SYSIBM.SYSDUMMY1 table is not used |
medium
|
| 1106266 | Ensure NUM data type is not used |
medium
|
| 1106268 | Ensure Db2 Scalar Function LEAST is not used |
medium
|
| 1106270 | Ensure Db2 Scalar Function GREATEST is not used |
medium
|
| 1106272 | Ensure Converting numeric function SMALLINT(expr) is not used |
medium
|
| 1106274 | Ensure Converting numeric function INT(string) is not used |
medium
|
| 1106276 | Ensure FOR READ ONLY is not used in SELECT statement |
medium
|
| 1106278 | Ensure CREATE OR REPLACE PROCEDURE name statement is not used |
medium
|
