Procedure Conversion Rules

Procedure Conversion Rules

RULE-14001

Version Scope: Less than the Altibase version tag 6.3.1.0.0

Type

TODO

Description

The AS LANGUAGE clause must be converted manually.

Original SQL Text

CREATE OR REPLACE PROCEDURE proc1(a1 NUMBER)
AS LANGUAGE JAVA
NAME 'test.quote() return java.lang.String';

Processed SQL Text

CREATE OR REPLACE PROCEDURE proc1(a1 NUMBER)
AS LANGUAGE JAVA
NAME 'test.quote() return java.lang.String'/* [TODO] RULE-14001 : AS LANGUAGE clause must be converted manually */;

RULE-14002

Type

REMOVED

Description

The AUTHID clause is removed.

Original SQL Text

CREATE OR REPLACE PROCEDURE proc1(a1 NUMBER)
AUTHID DEFINER
IS
BEGIN
NULL;
END;

Processed SQL Text

CREATE OR REPLACE PROCEDURE proc1(a1 NUMBER)
/* AUTHID DEFINER */ /* [REMOVED] RULE-14002 : AUTHID clause is removed */
IS
BEGIN
NULL;
END;

RULE-14003

Version Scope : Altibase 6.3.1.0.0 or later

Type

TODO

Description

The WITH CONTEXT clause should manually converted.

Original SQL Text

CREATE OR REPLACE PROCEDURE proc1 AS
LANGUAGE C LIBRARY lib1 WITH CONTEXT;

Processed SQL Text

CREATE OR REPLACE PROCEDURE proc1 AS
LANGUAGE C LIBRARY lib1 WITH CONTEXT /* [TODO] RULE-14003 : WITH CONTEXT clause must be converted manually */;

RULE-14004

Version Scope : Altibase 6.3.1.0.0 or later

Type

TODO

Description

The AGENT IN clause should be manually converted.

Original SQL Text

CREATE OR REPLACE PROCEDURE proc1 AS
LANGUAGE C LIBRARY lib1 AGENT IN(EXTPROC);

Processed SQL Text

CREATE OR REPLACE PROCEDURE proc1 AS
LANGUAGE C LIBRARY lib1 AGENT IN(EXTPROC)/* [TODO] RULE-14004 : AGENT IN clause must be converted manually */;

RULE-14005

Type

REMOVED

Description

The ACCESSIBLE BY clause has been removed.

Original SQL Text

CREATE OR REPLACE PROCEDURE proc1
ACCESSIBLE BY (TRIGGER trig1)
IS
BEGIN
NULL;
END;

Processed SQL Text

CREATE OR REPLACE PROCEDURE proc1
/* ACCESSIBLE BY (TRIGGER trig1) */ /* [REMOVED] RULE-14005 : The ACCESSIBLE BY clause is removed */
IS
BEGIN
NULL;
END;

RULE-14006

Version Scope : Altibase 6.3.1.0.0 or later

Type

TODO

Description

JAVA call specification should be manually converted.

Original SQL Text

CREATE OR REPLACE PROCEDURE proc1(a1 VARCHAR2) AS
LANGUAGE JAVA NAME
'com.altibase.ex.empMgr.addEmp(java.lang.String)';

Processed SQL Text

CREATE OR REPLACE PROCEDURE proc1(a1 VARCHAR2) AS
LANGUAGE JAVA NAME
'com.altibase.ex.empMgr.addEmp(java.lang.String)';   
/* [TODO] RULE-14006 : Java call specification should be converted manually */

RULE-14007

Version Scope : Altibase 6.3.1.0.0 or later

Type

TODO

Description

The parameters CONTEXT and SELF should be manually converted.

Original SQL Text

CREATE OR REPLACE PROCEDURE proc1(a1 NUMBER) AS
LANGUAGE C LIBRARY lib1
PARAMETERS(a1, a1 LENGTH, SELF);

Processed SQL Text

CREATE OR REPLACE PROCEDURE proc1(a1 NUMBER) AS
LANGUAGE C LIBRARY lib1
PARAMETERS(a1, a1 LENGTH, SELF /* [TODO] RULE-14007 : The parameters CONTEXT and SELF should be manually converted */);

RULE-14008

Version Scope : Altibase 6.3.1.0.0 or later

Type

TODO

Description

The properties should be manually converted except INDICATOR, LENGTH, and MAXLEN.

Original SQL Text

CREATE OR REPLACE PROCEDURE proc1(a1 NUMBER) AS
LANGUAGE C LIBRARY lib1
PARAMETERS(a1, a1 CHARSETID, a1 CHARSETFORM);

Processed SQL Text

CREATE OR REPLACE PROCEDURE proc1(a1 NUMBER) AS
LANGUAGE C LIBRARY lib1
PARAMETERS(a1, a1 CHARSETID /* [TODO] RULE-14008 : The property except for INDICATOR, LENGTH, MAXLEN must be converted manually */, a1 CHARSETFORM /* [TODO] RULE-14008 : The property except for INDICATOR, LENGTH, MAXLEN must be converted manually */);

RULE-14009

Version Scope : Altibase 6.3.1.0.0 or later

Type

TODO

Description

The BY REFERENCE clause should be manually converted.

Original SQL Text

CREATE OR REPLACE PROCEDURE proc1(a1 NUMBER) AS
LANGUAGE C LIBRARY lib1
PARAMETERS(a1 BY REFERENCE);

Processed SQL Text

CRETE OR REPLACE PROCEDURE proc1(a1 NUMBER) AS
LANGUAGE C LIBRARY lib1
PARAMETERS(a1 BY REFERENCE /* [TODO] RULE-14009 : BY REFERENCE clause must be converted manually */);

RULE-14010

Version Scope : Altibase 6.3.1.0.0 or later

Type

TODO

Description

External data type of the parameters should be manually converted.

Original SQL Text

CREAT OR REPLACE PROCEDURE proc1(a1 NUMBER) AS
LANGUAGE C LIBRARY lib1
PARAMETERS(a1 OCINUMBER);

Processed SQL Text

CREAT OR REPLACE PROCEDURE proc1(a1 NUMBER) AS
LANGUAGE C LIBRARY lib1
PARAMETERS(a1 OCINUMBER /* [TODO] RULE-14010 : External data type of the parameters should be manually converted */);