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