This blog post talks about using a named pipe to pass data from the UNLOAD TABLE statement on one Version 12 database to the LOAD TABLE on another database running on the same server: UNLOAD and LOAD Via Named Pipes

Is it possible to get that to work for the same databases running on separate servers on the same computer?

On different computers on the network?

The following code is exactly the same as the blog post, except for the separate servers; instead of working, it gets stuck forever.

"%SQLANY12%\Bin32\dbinit.exe"^
  ddd1.db

"%SQLANY12%\Bin32\dbinit.exe"^
  ddd2.db

"%SQLANY12%\Bin32\dbspawn.exe"^
  -f "%SQLANY12%\Bin32\dbsrv12.exe"^
  -o dbsrv12_ddd1_log.txt^
  ddd1.db

"%SQLANY12%\Bin32\dbspawn.exe"^
  -f "%SQLANY12%\Bin32\dbsrv12.exe"^
  -o dbsrv12_ddd2_log.txt^
  ddd2.db

"%SQLANY12%\Bin32\dbisql.com"^
  -c "ENG=ddd1;DBN=ddd1;UID=dba;PWD=sql;CON=ddd1"

"%SQLANY12%\Bin32\dbisql.com"^
  -c "ENG=ddd2;DBN=ddd2;UID=dba;PWD=sql;CON=ddd2"

---------------------------------------------------------------------
-- On ddd1

BEGIN
   DROP TABLE t1
   EXCEPTION WHEN OTHERS THEN
END;

CREATE TABLE t1 ( 
   pkey INTEGER NOT NULL PRIMARY KEY,
   data INTEGER NOT NULL );

INSERT t1 VALUES ( 1, 2 );
INSERT t1 VALUES ( 2, 2 );
COMMIT;

SELECT * FROM t1;

---------------------------------------------------------------------
-- On ddd2

BEGIN
   DROP TABLE t2
   EXCEPTION WHEN OTHERS THEN
END;

CREATE TABLE t2 ( 
   pkey INTEGER NOT NULL PRIMARY KEY,
   data INTEGER NOT NULL );

BEGIN
   DROP SERVER ddd1_server;
   EXCEPTION WHEN OTHERS THEN
END;

CREATE SERVER ddd1_server CLASS 'SAODBC' 
   USING 'DRIVER=SQL Anywhere 12;ENG=ddd1;DBN=ddd1';

BEGIN
   DROP EVENT unload;
   EXCEPTION WHEN OTHERS THEN
END;

CREATE EVENT unload
HANDLER BEGIN

DECLARE @sql LONG VARCHAR;

SET @sql = 'UNLOAD TABLE t1 TO ''\\\\.\\pipe\\data''';
   SET @sql = REPLACE ( @sql, '''', '''''' );
   SET @sql = REPLACE ( @sql, '\\', '\\\\' );
   SET @sql = REPLACE ( @sql, '\\', '\\\\' );
   SET @sql = STRING ( 'FORWARD TO ddd1_server ''', @sql, '''' );

MESSAGE STRING ( CURRENT TIMESTAMP, ' ***** Step 1: ', @sql ) TO CONSOLE;
   EXECUTE IMMEDIATE @sql;
   MESSAGE STRING ( CURRENT TIMESTAMP, ' ***** Step 2: unload done' ) TO CONSOLE;

END;

MESSAGE STRING ( CURRENT TIMESTAMP, ' ***** TEST STARTING *****' ) TO CONSOLE;
TRIGGER EVENT unload;
MESSAGE STRING ( CURRENT TIMESTAMP, ' ***** Step 3: load starting' ) TO CONSOLE;
LOAD TABLE t2 FROM '\\\\.\\pipe\\data';
MESSAGE STRING ( CURRENT TIMESTAMP, ' ***** Step 4: load done' ) TO CONSOLE;

SELECT * FROM t2;

=====

SQL Anywhere Network Server Version 12.0.1.3298
...
Now accepting requests
2011-07-31 05:41:44.239 ***** TEST STARTING *****
2011-07-31 05:41:44.253 ***** Step 1: FORWARD TO ddd1_server 'UNLOAD TABLE t1 TO ''\\\\\\\\.\\\\pipe\\\\data'''
2011-07-31 05:41:44.260 ***** Step 3: load starting
Cache size adjusted to 4020K

>>> STUCK at the LOAD TABLE t2 FROM '\\\\.\\pipe\\data';