Also If you are on linux you may be able to shell out to openssl to encrypt a string. You would probably need to use the -a switch to base64 encode the output.
-----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: 03 May 2013 10:44 To: 'U2 Users List' Subject: Re: [U2] AES Encryption Of CC Numbers Hi Gary Sadly the Basic ENCRYPT() function only does DES and RCn encryption. You should look at the Automatic Data Encryption features in the database itself - these are described in the security manual. That includes AES encryption, but you need to do careful planning and impact assessments before switching on ADE - it is not trivial and has ramifications. Otherwise you are probably looking at GCI or a service call to handle the encryption/decryption. Which product (UniVerse or UniData) and which platform (Windows/*nix) are you on? Brian -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gary Heiman Sent: 03 May 2013 06:37 To: u2-users@listserver.u2ug.org Subject: [U2] AES Encryption Of CC Numbers Hi folks - I'm new to this community, but aged in Multivalue Experience. Forgive me if this was aswered previously, but does anybody know of an algorithm in MV Basic to Encrypt/DeCrypt Credit Card Numbers based on one of the industry standards AES ? Thanks in advance ! Gary -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2-users-requ...@listserver.u2ug.org Sent: Thursday, May 02, 2013 12:00 PM To: u2-users@listserver.u2ug.org Subject: U2-Users Digest, Vol 49, Issue 2 Send U2-Users mailing list submissions to u2-users@listserver.u2ug.org To subscribe or unsubscribe via the World Wide Web, visit http://listserver.u2ug.org/mailman/listinfo/u2-users or, via email, send a message with subject or body 'help' to u2-users-requ...@listserver.u2ug.org You can reach the person managing the list at u2-users-ow...@listserver.u2ug.org When replying, please edit your Subject line so it is more specific than "Re: Contents of U2-Users digest..." Today's Topics: 1. Re: Would anyone else like a change to *HS.UPDFINFO? (Allen Bell) 2. Re: Would anyone else like a change to *HS.UPDFINFO? (Brian Whitehorn) 3. Re: Would anyone else like a change to *HS.UPDFINFO? (Gregor Scott) 4. Re: Would anyone else like a change to *HS.UPDFINFO? (Bill Haskett) 5. Re: Would anyone else like a change to *HS.UPDFINFO? (Brian Whitehorn) 6. Re: History of Prime Information (Anthonys Lists) 7. Re: History of Prime Information (Wjhonson) ---------------------------------------------------------------------- Message: 1 Date: Wed, 01 May 2013 15:15:54 -0500 From: Allen Bell <apb...@psiwav.com> To: U2 Users List <u2-users@listserver.u2ug.org> Subject: Re: [U2] Would anyone else like a change to *HS.UPDFINFO? Message-ID: <518177fa.40...@psiwav.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed I vote yes. Drives me crazy how it works AB On 5/1/2013 10:56 AM, Jeff Schasny wrote: > That would be a nice feature. I do believe that it only processes > files with a * or *SELECT dictionary item however. > > Gregor Scott wrote: >> I am trying to get Rocket to improve the behaviour of *HS.UPDFINFO to >> support active select lists so that only the files I want built into >> the ".hs_fileinfo" cache item (rather than have EVERY SINGLE F/Q-type >> item from the VOC included). >> >> Support inform me that I seem to be the only person interested in >> such a change, so I thought I would at least ask the question of the >> U2 community. >> >> Would anyone else find it useful to have the *HS.UPDFINFO command >> enhanced to support select lists, or have a new command created that >> deals with select lists? >> >> Thanks >> >> Gregor >> >> ________________________________ >> This email and any attachments to it are confidential. >> You must not use, disclose or act on the email if you are not the >> intended recipient. Liability limited by a scheme approved under >> Professional Standards Legislation. >> _______________________________________________ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> > ------------------------------ Message: 2 Date: Thu, 2 May 2013 09:04:21 +1000 From: Brian Whitehorn <brian.whiteh...@tollgroup.com> To: U2 Users List <u2-users@listserver.u2ug.org> Subject: Re: [U2] Would anyone else like a change to *HS.UPDFINFO? Message-ID: <8B2F56DD2EABE24F998D2EF72FAE066F02A1147A@EXMDOV02.tollgroup.local> Content-Type: text/plain; charset="us-ascii" +1 Dan, perhaps something along the lines of uservoice (www.uservoice.com) where "votes" and feedback can be collated might add additional value, this being a good example. Regards, Brian. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Wednesday, 1 May 2013 3:29 PM To: U2 Users List Subject: [U2] Would anyone else like a change to *HS.UPDFINFO? I am trying to get Rocket to improve the behaviour of *HS.UPDFINFO to support active select lists so that only the files I want built into the ".hs_fileinfo" cache item (rather than have EVERY SINGLE F/Q-type item from the VOC included). Support inform me that I seem to be the only person interested in such a change, so I thought I would at least ask the question of the U2 community. Would anyone else find it useful to have the *HS.UPDFINFO command enhanced to support select lists, or have a new command created that deals with select lists? Thanks Gregor ________________________________ This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ------------------------------ Message: 3 Date: Thu, 2 May 2013 10:34:25 +1000 From: Gregor Scott <gregor.sc...@pentanasolutions.com> To: U2 Users List <u2-users@listserver.u2ug.org> Subject: Re: [U2] Would anyone else like a change to *HS.UPDFINFO? Message-ID: <1E7F89845A3C424EBC474EE5559429A636C29E5266@aumel-win-exh01> Content-Type: text/plain; charset="us-ascii" That has not been our experience. The actual workings of the program are not well explained in the UV doco. I did find in the UV11 UniOLEDB PDF an explanation of sorts: * Scans the dictionaries of all nonsystem files named in the VOC, finding all associations and unassociated multivalued columns. * Rewrites the file information cache (.hs_fileinfo) under the account's directory, based on the above dictionary information and on the contents of the HS_FILE_ACCESS file. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Thursday, 2 May 2013 1:57 AM To: U2 Users List Subject: Re: [U2] Would anyone else like a change to *HS.UPDFINFO? That would be a nice feature. I do believe that it only processes files with a * or *SELECT dictionary item however. This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ------------------------------ Message: 4 Date: Wed, 01 May 2013 17:52:35 -0700 From: Bill Haskett <wphask...@advantos.net> To: U2 Users List <u2-users@listserver.u2ug.org> Subject: Re: [U2] Would anyone else like a change to *HS.UPDFINFO? Message-ID: <5181b8d3.9080...@advantos.net> Content-Type: text/plain; charset=UTF-8; format=flowed It has always been my opinion that any TCL verb, function, or whatever should be able to process a select list if one is present. All of the utilities I write have this capability, along with help. :-) Bill ------------------------------------------------------------------------ ----- Original Message ----- *From:* gregor.sc...@pentanasolutions.com *To:* U2 Users List <u2-users@listserver.u2ug.org> *Date:* 5/1/2013 5:34 PM *Subject:* Re: [U2] Would anyone else like a change to *HS.UPDFINFO? > That has not been our experience. > > The actual workings of the program are not well explained in the UV doco. I did find in the UV11 UniOLEDB PDF an explanation of sorts: > > * Scans the dictionaries of all nonsystem files named in the VOC, > finding all associations and unassociated multivalued columns. > * Rewrites the file information cache (.hs_fileinfo) under the > account's directory, based on the above dictionary information and on the contents of the HS_FILE_ACCESS file. > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny > Sent: Thursday, 2 May 2013 1:57 AM > To: U2 Users List > Subject: Re: [U2] Would anyone else like a change to *HS.UPDFINFO? > > That would be a nice feature. I do believe that it only processes > files with a * or *SELECT dictionary item however. > > > This email and any attachments to it are confidential. > You must not use, disclose or act on the email if you are not the > intended recipient. Liability limited by a scheme approved under > Professional Standards Legislation. > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ------------------------------ Message: 5 Date: Thu, 2 May 2013 11:05:18 +1000 From: Brian Whitehorn <brian.whiteh...@tollgroup.com> To: U2 Users List <u2-users@listserver.u2ug.org> Subject: Re: [U2] Would anyone else like a change to *HS.UPDFINFO? Message-ID: <8B2F56DD2EABE24F998D2EF72FAE066F02A11533@EXMDOV02.tollgroup.local> Content-Type: text/plain; charset="us-ascii" Gregor, As a "workaround" you could perhaps setup an empty account, then set VOC entries to point to only the files that you're interested in, and run the HS.UPDATE.FILEINFO in the account and access via the HS'ed account ? But I'd still add my +1 to your suggestion for HS.UPDATE.FILEINFO to be able to use a select list. Regards, Brian. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Thursday, 2 May 2013 10:34 AM To: U2 Users List Subject: Re: [U2] Would anyone else like a change to *HS.UPDFINFO? That has not been our experience. The actual workings of the program are not well explained in the UV doco. I did find in the UV11 UniOLEDB PDF an explanation of sorts: * Scans the dictionaries of all nonsystem files named in the VOC, finding all associations and unassociated multivalued columns. * Rewrites the file information cache (.hs_fileinfo) under the account's directory, based on the above dictionary information and on the contents of the HS_FILE_ACCESS file. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Thursday, 2 May 2013 1:57 AM To: U2 Users List Subject: Re: [U2] Would anyone else like a change to *HS.UPDFINFO? That would be a nice feature. I do believe that it only processes files with a * or *SELECT dictionary item however. This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ------------------------------ Message: 6 Date: Thu, 02 May 2013 10:21:20 +0100 From: Anthonys Lists <antli...@youngman.org.uk> To: u2-users@listserver.u2ug.org Subject: Re: [U2] History of Prime Information Message-ID: <51823010.1060...@youngman.org.uk> Content-Type: text/plain; charset=ISO-8859-1; format=flowed On 30/04/2013 19:03, Wjhonson wrote: > Anthony I'd be very surprised if the DevCom code was created that way. > My understanding, and I'm willing to be corrected, was that the DevCom code was built independently > (And thanks for those who jogged my memory) As a Pick-*like* > implementation. Which if you read my post, is what I said! Pick Systems picked off all the derivative versions, but couldn't touch the independent versions, such as Devcom/PI. > And the lawsuit wasn't so much a "they stole our code from us", as an "looks like a duck" lawsuit. > So I don't think the DevCom folk worked for or with Dick at all when > they developed that code. I don't know whether they worked with Dick or not. But Devcom was a *grandchild* to the group that developed GIRLS, GIRLS split in two, and then Devcom split off from the "not Pick" half. Do read :-) And (most of) the lawsuits were "they stole our code" suits - which was why the end result of "it wasn't your code for them to steal" was so important. Ashton Tate got burnt over the dBase code in exactly the same way - the original code was US government and when they sued over it they got burnt. Cheers, Wol > > > > > > > -----Original Message----- > From: Wols Lists <antli...@youngman.org.uk> > To: u2-users <u2-users@listserver.u2ug.org> > Sent: Tue, Apr 30, 2013 10:57 am > Subject: Re: [U2] History of Prime Information > > > On 29/04/13 19:25, Jerry Banker wrote: >> Prime Information was originally developed by Devcom I'm not sure >> what the > name was at that time but I do know that Prime Computers bought them > out and > bought the rights from Pick to develop independently. Prime became a database > powerhouse with the product at one time encompassing almost 50% of the database > business in the US. From what I heard Vmark was a group of users of > Prime Information that decided to go UNIX so they developed UniVerse > borrowing much of > the expertise from Prime to build a product that would ride on UNIX instead of > Primos, Prime's operating system. They even took over some of the > offices that > Prime had on Speen Street. When Prime went under, don't ask why, at > the end of > the 80's, early 90's, Vmark bought Prime Information. > > Actually, I don't think Pr1me bought the right to develop independently. > > iirc, the group developing GIRLS (Public Domain, btw, as all software > developed for the US gov then was) split in two, with Dick forming > Pick Systems as one half. The Devcom guys then split off from the > other half and were sued (like pretty much everyone else) by Dick. The > lawsuit then concluded that the Devcom guys had as much rights as the > Pick guys (bear in mind also, that Devcom was a re-implementation, not a derivative). > > Which is why Pick Systems ended up picking off and taking over all the > derivative versions, but not the re-implementations. > > I wasn't aware of INFORMATION owning a large chunk of the US market, > after all, they were up against Oracle and DB2 in their own back yard, > but it was Pr1me Australia that licenced PI from Devcom, and they > ended up pretty much owning the Aussie market. I didn't think they > bought Devcom out - Devcom might have turned into Revelation, but they > did buy the (joint) copyright to PI. Again iirc, I think the deal was > joint copyright, co-develop, PI on Pr1me and Devcom elsewhere. > > Cheers, > Wol > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ------------------------------ Message: 7 Date: Thu, 2 May 2013 08:49:45 -0400 (EDT) From: Wjhonson <wjhon...@aol.com> To: u2-users@listserver.u2ug.org Subject: Re: [U2] History of Prime Information Message-ID: <8d0154aa83a15af-2540-20...@webmail-d235.sysops.aol.com> Content-Type: text/plain; charset="us-ascii" Anthony that's wrong my friend. The lawsuit was a "look and feel" type lawsuit Also, I do not think the DevCom group had anything to do with GIRLS at all. From where are you getting this? Memory is a tricky animal. -----Original Message----- From: Anthonys Lists <antli...@youngman.org.uk> To: u2-users <u2-users@listserver.u2ug.org> Sent: Thu, May 2, 2013 2:21 am Subject: Re: [U2] History of Prime Information On 30/04/2013 19:03, Wjhonson wrote: > Anthony I'd be very surprised if the DevCom code was created that way. > My understanding, and I'm willing to be corrected, was that the DevCom code was built independently > (And thanks for those who jogged my memory) As a Pick-*like* > implementation. Which if you read my post, is what I said! Pick Systems picked off all the derivative versions, but couldn't touch the independent versions, such as Devcom/PI. > And the lawsuit wasn't so much a "they stole our code from us", as an "looks like a duck" lawsuit. > So I don't think the DevCom folk worked for or with Dick at all when > they developed that code. I don't know whether they worked with Dick or not. But Devcom was a *grandchild* to the group that developed GIRLS, GIRLS split in two, and then Devcom split off from the "not Pick" half. Do read :-) And (most of) the lawsuits were "they stole our code" suits - which was why the end result of "it wasn't your code for them to steal" was so important. Ashton Tate got burnt over the dBase code in exactly the same way - the original code was US government and when they sued over it they got burnt. Cheers, Wol > > > > > > > -----Original Message----- > From: Wols Lists <antli...@youngman.org.uk> > To: u2-users <u2-users@listserver.u2ug.org> > Sent: Tue, Apr 30, 2013 10:57 am > Subject: Re: [U2] History of Prime Information > > > On 29/04/13 19:25, Jerry Banker wrote: >> Prime Information was originally developed by Devcom I'm not sure >> what the > name was at that time but I do know that Prime Computers bought them > out and > bought the rights from Pick to develop independently. Prime became a database > powerhouse with the product at one time encompassing almost 50% of the database > business in the US. From what I heard Vmark was a group of users of > Prime Information that decided to go UNIX so they developed UniVerse > borrowing much of > the expertise from Prime to build a product that would ride on UNIX instead of > Primos, Prime's operating system. They even took over some of the > offices that > Prime had on Speen Street. When Prime went under, don't ask why, at > the end of > the 80's, early 90's, Vmark bought Prime Information. > > Actually, I don't think Pr1me bought the right to develop independently. > > iirc, the group developing GIRLS (Public Domain, btw, as all software > developed for the US gov then was) split in two, with Dick forming > Pick Systems as one half. The Devcom guys then split off from the > other half and were sued (like pretty much everyone else) by Dick. The > lawsuit then concluded that the Devcom guys had as much rights as the > Pick guys (bear in mind also, that Devcom was a re-implementation, not a derivative). > > Which is why Pick Systems ended up picking off and taking over all the > derivative versions, but not the re-implementations. > > I wasn't aware of INFORMATION owning a large chunk of the US market, > after all, they were up against Oracle and DB2 in their own back yard, > but it was Pr1me Australia that licenced PI from Devcom, and they > ended up pretty much owning the Aussie market. I didn't think they > bought Devcom out - Devcom might have turned into Revelation, but they > did buy the (joint) copyright to PI. Again iirc, I think the deal was > joint copyright, co-develop, PI on Pr1me and Devcom elsewhere. > > Cheers, > Wol > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ------------------------------ _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users End of U2-Users Digest, Vol 49, Issue 2 *************************************** _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2241 / Virus Database: 3162/5792 - Release Date: 05/02/13 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
