RE: [U2] Replication Between Unidata and MySQL

2006-07-28 Thread Ken Wallis
[EMAIL PROTECTED] wrote: > Good stuff Adrian. I've pretty much decided on Unidata triggers to > figure out what changed and write to a queue file and then have some > program pulling from that queue to flush to MySQL. But I was hoping > that I could do a lot of this in Unidata and I'm fearing I'm

[U2] Haydon Bishop is out of the office.

2006-07-28 Thread haydon . bishop
I will be out of the office starting 29/07/2006 and will not return until 07/08/2006. I will respond to your message when I return. ___ The information contained in this message is intended for the addressee only a

RE: [U2] Replication Between Unidata and MySQL [ad]

2006-07-28 Thread Tony Gravagno
Kevin, you can use triggers for the first part as Adrian suggests. As always I'll recommend mv.NET to do the second part. When you put your data into a queue file, you can simultaneously log an action item into a queue for mv.NET. This will tell a new external routine what to pick up from the qu

RE: [U2] Replication Between Unidata and MySQL

2006-07-28 Thread Kevin King
>From: Of Mike Randall >Sent: Friday, July 28, 2006 5:46 PM >...The trigger could normalize your data (or whatever you >needed done) and could be added with no impact to your application. I wouldn't say "no impact" per se but I think the trigger idea has merit overall as a minimally invasive chang

RE: [U2] Replication Between Unidata and MySQL

2006-07-28 Thread phil walker
I would suggest a trigger which updates a log file and that is all it does. The log file or a pool of log files, would be better, to allow for performance,broken files etc could contain standard trigger information plus environment details/call stack etc, (can be used for auditing then. Have a ba

RE: [U2] Replication Between Unidata and MySQL

2006-07-28 Thread Mike Randall
First thing that comes to mind is an update trigger on the Unidata side that captures every write attempt. The trigger could compare the before and after versions of the record and execute a call to a SQL update process that you come up with. The trigger could normalize your data (or whatever yo

RE: [U2] Replication Between Unidata and MySQL

2006-07-28 Thread Kevin King
Good stuff Adrian. I've pretty much decided on Unidata triggers to figure out what changed and write to a queue file and then have some program pulling from that queue to flush to MySQL. But I was hoping that I could do a lot of this in Unidata and I'm fearing I'm gonna have to write something in

RE: [U2] [ot] 128mb flash drives (seems like a good price)

2006-07-28 Thread Tony Gravagno
Tim Bryant wrote: > Fry's Outpost (outpost.com) has a 1Gb for 19.99 and a 2Gb for 24.99 > after a $15 rebate > > From: Brenda Price > You can get a 512mb at walmart.com for $18.48 and a 2Gig for 59.84. > Not so sure that is a great price. Tiger Direct just had a sale too (typical really) with a

Re: [U2] Replication Between Unidata and MySQL

2006-07-28 Thread Adrian Merrall
Kevin, I forgot to mention - you could look into the IBM MQseries support added into Unidata but I don't think it was there at 6, you may need to upgrade for this and hand IBM a lot of $ for the websphere mq software. Adrian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscri

Re: [U2] Replication Between Unidata and MySQL

2006-07-28 Thread Adrian Merrall
Kevin, I have been assigned a unique project and have been given some pretty stringent requirements. Basically the project involves a subset replication of a Unidata database into MySQL. As certain records change in Unidata (6.0) that record is to be flushed to a separate server running MySQL.

RE: [U2] Replication Between Unidata and MySQL

2006-07-28 Thread Kevin King
Desired inconsistency is a second or less, the time it takes to push bits on a wire. Interesting ideas, of course, but not likely. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. -Original Mess

RE: [U2] Replication Between Unidata and MySQL

2006-07-28 Thread Dan Fitzgerald
Could you use transaction logging & process the log file as soon as it fills? You'd have to make very small log files in order to keep latency at a minimum, but even then you might be looking at lag times on the order of 1 or 2 dozen minutes. Perhaps throttle that a bit by artificially filling t

RE: [U2] [u2][uv]HTTPS requests with createSecureRequest

2006-07-28 Thread Jerry Banker
Why not ask Wendy at [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Donnie Jacobs Sent: Friday, July 28, 2006 4:31 PM To: u2-users@listserver.u2ug.org Subject: [U2] [u2][uv]HTTPS requests with createSecureRequest Hi all, I'm trying

Re: [U2] [ot] 128mb flash drives (seems like a good price)

2006-07-28 Thread Don Kibbey
With technology, once you buy it, never check the price again! :-) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

[U2] Unidata on Sun AMD Solaris boxes

2006-07-28 Thread george r smith
Hi All, Anyone heard anything about Unidata 7.1 being certified on a Solaris AMD (not sparc) box. Big difference in price between sparc and AMD box grs --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

[U2] [u2][uv]HTTPS requests with createSecureRequest

2006-07-28 Thread Donnie Jacobs
Hi all, I'm trying to do web requests with https and the createSecureRequest functions un UniVerse. Below is a sample that I copied from the PICKWIKI, which I believe was originally posted by Wendy Smoak. Once I get this example working, I need use the secure functions to do credit card proce

[U2] Replication Between Unidata and MySQL

2006-07-28 Thread Kevin King
I have been assigned a unique project and have been given some pretty stringent requirements. Basically the project involves a subset replication of a Unidata database into MySQL. As certain records change in Unidata (6.0) that record is to be flushed to a separate server running MySQL. Off-hour

RE: [U2] [ot] 128mb flash drives (seems like a good price) - [(Header Check)] Email has different SMTP TO: and MIME TO: fields in the email addresses

2006-07-28 Thread Barry Rogen
CHECK OUT PNY for flash memory Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, t

RE: SpamSlayer Alert: [U2] Reading Binary data from a file...

2006-07-28 Thread George Gallen
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. George > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTE

RE: [U2] Reading Binary data from a file...

2006-07-28 Thread Ray Wurlod
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. --- u2-users mailing list u2-users@listserver.u2u

RE: [U2] [ot] 128mb flash drives (seems like a good price)

2006-07-28 Thread George Gallen
Well, it's not that is not a good price, it's just those are even better prices :) Of course, better prices never show up, until after you have bought the object your looking for... Just like, you always find what you've lost, after buying AND opening a new one. George > -Original Mes

RE: [U2] [ot] 128mb flash drives (seems like a good price)

2006-07-28 Thread Tim Bryant
Fry's Outpost (outpost.com) has a 1Gb for 19.99 and a 2Gb for 24.99 after a $15 rebate -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: Friday, July 28, 2006 11:54 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [ot] 128mb flash dr

RE: [U2] [ot] 128mb flash drives (seems like a good price)

2006-07-28 Thread Brenda Price
You can get a 512mb at walmart.com for $18.48 and a 2Gig for 59.84. Not so sure that is a great price. Brenda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Friday, July 28, 2006 9:42 AM To: u2-users@listserver.u2ug.org Subject: [U2]

RE: [U2] [ot] 128mb flash drives (seems like a good price)

2006-07-28 Thread George Gallen
Doesn't matter to me...I left it blank. They sent me the email for the sale, and that wasn't one of the options, which I found very strange. George > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Angelo Collazo > Sent: Friday, July 28, 2006 2:10 PM

RE: [U2] [ot] 128mb flash drives (seems like a good price)

2006-07-28 Thread Angelo Collazo
George, I'm getting ready to order one, It wants a "Referral's Email", should I use your email? You might get a nice gift. Cheers, Angelo, http://www.ewiz.com/detail.php?src=eb&name=ALUMI-128 Seems like a good price, looked like free shipping using UPS ground. and now, back to our regular pr

[U2] [ot] 128mb flash drives (seems like a good price)

2006-07-28 Thread George Gallen
http://www.ewiz.com/detail.php?src=eb&name=ALUMI-128 Seems like a good price, looked like free shipping using UPS ground. and now, back to our regular programming George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated -

RE: SpamSlayer Alert: [U2] Reading Binary data from a file...

2006-07-28 Thread George Gallen
ok. Thanks. George > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Craig Bennett > Sent: Thursday, July 27, 2006 7:23 PM > To: u2-users@listserver.u2ug.org > Subject: Re: SpamSlayer Alert: [U2] Reading Binary data from a file... > > > George it does

RE: [U2] Reading Binary data from a file...

2006-07-28 Thread George Gallen
So far SEQ has worked good, but I'll keep BYTEVAL in mind, actually never heard/used that one so I'll have to read up on it. The base64 would have encoded it for ASCII, making it just a text file. George > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf