Re: LVARCHAR to CLOB Cast

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