RE: [U2] Reading Binary data from a file...
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 Of Craig Bennett Sent: Thursday, July 27, 2006 7:21 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Reading Binary data from a file... George, use OPENSEQ and READBLK to read the raw data without conversion then use BYTEVAL (not SEQ as this may be affected by NLS) to determine the ASCII character/byte value. Alternatively if you have memory to spare: OPEN TYPE19FILE TO FT ELSE STOP ASSIGN 1 TO SYSTEM(1017) ;* Disable UV automatic char conversion READ JPEG FROM FT, JPEGID THEN JPEG.LEN = BYTELEN(JPEG) ;* Length in bytes ignoring NLS FOR I = 1 TO JPEG.LEN PRINT BYTEVAL(JPEG, I) NEXT I END I don't see where base64 comes into it unless the file is currently base 64 encoded. regards, Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: SpamSlayer Alert: [U2] Reading Binary data from a file...
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 require ASSIGN 1 TO SYSTEM(1017) or UV will convert any CHAR(10) or CHAR(13):CHAR(10) sequence to CHAR(254) on a read and the reverse on a write. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [ot] 128mb flash drives (seems like a good price)
http://www.ewiz.com/detail.php?src=ebname=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 - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [ot] 128mb flash drives (seems like a good price)
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=ebname=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 - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [ot] 128mb flash drives (seems like a good price)
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 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [ot] 128mb flash drives (seems like a good price) 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, --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [ot] 128mb flash drives (seems like a good 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] [ot] 128mb flash drives (seems like a good price) http://www.ewiz.com/detail.php?src=ebname=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 - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [ot] 128mb flash drives (seems like a good price)
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 drives (seems like a good 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] [ot] 128mb flash drives (seems like a good price) http://www.ewiz.com/detail.php?src=ebname=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 - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [ot] 128mb flash drives (seems like a good price)
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 Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brenda Price Sent: Friday, July 28, 2006 2:54 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [ot] 128mb flash drives (seems like a good 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 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Reading Binary data from a file...
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.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: SpamSlayer Alert: [U2] Reading Binary data from a file...
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 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 require ASSIGN 1 TO SYSTEM(1017) or UV will convert any CHAR(10) or CHAR(13):CHAR(10) sequence to CHAR(254) on a read and the reverse on a write. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
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
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, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat.t. roosevelt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Bryant Sent: Friday, July 28, 2006 3:38 PM To: u2-users@listserver.u2ug.org Subject: 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 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 drives (seems like a good 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] [ot] 128mb flash drives (seems like a good price) http://www.ewiz.com/detail.php?src=ebname=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 - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Replication Between Unidata and MySQL
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-hours batch updates are not an option at this point, inconsistency between systems is intended to be momentary at best. I can handle the conversion and flattening of the data; that's certainly no deal breaker but keeping the MySQL server updated on a near-realtime basis has me a bit freaked out. Has anyone handled this kind of thing? Is there a connector to MySQL that can be addressed from within Unidata? I could certainly do something with ODBC I would figure but with Unidata running on AIX I'm not sure how exactly I'd move the data to the MySQL server (running on a Win box) directly. Other options off the top of my head include * ...using a http server to update the MySQL instance and using the callHttp interface or... * ...writing a TCP listener to do the updating of the MySQL instance and using Unidata sockets to move the data. However, these will necessitate a bit of code that I'd prefer to avoid. What would you do? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com http://www.precisonline.com/ ** Check out scheduled Connect! training courses at http://www.precisonline.com/train.html http://www.PrecisOnline.com/train.html. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unidata on Sun AMD Solaris boxes
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/
Re: [U2] [ot] 128mb flash drives (seems like a good price)
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/
RE: [U2] [u2][uv]HTTPS requests with createSecureRequest
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 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 processing. We've tried everything we know of to try and get this to work on our servers. When we set the VerificationStrength to generous, everything is fine. But if we set it to strict, we can get it to complete. I'd prefer to use the strict setting and know that things are being verified the way that they should be. We've tried with no certificates. We tried saving the IBM certificate onto the unix box by itself and passing the absolute path name to the .cer file into the addCertificate function. We tried saving both the IBM and the Equifax certificates onto the unix box and then passing just the directory name containing both into the addCertificate function. It's latest complaint is that there's a self-signed certificate in the chain. (See below for the log file) Universe 10.1.12, PICK Flavor, UNIX (Sun O/S) If anyone has any experience with this or could offer any insight / thoughts, I'd sure appreciate it. EQUATE CRLF TO CHAR(013):CHAR(010) EXECUTE SH -c 'rm DLJ.HTTP.LOG' X.LOG.FILE = 'DLJ.HTTP.LOG' X.LOG.ACTION = 'ON' X.LOG.LEVEL = '10' X.RTN.CODE = protocolLogging(X.LOG.FILE, X.LOG.ACTION, X.LOG.LEVEL) CRT 'protocolLogging: ':X.RTN.CODE X.RTN.CODE = setHTTPDefault(VERSION, 1.1) CRT 'setting VERSION to 1.1 : ':X.RTN.CODE X.RTN.CODE = createSecurityContext(X.CONTEXT, '') CRT 'createSecurityContext: ':X.RTN.CODE URL = https://www-927.ibm.com/software/data/u2/support/u2techconnect/; POST.DATA = X.CERT.PATH=/cubs/winxfer/Certificates/IBMTechSupport.cer * changed next 2 lines from 1 to 2 per IBM X.USED.AS=2 ; * Used as an issuer certificate X.FORMAT=2 ; * DER format X.ALGORITHM=1; * RSA key X.RTN.CODE = addCertificate(X.CERT.PATH, X.USED.AS, X.FORMAT, X.ALGORITHM, X.CONTEXT) CRT 'addCertificate: ':X.RTN.CODE *X = addAuthenticationRule(X.CONTEXT,2, VerificationStrength, generous) *CRT 'VerificationStrength addAuthenticationRule = ':X X.DEPTH = 2 X.SERVER.OR.CLIENT = 2 ; * CLIENT X.RTN.CODE = setAuthenticationDepth(X.CONTEXT, X.DEPTH, X.SERVER.OR.CLIENT) CRT 'setAuthenticationDepth: ':X.RTN.CODE HTTP.METHOD=POST X.RTN.CODE = createSecureRequest(URL,HTTP.METHOD,X.HANDLE,X.CONTEXT) CRT 'createSecureRequest: ':X.RTN.CODE X.RTN.CODE = submitRequest(X.HANDLE,'',POST.DATA,X.RESPONSE.HEADERS,X.RESPONSE.DATA,X .HTTP.STATUS) CRT 'submitRequest: ':X.RTN.CODE CRT 'X.RESPONSE.HEADERS = ':X.RESPONSE.HEADERS CRT 'X.RESPONSE.DATA = ':X.RESPONSE.DATA CRT 'X.HTTP.STATUS = ':X.HTTP.STATUS X.LOG.ACTION = 'OFF' X.RTN.CODE = protocolLogging(X.LOG.FILE, X.LOG.ACTION, X.LOG.LEVEL) CRT 'protocolLogging: ':X.RTN.CODE LOG FILE 07/28/2006 16:06:58 setHTTPDefault ... name=VERSION, value=1.1 07/28/2006 16:06:58 set default HTTP version: 1.1 07/28/2006 16:06:58 createSecurityContext ... version= 07/28/2006 16:06:58 security context 46d8d0 allocated 07/28/2006 16:06:58 addCertificate ... certPath=/cubs/winxfer/Certificates/IBMTechSupport.cer,usedAs=2,format=2 ,algorithm=1 07/28/2006 16:06:58 loading CA-cert file: /cubs/winxfer/Certificates/IBMTechSupport.cer 07/28/2006 16:06:58 setAuthenticationDepth ... depth=2,s_or_c=2 07/28/2006 16:06:58 createSecureRequest ... 504cb0: URL=https://www-927.ibm.com/software/data/u2/support/u2techconnect/,meth od=POST 07/28/2006 16:06:58 setRequestHeader: standard header Content-Type=application/x-www-form-urlencoded 07/28/2006 16:06:58 new header Content-Type added with value application/x-www-form-urlencoded 07/28/2006 16:06:58 current Request date: Fri, 28 Jul 2006 21:06:58 GMT 07/28/2006 16:06:58 submitRequest ... Var 504cb0: host=www-927.ibm.com,timeout=0 07/28/2006 16:06:58 Assembled Request: POST /software/data/u2/support/u2techconnect/ HTTP/1.1 Date: Fri, 28 Jul 2006 21:06:58 GMT Host: www-927.ibm.com User-Agent: IBM UniVerse 10.x Content-Length: 0 07/28/2006 16:06:58 HTTP_START 07/28/2006 16:06:58 HTTP_CONNECT 07/28/2006 16:06:58 new host 509950:www-927.ibm.com:443 allocated (proxy:no) 07/28/2006 16:06:58 host www-927.ibm.com:443 not found in hostList 07/28/2006 16:06:58 socket 466640 allocated 07/28/2006 16:06:58 start SSLbinding ...
RE: [U2] Replication Between Unidata and MySQL
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 the log by writing a lot of zeroes to a file (created for that purpose logged) after x seconds, then ignore those zeroes at conversion... From: Kevin King [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: [U2] Replication Between Unidata and MySQL Date: Fri, 28 Jul 2006 14:30:56 -0700 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-hours batch updates are not an option at this point, inconsistency between systems is intended to be momentary at best. I can handle the conversion and flattening of the data; that's certainly no deal breaker but keeping the MySQL server updated on a near-realtime basis has me a bit freaked out. Has anyone handled this kind of thing? Is there a connector to MySQL that can be addressed from within Unidata? I could certainly do something with ODBC I would figure but with Unidata running on AIX I'm not sure how exactly I'd move the data to the MySQL server (running on a Win box) directly. Other options off the top of my head include * ...using a http server to update the MySQL instance and using the callHttp interface or... * ...writing a TCP listener to do the updating of the MySQL instance and using Unidata sockets to move the data. However, these will necessitate a bit of code that I'd prefer to avoid. What would you do? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com http://www.precisonline.com/ ** Check out scheduled Connect! training courses at http://www.precisonline.com/train.html http://www.PrecisOnline.com/train.html. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Replication Between Unidata and MySQL
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 Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Friday, July 28, 2006 3:09 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Replication Between Unidata and MySQL 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 the log by writing a lot of zeroes to a file (created for that purpose logged) after x seconds, then ignore those zeroes at conversion... From: Kevin King [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: [U2] Replication Between Unidata and MySQL Date: Fri, 28 Jul 2006 14:30:56 -0700 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-hours batch updates are not an option at this point, inconsistency between systems is intended to be momentary at best. I can handle the conversion and flattening of the data; that's certainly no deal breaker but keeping the MySQL server updated on a near-realtime basis has me a bit freaked out. Has anyone handled this kind of thing? Is there a connector to MySQL that can be addressed from within Unidata? I could certainly do something with ODBC I would figure but with Unidata running on AIX I'm not sure how exactly I'd move the data to the MySQL server (running on a Win box) directly. Other options off the top of my head include * ...using a http server to update the MySQL instance and using the callHttp interface or... * ...writing a TCP listener to do the updating of the MySQL instance and using Unidata sockets to move the data. However, these will necessitate a bit of code that I'd prefer to avoid. What would you do? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com http://www.precisonline.com/ ** Check out scheduled Connect! training courses at http://www.precisonline.com/train.html http://www.PrecisOnline.com/train.html. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Replication Between Unidata and MySQL
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. Off-hours batch updates are not an option at this point, inconsistency between systems is intended to be momentary at best. This sort of stuff keeps life interesting. I can handle the conversion and flattening of the data; that's certainly no deal breaker but keeping the MySQL server updated on a near-realtime basis has me a bit freaked out. Has anyone handled this kind of thing? Is there a connector to MySQL that can be addressed from within Unidata? I could certainly do something with ODBC I would figure but with Unidata running on AIX I'm not sure how exactly I'd move the data to the MySQL server (running on a Win box) directly. Other options off the top of my head include * ...using a http server to update the MySQL instance and using the callHttp interface or... If your webserver is down you then need to cache locally. * ...writing a TCP listener to do the updating of the MySQL instance and using Unidata sockets to move the data. Similar to the above - if the listener is down you loose your data. However, these will necessitate a bit of code that I'd prefer to avoid. What would you do? We use something similar to triggers. Instead of writing directly to a file, our file writes are via a subroutine. This subroutine writes to the file and writes what we call replication records to a another file. We actually write a header and a data record (for a delete there is only the header record). If I was doing it again I would look closely at UD triggers. Then another process runs almost all the time polling this file and sending the records. If you wanted to cut down the lag you could do both, attempt a direct send and if this fails, cache locally for delayed send. You would have to be careful with versioning to ensure a subsequent direct send didn't get clobbered by a delayed cached message update. Gotchas. If the destination box or the transfer process are down, your local message cache can build up really quick - make sure the stop, clear and recovery process are well understood. Its bad news when replication to another box takes down your production server. Lost updates. You may need some kind of validation/recovery process. We currently move the messages with scripts at the os level (linux) and its a bit clumsy but I'm in the early stages of looking into using jms and the apache activemq software. HTH Adrian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Replication Between Unidata and MySQL
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 unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [ot] 128mb flash drives (seems like a good price)
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 1GB stick for 9.99 after $80 rebate, and you get a security suite with it, FWIW. They have other 128MB sticks for the same 9.99, 512 for 17.99 and Samsung 2GB for 29.99. Deals are everywhere. Maybe they shouldn't be in this forum unless someone has figured out a way to deploy Universe on a Stick. Regarding Fry's, I don't mind buying stuff from them, though they do have a high rate of returns (as evident by continual long lines for Customer Service at the entry way). I have very bad experience with their rebate programs. The people responsible for the rebates (occasionally layers of third-party agencies down to the manufacturers, none of whom ever seem to be in their office to take your call at the moment) are effectively disconnected from Fry's Corporate, and you have virtually no ability to complain about their program or return the merchandise if you feel a need to claim fraud. The lower the amount of money involved the more they will give you the runaround until (they expect) you're ready to just write it off. I've been through this a few times and took this on as one of my little projects (things to do while the system is booting or waiting for a phone call...): I was a thorn in their side for a year on a $20 rebate and they actually held out. Caveat Emptor - YMMV T --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Replication Between Unidata and MySQL
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 AIX that pushes to MySQL. Not that it's all that difficult, but damn I've been spoiled by Unidata. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Merrall Sent: Friday, July 28, 2006 3:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Replication Between Unidata and MySQL 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. Off-hours batch updates are not an option at this point, inconsistency between systems is intended to be momentary at best. This sort of stuff keeps life interesting. I can handle the conversion and flattening of the data; that's certainly no deal breaker but keeping the MySQL server updated on a near-realtime basis has me a bit freaked out. Has anyone handled this kind of thing? Is there a connector to MySQL that can be addressed from within Unidata? I could certainly do something with ODBC I would figure but with Unidata running on AIX I'm not sure how exactly I'd move the data to the MySQL server (running on a Win box) directly. Other options off the top of my head include * ...using a http server to update the MySQL instance and using the callHttp interface or... If your webserver is down you then need to cache locally. * ...writing a TCP listener to do the updating of the MySQL instance and using Unidata sockets to move the data. Similar to the above - if the listener is down you loose your data. However, these will necessitate a bit of code that I'd prefer to avoid. What would you do? We use something similar to triggers. Instead of writing directly to a file, our file writes are via a subroutine. This subroutine writes to the file and writes what we call replication records to a another file. We actually write a header and a data record (for a delete there is only the header record). If I was doing it again I would look closely at UD triggers. Then another process runs almost all the time polling this file and sending the records. If you wanted to cut down the lag you could do both, attempt a direct send and if this fails, cache locally for delayed send. You would have to be careful with versioning to ensure a subsequent direct send didn't get clobbered by a delayed cached message update. Gotchas. If the destination box or the transfer process are down, your local message cache can build up really quick - make sure the stop, clear and recovery process are well understood. Its bad news when replication to another box takes down your production server. Lost updates. You may need some kind of validation/recovery process. We currently move the messages with scripts at the os level (linux) and its a bit clumsy but I'm in the early stages of looking into using jms and the apache activemq software. HTH Adrian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Replication Between Unidata and MySQL
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 you needed done) and could be added with no impact to your application. Mike From: Kevin King [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: [U2] Replication Between Unidata and MySQL Date: Fri, 28 Jul 2006 14:30:56 -0700 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-hours batch updates are not an option at this point, inconsistency between systems is intended to be momentary at best. I can handle the conversion and flattening of the data; that's certainly no deal breaker but keeping the MySQL server updated on a near-realtime basis has me a bit freaked out. Has anyone handled this kind of thing? Is there a connector to MySQL that can be addressed from within Unidata? I could certainly do something with ODBC I would figure but with Unidata running on AIX I'm not sure how exactly I'd move the data to the MySQL server (running on a Win box) directly. Other options off the top of my head include * ...using a http server to update the MySQL instance and using the callHttp interface or... * ...writing a TCP listener to do the updating of the MySQL instance and using Unidata sockets to move the data. However, these will necessitate a bit of code that I'd prefer to avoid. What would you do? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Replication Between Unidata and MySQL
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 background process which filters/transforms data and updates remove database within a transaction. Flag/delete records from log when committed to remote database only, otherwise reprocess. I am using xml/webservices to do this to MS Sql. Process log sequentially, then you are able to say where process is at and how far behind it is. Better yo use this disjointed mechanism, as will not slow down normal user processing to much as trigger is just doing one more write. Not waiting for a commit to a remote database. Disjoint process also allows for any part to be down. Mutliple log files, one current allows for broken files, as if you are captruing every write the log file will get large very quickly. Cheers, Phil. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: Saturday, 29 July 2006 2:01 p.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] Replication Between Unidata and MySQL 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 you needed done) and could be added with no impact to your application. Mike From: Kevin King [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: [U2] Replication Between Unidata and MySQL Date: Fri, 28 Jul 2006 14:30:56 -0700 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-hours batch updates are not an option at this point, inconsistency between systems is intended to be momentary at best. I can handle the conversion and flattening of the data; that's certainly no deal breaker but keeping the MySQL server updated on a near-realtime basis has me a bit freaked out. Has anyone handled this kind of thing? Is there a connector to MySQL that can be addressed from within Unidata? I could certainly do something with ODBC I would figure but with Unidata running on AIX I'm not sure how exactly I'd move the data to the MySQL server (running on a Win box) directly. Other options off the top of my head include * ...using a http server to update the MySQL instance and using the callHttp interface or... * ...writing a TCP listener to do the updating of the MySQL instance and using Unidata sockets to move the data. However, these will necessitate a bit of code that I'd prefer to avoid. What would you do? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Replication Between Unidata and MySQL
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 change watcher. But then what? What's the best way to get the deltas into the MySQL instance? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Replication Between Unidata and MySQL [ad]
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 queue file and what to do with it. In this case, read data from the queue file, update MySQL, and on confirmed update remove the items from the UD queues - you don't need to worry about lost updates. Yes, some code is required, but such is the price we pay for sophisticated data manipulation between environments. The MVExec freeware on my website requires mv.NET to communicate with the DBMS but here is how it can be used in this case: - You have a program running over Windows in any language of your choosing, Perl, PHP, VB, Java, etc. - You use MVExec to query for data and pull a single record over if there is anything scheduled to go to MySQL. - You query MySQL and post the update. - You use MVExec again to remove the trigger item. Loop as required. This process can be streamlined to pull the entire queue from unidata in the form of a large SQL INSERT or UPDATE query. Then all you need to do is execute the query. On success just delete the UD items. Similarly you can loop on the server data, build one long query on the windows side, then just execute it. As you can see, there are a number of ways to implement this. The stopgap in the current thinking is the idea that Unidata needs to communicate with the remote server. If you leave the work to a middle tier, which is where the MySQL environment is running anyway, then all of the problems go away. Personal comment: In a weird sense I'm getting as tired of recommending mv.NET as some of you people are probably tired of seeing the recommendations, and I often just don't jump in to offer related solutions for just this reason. But doesn't it tell us something that there is a consistent answer for so many of these commnications problems? Please remember that I came to this software as a user because I didn't find anything else in our market that answered all the questions. Obviously after all of these years people are still asking all of the same questions! So after investigating this software and becoming comfortable with its depth I decided to sell it and related services. I did not just jump into this market as a vendor, and my goal is not to just sell software. I try to share solutions that I've found to common problems and I hope some people here will benefit. Kevin, I'd be honored to work with you to make this happen. Tony TG@ removethisNebula-RnD.com Kevin King 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 gonna have to write something in AIX that pushes to MySQL. Not that it's all that difficult, but damn I've been spoiled by Unidata. Adrian wrote: However, these will necessitate a bit of code that I'd prefer to avoid. What would you do? We use something similar to triggers. Instead of writing directly to a file, our file writes are via a subroutine. This subroutine writes to the file and writes what we call replication records to a another file. We actually write a header and a data record (for a delete there is only the header record). If I was doing it again I would look closely at UD triggers. Then another process runs almost all the time polling this file and sending the records. If you wanted to cut down the lag you could do both, attempt a direct send and if this fails, cache locally for delayed send. You would have to be careful with versioning to ensure a subsequent direct send didn't get clobbered by a delayed cached message update. Gotchas. If the destination box or the transfer process are down, your local message cache can build up really quick - make sure the stop, clear and recovery process are well understood. Its bad news when replication to another box takes down your production server. Lost updates. You may need some kind of validation/recovery process. We currently move the messages with scripts at the os level (linux) and its a bit clumsy but I'm in the early stages of looking into using jms and the apache activemq software. HTH Adrian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Haydon Bishop is out of the office.
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 and may contain confidential and/or privileged information. If you are not the addressee, please delete this message and notify the sender. You should not copy or distribute this message or disclose its contents to anyone. E-mail transmissions cannot be guaranteed to be secure or free of errors or viruses. Therefore, no reliance may be placed on this message without written confirmation from an authorized representative of its contents. Copyright ) 2006 Donovan Data Systems Ltd. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
