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

Reply via email to