While you are on the subject I have discovered another little annoyance from Windows as opposed to Unix. On Unix, Linux, Solaris, et al you can do a select on an account and get the same results every time, however, on windows you may not. At least with Universe. For a simple test do a select on your current account:
SELECT &UFD&
Then do it a second time:
SELECT &UFD&
On 'nix systems you will get no difference, but, on windows you will get a list of entries that it says do not exist and the selection count is lower. What I have found is that on the first pass it will select all entries but on the second pass none of the folder type files can be found. An account is usually made up of a variety of file types; including segmented hash and types 1, 19, 25, and 30. What an annoyance when you're trying to create lists for backing up or moving to a test location.

--------------------------------------------------
From: "Dan McGrath" <[email protected]>
Sent: Sunday, December 13, 2009 6:15 PM
To: "U2 Users List" <[email protected]>
Subject: [U2] SELECTs on FILEs

Hi all,



Just a quick question on SELECTs for UD.



I was under the impression that performing a wildcard SELECT with @ID
would only result the key section of a FILE been read.



Eg, SELECT MYFILE WITH @ID = "prefix]"



Is this incorrect? Does it actually result in the entire FILE being read
into memory to complete this SELECT?



Regards,

Dan


###########################################################################################
The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please
contact the sender and delete the material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB.
###########################################################################################
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users

_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to