While ADE does take careful consideration, it really should be what you are 
doing.

Encryption is hard. Using encryption primitives correctly is hard (ie, most 
people will get it wrong). Designing a secure encryption system realistical 
better than plaintext if your server or data is compromised is even harder.

If you don't know the differences between CBC, ECB, CTR, OCB, CFB modes, when 
to use which one, and how certain modes lead to easily compromising the 
encryption, before reading this it is a good indication you should not attempt 
to do it yourself.

ADE was designed by our in-house security expert and has many features (such as 
multiple keys, wallets) designed for properly protecting your data. 
Professional services can assist you setting up ADE if needed.

Regards,

Dan McGrath
Managing Director, U2 Servers Lab
Rocket Software
4600 South Ulster Street  ·  Suite 1100  ·   Denver, CO 80237 ·  USA
T: +1 720 475 8098 · E: dmcgr...@rocketsoftware.com · W: u2.rocketsoftware.com


-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Friday, May 03, 2013 6:43 AM
To: 'U2 Users List'
Subject: Re: [U2] AES Encryption Of CC Numbers

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
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to