Proposing three alternatives:
1) UniData Triggers that call a UniData EDA (Extended Data Architecture)
interface to write to MySQL. The only thing that has to be developed is
the MySQL interface for EDA. The burden here is adding triggers for the
UDT database. Hummm
2) UDT Triggers that feed
BTW - i have succesfully used the MySQL odbc drivers on unix to write to
MySQL on windows and unix machines using the unidata bci calls from my
databasic - it works very well .
One point to note - there was a bug in version 4 of the MyODBC drivers that
go with MySQL 4. The bug was to do with the
Ray Wurlod wrote:
Prefer UNISEQ and UNICHAR to SEQ and CHAR respectively if there's any
possibility that NLS might be enabled.
BYTEVAL can be misleading; it only reports the value of a single byte, which
may be a lead or trailing byte of a multi-byte character.
Wouldn't the raw bytes be
Steve O'Neal wrote:
Proposing three alternatives:
1) UniData Triggers that call a UniData EDA (Extended Data
Architecture) interface to write to MySQL. The only thing
that has
to be developed is the MySQL interface for EDA. The
burden here is
adding triggers for the UDT database. Hummm
George Gallen wrote:
When assigning 1 to System(1017), does that only affect the
current process, or all processes running on UV? So, does
System(1017) get reset when the program terminates? or do I
need to set it back to normal.
The setting is per-process and is reset when the program
EDA is not OFS. It is a new portion of UDT 7.x. In U2 Lab Services, we
try to push new technologies rather than driving the car with our hands on
the rear view mirror!
Man, stuck both feet in my mouth. OK. My Bad...
First foot... UDT 6.x does not have EDA. It was included in 7.x. Sorry.
EDA is not OFS. It is a new portion of UDT 7.x. In U2 Lab Services, we
try to push new technologies rather than driving the car with our hands on
the rear view mirror!
Just a thought. The new version of DB2 has a free version to compete with
and convert MYSQL users. If you converted the
DataStage Server edition does work with UniData. There is a UniData
passive stage in the same group with the UniVerse stage for access to
these files. Now, if you are planning on using the Hashed File stage,
1) that only works with UniVerse files; 2) is a very bad idea since
there is no
If someone is looking at MySql I hardly think they would contemplate
buying DataStageat least the last time I saw any pricing...might be
different now that IBM own it. But I suspect it financed quite a few
executives/shareholders retirements ;-). Only 1 or 2 sites left in this
part of the