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 d
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 exactly
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 term
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 gua
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 world
Assuming we're talking about uniVerse (and not uniData):
PERFORM is a different command. EXECUTE creates it's own execution
environment, where PERFORM does not. This means that with PERFORM you
can do a series of SELECT statements in the following way:
PERFORM "SELECT ANIMAL WITH SPECIES = 'Lio
10 matches
Mail list logo