Hello!
I did read prezentation of SQL Anywhere® 11
http://www.sybase.com/files/White_Papers/Sybase_SQLAnywhere_Top10newFeatures_wp.pdf
and there are very useful features which can make replication very simple. How
may be it realised in SQLite?
"1. UNLOAD to a Variable
The LOAD and UNLOAD statements now work with variables as well as files. I
don’t mean just using a variable to hold a
file specification, I mean loading and unloading data stored in variables as
well as files. You can UNLOAD all the rows and
columns of a table into a single string variable, and the reverse: LOAD a
table from a string:
BEGIN
DECLARE s LONG VARCHAR;
UNLOAD TABLE t1 TO s;
LOAD TABLE t2 FROM s;
END;
"
And
"2. FROM OPENSTRING
The new OPENSTRING clause lets you name a file or variable in the FROM
clause of a SELECT and have SQL Anywhere
treat the data inside that file or variable as a set of rows and columns.
That’s a little bit like using a proxy table to treat a file
like a table via ODBC remote access middleware, but it’s way easier and more
flexible, not to mention that OPENSTRING lets
you use variables as well as files.
...
CREATE VARIABLE @var LONG VARCHAR;
UNLOAD
SELECT *
FROM SYSDOMAIN
INTO VARIABLE @var;
CREATE VIEW V AS
SELECT *
FROM OPENSTRING ( VALUE @var ) WITH
( domain_id SMALLINT,
domain_num VARCHAR ( 128 ),
type_id SMALLINT,
“precision” SMALLINT )
AS T;
"
Best regards, Alexey.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
