The changelog for SAPDB doesn't mention any new features, and http://sapdb.org/7. 4/htmhelp/32/60a017540911d5a9fd00a0c9449261/content.htm doesn't seem to have all the relevant information. I don't know what the source for this person's information is: http://sapdb.2scale.net/moin.cgi/ChangesIn74 but he hints that LONGs have had some restrictions removed: "CREATE TABLE ... AS SELECT and INSERT ... SELECT now work with LONG columns"
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%'. When we used Oracle we didn't need LONG, since the SAPDB restriction of 8K bytes in a record isn't an issue. Now that we are switching to SAPDB, we need some means of supporting records with potentially long strings, and to be able to search. Perhaps if SAPDB doen'st support SQL statements to do the above, there might be a possibility of writing some code that runs in SAPDB to perform the search. How might this be done? Mike _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
