The web datablade has a cast from LVARCHAR to CLOB and vice versa.

Other than installing the web datablade or attempting to build the
cast from scratch, is there any way to get the cast for 9.4? My OS's
are AIX, SOL, and Win.

I tried searching through the bladelets, but IBM's website happens.

Sincerely,

Christopher Coleman

Database Analyst
Pharmacy Division
Mediware Information Systems, Inc.
tel: 913/307-1073

christopher.coleman@mediware.com (Christopher) wrote in message news:<a727ee4f.0402061114.712fbbc9@posting.google. com>...
> The web datablade has a cast from LVARCHAR to CLOB and vice versa.
>
> Other than installing the web datablade or attempting to build the
> cast from scratch, is there any way to get the cast for 9.4? My OS's
> are AIX, SOL, and Win.
>
> I tried searching through the bladelets, but IBM's website happens.
>
> Sincerely,
>
> Christopher Coleman
>
> Database Analyst
> Pharmacy Division
> Mediware Information Systems, Inc.
> tel: 913/307-1073

I think V9.4 supports these casts. Check out syscasts and
sysprocedures of the database in question.
select * from syscasts where routine_name like '_lob%';
select * from sysprocedures where procname like '_lob%';
should bring back a load of routine for casting between lvarchar and
blobs

Ian Lowson