var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: CREATE PACKAGE error in DB2 Express-C 10.1
I'm using DB2 Express-C 10.1 and IBM Data Studio 3.1.1.
I'm trying to create a simple package:
But I get an error:
CREATE OR REPLACE PACKAGE DM_TEST
FUNCTION SampleFunction RETURN INTEGER;
CREATE OR REPLACE PACKAGE BODY DM_TEST
FUNCTION SampleFunction RETURN BIGINT
Can you help me in solving this problem?
DIME.DM_TEST: 4: Incorrect element "PACKAGE DM_TEST
FUNCTION SampleFunction" after "CREATE OR REPLACE ". SQLCODE=-104, SQLSTATE=42601, DRIVER=4.13.111
What change in query text?
P.S. I'm sorry if my English is not good
I believe packages has to be enabled via DB2_COMPATIBILITY_VECTOR. What is the result of:
Originally Posted by dime-m
The result was: MYS
Originally Posted by lelle12
I set the value of DB2_COMPATIBILITY_VECTOR to ORA, re-create database, and now everything works fine!