I still would like to know the syntax for inserting a LONG VARCHAR using SQL syntax in SAPDB 7.4.
Mike > Michael Slinn wrote: >> Specifically, I am looking to be able to INSERT a record with a LONG >> VARCHAR (and to discover what the syntax might be), and to SELECT >> records based on the contents of a LONG VARCHAR, and to compare a LONG >> VARCHAR with a string like '%keyword%'. > > To insert LONG values, it is best to use PreparedStatements. Although > you can have LONG literals in INSERTs, there are restricted in size. The > is no way to use LONG columns in predicates (except for IS NULL I > think). > > Daniel Dittmar > > -- > Daniel Dittmar > SAP DB, SAP Labs Berlin > [EMAIL PROTECTED] > http://www.sapdb.org > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general Best regards, Michael Slinn Founder & CTO http://zamples.com 650-345-1140 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
