Output Code

Source Code

Suppose this is the input source code you've migrated:

CREATE TABLE! TABLE_Invalid
(
  COL1 VARCHAR2(255),
  COL2 VARCHAR2
);

CREATE TABLE TABLE1
(
  COL1 INT,
  COL2 VARCHAR2!
);

CREATE OR REPLACE VIEW VIEW1
AS
    SELECT 
        UNKOWN_FUNCTION(1), 
        COL1, 
        COL2 
    FROM TABLE1
;

Output code

-- ** MSC-ERROR - MSCEWI1001 - UNRECOGNIZED TOKEN ON LINE 1 OF THE SOURCE CODE. **
--CREATE TABLE! TABLE_Invalid
--(
--  COL1 VARCHAR2(255),
--  COL2 VARCHAR2
--)
 ;

CREATE TABLE PUBLIC.TABLE1
(
  COL1 INT,
-- ** MSC-ERROR - MSCEWI1001 - UNRECOGNIZED TOKEN ON LINE 10 OF THE SOURCE CODE. **
--  COL2 VARCHAR2!
);

CREATE OR REPLACE VIEW PUBLIC.VIEW1
AS
    SELECT
        UNKOWN_FUNCTION(1) /*** MSC-ERROR - MSCEWI1073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW FOR 'UNKOWN_FUNCTION' NODE ***/,
        COL1,
        COL2
    FROM TABLE1
;

How to interpret the output code?

  • There is one parsing error in line number one. This is because of an invalid token CREATE TABLE!

  • There is another parsing error on line 10. This is because of an invalid tokenVARCHAR2!

  • There is an unknown function UNKNOWN_FUNCTION , which is translated as is, but warning MSCEWI1073 is added to indicate that this is something that has not been checked yet and therefore, the functional equivalence cannot be assured.