I'm trying to convert/cast a SQLBase LONG VARCHAR column into a VARCHAR Column using a temporary table.
The source table being used has a comment field column of type "long varchar". I am unable to find the correct syntax to use a convert/cast function.
If I try to implicitly cast/convert as below, the error I receive is
Error: 01627 TYP LON Invalid data type (long expected)
create table SYSADM.TMP_STUDENT_ (
STUDENT_NO integer,
STUDENT_COMMENTS nvarchar(255)
) pctfree 10;
insert into SYSADM.TMP_STUDENT_ (
STUDENT_NO ,
STUDENT_COMMENTS ) select
STUDENT_NO,
STUDENT_COMMENTS
from SYSADM.STUDENT;
grant all on SYSADM.TMP_STUDENT_ to PUBLIC;