Re: Changes in 7.4 re. LONG
"Michael Slinn" <[email protected]>
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Message-ID | <[email protected]> |
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