Charles Stevenson | 1 Nov 16:05 2011
Picon

Re: [U2] Using 'MATCH'

What Wol & George Smith said.

MATCH's raison d'etre is _PATTERN_ matching.

That means:

(a) MATCH is relatively expensive to use for comparing simple literals.

(b) For MATCH, you need to enclose the pattern's literals in embedded 
quotes to ensure that it is not interpreted as a pattern.
Per Wol's "M6AWT" example:  M6AWT needs to be "'MCAWT'" or MATCH will 
reinterpret it as "'M'6A'WT'", a 3-piece pattern.
Remember, every time MATCH is going to examine the 2nd argument to 
figure out what pattern you're talking about this time, which brings us 
back to point (a).

(c) MATCH will be confusing to the next maint pgmr: he'll think you're 
talking about PATTERN matching, not simple literals.

George's INDEX() gets it right for shear efficiency,

On 10/31/2011 2:17 PM, George Smith wrote:
> If you are trying to look for an arbitrary delimited string, I think 
> the safest thing to do is something like IF INDEX(',':X.STRING:',', 
> ',':X.CODE:',',1)=0 THEN X.STRING=X.STRING:',':X.CODE 
Efficiency matters if you do many iterations.
The LOCATE suggestions are arguably more readable if the rookie pgmr 
following you is not familiar with the INDEX() technique (yet).

You may be surprised if you compare INDEX() performance to functionally 
(Continue reading)

Bill Haskett | 1 Nov 21:46 2011
Picon

[U2] UD Re-indexing

I run UD v7.2.7 on a Windows 2008 R2 machine.  I've an account that has 
administrator and unidata group permissions assigned for "full 
control".  However, when I try to delete, recreate, then build the index 
on a particular multi-level file I get:

...removing indexes for APOPEN file...
No indices created on file "APOPEN"

...removing indexes for APOPEN,HISTORY file...
errno=13: Permission denied
Delete index file 'APOPEN\X_HISTORY' failed

...now creating indexes for APOPEN...
"INDEX_1.HISTORY": can not create multiple indices on same location
No new indices are created

...now creating indexes for APOPEN,HISTORY...
One "*" represents 1000 records
********

  8057 record(s) processed.

The following is the index information on this file (the indexes are 33 
bytes long):

3 Allegis (0)-> LIST-INDEX APOPEN,HISTORY
Alternate Key Index Details for File APOPEN,HISTORY             Page   1

File..................  APOPEN,HISTORY
Alternate key length..  45
(Continue reading)

Steve Romanow | 1 Nov 21:50 2011
Picon

Re: [U2] UD Re-indexing

Google for "Take Ownership".  I had some strange permissions errors on
win7 that were resolved by not just having permissions, but I had to
be the Owner of the file I was operating on.

Do you have a support contract with Rocket?

On Tue, Nov 1, 2011 at 4:46 PM, Bill Haskett <wphaskett <at> advantos.net> wrote:
> I run UD v7.2.7 on a Windows 2008 R2 machine.  I've an account that has
> administrator and unidata group permissions assigned for "full control".
>  However, when I try to delete, recreate, then build the index on a
> particular multi-level file I get:
>
> ...removing indexes for APOPEN file...
> No indices created on file "APOPEN"
>
> ...removing indexes for APOPEN,HISTORY file...
> errno=13: Permission denied
> Delete index file 'APOPEN\X_HISTORY' failed
>
> ...now creating indexes for APOPEN...
> "INDEX_1.HISTORY": can not create multiple indices on same location
> No new indices are created
>
> ...now creating indexes for APOPEN,HISTORY...
> One "*" represents 1000 records
> ********
>
>  8057 record(s) processed.
>
> The following is the index information on this file (the indexes are 33
(Continue reading)

Colin Alfke | 1 Nov 22:33 2011
Picon

Re: [U2] UD Re-indexing

We don't use multi-level files, but usually when I see the permission denied
it means a user has the file open at the OS level. I usually use PSTools to
find it. When you delete.index ... ALL it actually deletes the X_... file so
you get this message if someone has it open.

hth
Colin Alfke
Calgary, Canada

-----Original Message-----
From: Bill Haskett

I run UD v7.2.7 on a Windows 2008 R2 machine.  I've an account that has 
administrator and unidata group permissions assigned for "full 
control".  However, when I try to delete, recreate, then build the index 
on a particular multi-level file I get:

...removing indexes for APOPEN file...
No indices created on file "APOPEN"

...removing indexes for APOPEN,HISTORY file...
errno=13: Permission denied
Delete index file 'APOPEN\X_HISTORY' failed

...now creating indexes for APOPEN...
"INDEX_1.HISTORY": can not create multiple indices on same location
No new indices are created

...now creating indexes for APOPEN,HISTORY...
One "*" represents 1000 records
(Continue reading)

Bill Haskett | 1 Nov 23:33 2011
Picon

Re: [U2] UD Re-indexing

Ah ha!  That makes sense.  One has to be careful when deleting then 
re-creating indexes.  We use the build index with the ONLINE option and 
this doesn't seem to cause this problem, only the deletion.

Thanks,

Bill
------------------------------------------------------------------------
----- Original Message -----
*From:* alfke121 <at> hotmail.com
*To:* 'U2 Users List' <u2-users <at> listserver.u2ug.org>
*Date:* 11/1/2011 2:33 PM
*Subject:* Re: [U2] UD Re-indexing
> We don't use multi-level files, but usually when I see the permission denied
> it means a user has the file open at the OS level. I usually use PSTools to
> find it. When you delete.index ... ALL it actually deletes the X_... file so
> you get this message if someone has it open.
>
> hth
> Colin Alfke
> Calgary, Canada
>
> -----Original Message-----
> From: Bill Haskett
>
> I run UD v7.2.7 on a Windows 2008 R2 machine.  I've an account that has
> administrator and unidata group permissions assigned for "full
> control".  However, when I try to delete, recreate, then build the index
> on a particular multi-level file I get:
>
(Continue reading)

DavidJMurray (mvdbs.com | 3 Nov 17:02 2011

Re: [U2] [ot] Is it just me.....


I thought first of oranges due to the starting 'sun kissed' phrase.

Personally, I find Yellowtail reasonable scoffing wine.

George Gallen-2 wrote:
> 
> Or was I the only person that wasn't thinking wine during this commercial?
> 
> http://www.youtube.com/watch?v=uS0fwYKCvIE
> 
> 

-----

Learn and Do
Excel and Share

http://mvdbs.com http://mvdbs.com 
--

-- 
View this message in context: http://old.nabble.com/-ot--Is-it-just-me.....-tp32752050p32774020.html
Sent from the U2 - Users mailing list archive at Nabble.com.

_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

George Gallen | 3 Nov 17:05 2011

Re: [U2] [ot] Is it just me.....

What caught my attention was the repeated use of ...... "GO-TO"
Kinda gave me shivers.....although, wine is not an object oriented procedure....more of an object disoriented!
   Since the object is to become disoriented, so maybe it is appropriate....

I know....SAD...very sad.

-----Original Message-----
From: u2-users-bounces <at> listserver.u2ug.org [mailto:u2-users-bounces <at> listserver.u2ug.org] On
Behalf Of DavidJMurray (mvdbs.com)
Sent: Thursday, November 03, 2011 12:03 PM
To: u2-users <at> listserver.u2ug.org
Subject: Re: [U2] [ot] Is it just me.....

I thought first of oranges due to the starting 'sun kissed' phrase.

Personally, I find Yellowtail reasonable scoffing wine.

George Gallen-2 wrote:
> 
> Or was I the only person that wasn't thinking wine during this commercial?
> 
> http://www.youtube.com/watch?v=uS0fwYKCvIE
> 
> 

-----

Learn and Do
Excel and Share

(Continue reading)

DavidJMurray (mvdbs.com | 3 Nov 17:09 2011

Re: [U2] UD Re-indexing


>From a lot of the questions posted here, I have assumed that not many people
actually have support contracts these days. Or the support mechanism is too
difficult or complicated and it's quicker to ask here.

slestak wrote:
> 
> 
> Do you have a support contract with Rocket?
> 
> 
> 

-----

Learn and Do
Excel and Share

http://mvdbs.com http://mvdbs.com 
--

-- 
View this message in context: http://old.nabble.com/UD-Re-indexing-tp32761594p32774068.html
Sent from the U2 - Users mailing list archive at Nabble.com.

_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

DavidJMurray (mvdbs.com | 3 Nov 17:13 2011

Re: [U2] [ot] Is it just me.....


Oh, stop w[h]ining........

ha ha ha, ho ho ho

arrgh hum... <cough>

yes....

George Gallen-2 wrote:
> 
> What caught my attention was the repeated use of ...... "GO-TO"
> Kinda gave me shivers.....although, wine is not an object oriented
> procedure....more of an object disoriented!
>    Since the object is to become disoriented, so maybe it is
> appropriate....
> 
> I know....SAD...very sad.
> 
> -
> 
> 

-----

Learn and Do
Excel and Share

http://mvdbs.com http://mvdbs.com 
--

-- 
(Continue reading)

DavidJMurray (mvdbs.com | 3 Nov 21:22 2011

Re: [U2] Why Pick U2?


Dan,

Did you complete the article regarding ramdisks and U2?

djm

Daniel McGrath wrote:
> 
> I've used them in development, but not in Production.
> 
> I am just about to post an article that includes usage; I just haven't had
> time to finish proof-reading it.
> 
> For windows, check it this question:
> http://superuser.com/questions/34388/whats-the-best-ramdisk-for-windows
> 
> Regards,
> Dan
> 
> -----Original Message-----
> 
> Is anyone using a RAMDisk with U2 files?
> 
> I have noticed that there are two types of ram disks within Linux - tmpfs
> and /dev/ram1 which can be used to create a small file system.
> 
> Does anyone have any practical experience on these options?
> 
> Is there an effective option for MS-Windows?
(Continue reading)


Gmane