Re: [U2] uv - mkdbfile [not-secure]

2008-07-24 Thread Ray Wurlod
Try upper case -64BIT at the end.

> - Original Message -
> From: "Hennessey, Mark F." <[EMAIL PROTECTED]>
> To: u2-users@listserver.u2ug.org
> Subject: [U2] uv - mkdbfile [not-secure]
> Date: Thu, 24 Jul 2008 12:02:21 -0400
> 
> 
> UV 10.2.2, Solaris 10:
> 
> Friends, I'm having a braincramp. I can not get the syntax for mkdbfile
> correct for the creation of a 64bit file. I have tried:
> 
> mkdbfile /path/to/file 30 1009 4 21 50 80 1638 64bit
> mkdbfile /path/to/file 30 1009 4 21 50 80 1638 -64bit
> mkdbfile 64bit /path/to/file 30 1009 4 21 50 80 1638
> mkdbfile -64bit /path/to/file 30 1009 4 21 50 80 1638
> 
> Any ideas?
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] static/dynamic file(s) opinions wanted!

2008-07-24 Thread Ray Wurlod
This is the first time I have encountered a restriction on using CONCURRENT on 
Type 30 files.

It comes as quite a surprise, because 24x7 sites like the Ambulance Service 
need it.

I suspect that the error on USING is a subsequent error from the first one.  
You should always be able to specify an alternative file system, against the 
possibility that there's not enough space on the current file system for the 
second copy of the file.

Would be interested to hear what IBM support has to say on this.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] static/dynamic file(s) opinions wanted!

2008-07-24 Thread JPB-U2UG

Tom, The point is that it doesn't work with dynamic files.
David, I don't really think you need to resize dynamic files because they 
are always resizing themselves, unless they are not changing size. This type 
of resizing is equivalent to defragging on a windows system. Since dynamic 
files resize every time they split then it is not necessary.


Jerry

--
From: "Tom Dodds" <[EMAIL PROTECTED]>
Sent: Thursday, July 24, 2008 7:52 PM
To: 
Subject: RE: [U2] static/dynamic file(s) opinions wanted!


From the help item on Concurrent


CONCURRENT

_


  Use in a RESIZE command to permit other users  to  access  the
  file  while  it  is  being resized. To let other users use the
  file PAYABLES while it is being resized, enter the following:

 >RESIZE PAYABLES 4 3 2 CONCURRENT


Tom Dodds
[EMAIL PROTECTED]
630.235.2975

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Norman, David
(SAAS)
Sent: Thursday, July 24, 2008 4:55 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] static/dynamic file(s) opinions wanted!

Ray earlier suggested using RESIZE * * * CONCURRENT for a Dynamic file.
On 10.0.16 this results in the error "Concurrent Resize of type 1, 19,
25, or 30 is not allowed."
Adding the "USING" parameter suggested by Ray results in an "Invalid
Option" error.
If I want to resize a Dynamic file to reclaim unused space after
deleting records, do I have to stop access to this file for the duration
? We run a 24x7 operation and stopping access to files is generally not
possible.
Do I have any other options for cleaning up Dynamic files while they are
in use ??

Thanks,

David Norman
Senior Software Engineer - SA Ambulance Service

ICT Services
SA Health
Government of South Australia

Box 3, GPO
Adelaide, South Australia 5001
*+61 8 8274 0384
* fax +61 8 8271 4844
* [EMAIL PROTECTED]

This e-mail may contain confidential information, which also may be
legally privileged. Only the intended recipient(s) may access, use,
distribute or copy this e-mail. If this e-mail is received in error,
please inform the sender by return e-mail and delete the original. If
there are doubts about the validity of this message, please contact the
sender by telephone. It is the recipient's responsibility to check the
e-mail and any attached files for viruses.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

__ Information from ESET NOD32 Antivirus, version of virus 
signature

database 3296 (20080724) __

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] static/dynamic file(s) opinions wanted!

2008-07-24 Thread Tom Dodds
>From the help item on Concurrent


CONCURRENT

_


   Use in a RESIZE command to permit other users  to  access  the
   file  while  it  is  being resized. To let other users use the
   file PAYABLES while it is being resized, enter the following:

  >RESIZE PAYABLES 4 3 2 CONCURRENT


Tom Dodds
[EMAIL PROTECTED]
630.235.2975

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Norman, David
(SAAS)
Sent: Thursday, July 24, 2008 4:55 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] static/dynamic file(s) opinions wanted!

Ray earlier suggested using RESIZE * * * CONCURRENT for a Dynamic file.
On 10.0.16 this results in the error "Concurrent Resize of type 1, 19,
25, or 30 is not allowed."
Adding the "USING" parameter suggested by Ray results in an "Invalid
Option" error.
If I want to resize a Dynamic file to reclaim unused space after
deleting records, do I have to stop access to this file for the duration
? We run a 24x7 operation and stopping access to files is generally not
possible.
Do I have any other options for cleaning up Dynamic files while they are
in use ??

Thanks,

David Norman
Senior Software Engineer - SA Ambulance Service

ICT Services
SA Health
Government of South Australia

Box 3, GPO
Adelaide, South Australia 5001
*+61 8 8274 0384
* fax +61 8 8271 4844
* [EMAIL PROTECTED]

This e-mail may contain confidential information, which also may be
legally privileged. Only the intended recipient(s) may access, use,
distribute or copy this e-mail. If this e-mail is received in error,
please inform the sender by return e-mail and delete the original. If
there are doubts about the validity of this message, please contact the
sender by telephone. It is the recipient's responsibility to check the
e-mail and any attached files for viruses.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

__ Information from ESET NOD32 Antivirus, version of virus signature
database 3296 (20080724) __

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] static/dynamic file(s) opinions wanted!

2008-07-24 Thread Norman, David (SAAS)
Ray earlier suggested using RESIZE * * * CONCURRENT for a Dynamic file.
On 10.0.16 this results in the error "Concurrent Resize of type 1, 19,
25, or 30 is not allowed."
Adding the "USING" parameter suggested by Ray results in an "Invalid
Option" error.
If I want to resize a Dynamic file to reclaim unused space after
deleting records, do I have to stop access to this file for the duration
? We run a 24x7 operation and stopping access to files is generally not
possible.
Do I have any other options for cleaning up Dynamic files while they are
in use ??

Thanks,

David Norman
Senior Software Engineer - SA Ambulance Service

ICT Services
SA Health
Government of South Australia

Box 3, GPO
Adelaide, South Australia 5001
*+61 8 8274 0384
* fax +61 8 8271 4844
* [EMAIL PROTECTED]

This e-mail may contain confidential information, which also may be
legally privileged. Only the intended recipient(s) may access, use,
distribute or copy this e-mail. If this e-mail is received in error,
please inform the sender by return e-mail and delete the original. If
there are doubts about the validity of this message, please contact the
sender by telephone. It is the recipient's responsibility to check the
e-mail and any attached files for viruses.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Opinions Wanted !

2008-07-24 Thread Allen E. Elwood
And don't forget

6. Do you have energy saving light circuits that sense the presence and
absence of people and turn on or off automatically?

7. How many programmers drive a prius instead of a mustang (like mine) ?

8. Consumption of alcohol means it has to be brewed.  Brewing it creates
massive amounts of CO2, therefore all members of the organization should be
enrolled in AA.  Just think, all of us could at least do that NOW to stop
global warming!

9. No one needed A/C 200 years ago; you should turn them off now and leave
them off.  Especially if you're in Arizona.  What's a couple of trips to the
hospital a year compared to saving the planet?!!

10. Refrigerators.  Total waste of energy.  Everyone should just switch to
canned products.

I go now to purify my spirit while I listen to music on my 675 watt per
channel PA system with four 15 inch JBL's

;-)

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill
Sent: Thursday, July 24, 2008 14:08

I am glad the product is "green" but also...

1. Do all the programmers use flat panel monitors, not energy-hogging crts?
2. What are the PC power settings there?
3. Is the code written without regard for race, creed, color, gender, or
se...?
4. Are the objects there created by vegetarians for vegetarians?
5. Have software testers there been purified by the spring waters of
spiritual holistics?

All other factors being unequal, these are the characteristics that I look
for before wooing my leaders for that elusive "green light"... leading to
placing a purchase.

--Bill

*--

  We are a "green" software product.
1) Software is only downloadable via our web site.
2) The software has not paper output, everything is displayed in
Eclipse.
3) Our documentation is in PDF or Word format.
4) Payment for our software is Pay Pal which is paperless.
---
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] static/dynamic file(s) opinions wanted!

2008-07-24 Thread Jeff Fitzgerald
Gee, with all that, shouldn't the [ad] flag be in uppercase, underlined
and bolded?

Perhaps HTH will download your stuff and post a review.  I think you
should address him formally as Mr. Helps, though.  Later, when you are
friends you could use his first name, Hope.

;-)

Jeff Fitzgerald
Fitzgerald & Long, Inc.
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of daverch
Sent: Thursday, July 24, 2008 1:10 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] static/dynamic file(s) opinions wanted!

[ad]
Hi HTH,

U2logic has created a resize plug-in for Eclipse IDE that surpasses
their functionality.  We do not 
<...snip...>

[/ad]

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2008 10:25 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] static/dynamic file(s) opinions wanted!

Hi Doug,

In addition to the great info from this group (like Dan provides), this
site http://www.fitzlong.com/ provides great insight into U2 files.  You
should take some time to read the papers that they've provided.  Also,
they have an incredible product called "fast" that can really help you
eliminate a lot of the maintenance headaches and increase your system
performance.

HTH
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Opinions Wanted !

2008-07-24 Thread Brutzman, Bill
I am glad the product is "green" but also...

1. Do all the programmers use flat panel monitors, not energy-hogging crts?
2. What are the PC power settings there?
3. Is the code written without regard for race, creed, color, gender, or
se...?
4. Are the objects there created by vegetarians for vegetarians?
5. Have software testers there been purified by the spring waters of
spiritual holistics?

All other factors being unequal, these are the characteristics that I look
for before wooing my leaders for that elusive "green light"... leading to
placing a purchase.

--Bill

*--

  We are a "green" software product.
1) Software is only downloadable via our web site.
2) The software has not paper output, everything is displayed in
Eclipse.
3) Our documentation is in PDF or Word format.
4) Payment for our software is Pay Pal which is paperless.  
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] CAPTURING TOXML

2008-07-24 Thread Charles_Shaffer
Hello.  I've been building and returning some simple pages from Unidata to 
PHP, but I now have a big complex report to adapt.  Is there someway that 
I can take advantage of the TOXML verb by CAPTURING the XML and returning 
it to the calling PHP?

I tried something like this.

ECMD = "SELECT   TOXML"
EXECUTE ECMD CAPTURING RESULT  (where RESULT is returned to the calling 
PHP program.but got the error message:
protocol error: , Invalid document end at col 32. Check the back end log 
for details.

I suspect this is due to the marks separating the dynamic array elements. 
Will something like this work, or am I barking up the wrong tree?

And where is the backend log?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] English phrases

2008-07-24 Thread Oaks, Harold
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] static/dynamic file(s) opinions wanted!

2008-07-24 Thread daverch
[ad]
Hi HTH,

U2logic has created a resize plug-in for Eclipse IDE that surpasses their
functionality.  We do not need any downloaded programs, directories or data
files to run.  We do not license the product by CPU or number of Universe or
Unidata users.  We license XLr8 Resizer by your individual workstation.  We
use standard Universe and Unidata utilities to resize you files.  XLr8
Resizer is was built on current technology (Eclipse 3.3 or 3.4 and Java VM
1.6).  If you want to stick with something that was developed many years
ago, looks outdated, and is very pricey, then stay where you are.
Otherwise, go with the leader in U2 tools based on Eclipse technology:
U2logic.

  We are a "green" software product.
1) Software is only downloadable via our web site.
2) The software has not paper output, everything is displayed in
Eclipse.
3) Our documentation is in PDF or Word format.
4) Payment for our software is Pay Pal which is paperless.  

We would recommend that you download our package and see the differences.
Or at the very least, read our product information on our web site at
www.u2logic.com

Regards,
Doug

BTW:  Our other plug-in's for the U2 environment are an editor, a dictionary
editor, an installer, an object editor, and a Web Developer.
[/ad]

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2008 10:25 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] static/dynamic file(s) opinions wanted!

Hi Doug,

In addition to the great info from this group (like Dan provides), this site
http://www.fitzlong.com/ provides great insight into U2 files.  You should
take some time to read the papers that they've provided.  Also, they have an
incredible product called "fast" that can really help you eliminate a lot of
the maintenance headaches and increase your system performance.

HTH


-- Original message --
From: "Doug Chanco" <[EMAIL PROTECTED]> 

> Dan thanks a million this is incredibly helpful! 
> 
> Dougc
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] RE: English phrases

2008-07-24 Thread IT-Laure Hansen
You can use the underscore at the end of attributes 2 to 9 to indicate 
continuation on Universe.

Laure Hansen,
City of Redwood City - Information Technology
1017 Middlefield Road - Redwood City, CA 94063
Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204
[EMAIL PROTECTED]

o Please think green before printing this e-mail

Subscribe to receive Redwood City E-News, news releases, 
or other documents via email: Click here to register/subscribe

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boyd Parks
Sent: Thursday, July 24, 2008 10:34 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] RE: English phrases

Sorry to bother - I have found that on Universe , all the definitions have to 
be listed on attribute 2 instead of being in subsequent attributes as we can do 
on our jBASE system.

Boyd

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boyd Parks
Sent: Thursday, July 24, 2008 12:21 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] English phrases

I am trying to use the same phrase in Universe as I use in jBASE, but it is
not working properly on our Universe systems.

The beginning of my definitions on both jBASE and Universe look like this:

>ED DICT DH CA.ATTRS
DICT DH CA.ATTRS (BACS)
Top
.P

001 PH
002 PHONE-CHECK
003 COLL.SCORE
004 CA.AVAILCR
005 SSN.DECEASED
006 SSN.DOD
007 292
008 CA.BK7
009 CA.BK11
010 CA.BK13

The problem with the phrase is that it only lists the first definition in the
phrase.  I just tested by
removing PHONE-CHECK (it is a Basic subroutine call, whereas all the others
are normal, local
definitions), but that is not the issue.  Here is the output:

LIST DH "6793700" CA.ATTRS 10:36:09am  18 Jul 2008  PAGE1
DEBHIST... COLLECTABILITY

6793700   592

1 records listed.
>
Many more attributes should have been listed.

Any ideas?


Boyd Parks
HOV Services
CUBS Software Engineering
O: 678-229-5002
C: 770-975-3303
Any technology distinguishable from magic is insufficiently advanced.
--Larry Niven's Corollary to Clarke's 3rd Law.

[cid:image001.jpg@01C8ED87.ACA82E10]
The information contained in this message, including any attachments, is
privileged and/or confidential information intended only for the use of the
individual or entity named as addressee. The review, dissemination,
distribution, or copying of this communication by or to anyone other than the
intended addressee is strictly prohibited. If you have received this
communication in error, please immediately notify the sender by replying to
the message and destroy all copies of the original message








The information contained in this message, including any attachments, is
attorney privileged and/or confidential information intended only for the use
of the individual or entity named as addressee. The review, dissemination,
distribution or copying of this communication by or to anyone other than the
intended addressee is strictly prohibited. If you have received this
communication in error, please immediately notify the sender by replying to
the message and destroy all copies of the original message.

[demime 1.01d removed an attachment of type image/jpeg which had a name of 
image001.jpg]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

The information contained in this message, including any attachments, is 
attorney privileged and/or confidential information intended only for the use 
of the individual or entity named as addressee.  The review, dissemination, 
distribution or copying of this communication by or to anyone other than the 
intended addressee is strictly prohibited.  If you have received this 
communication in error, please immediately notify the sender by replying to the 
message and destroy all copies of the original message.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] English phrases

2008-07-24 Thread Larry Hiscock
Try joining all of the attributes on the same line (line 002), like thus:

001 PH
002 PHONE-CHECK COLL.SCORE CA.AVAILCR SSN.DECEASED SSN.DOD 292 CA.BK7
CA.BK11 CA.BK13

Larry Hiscock
Western Computer Services

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Boyd Parks
Sent: Thursday, July 24, 2008 9:21 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] English phrases

I am trying to use the same phrase in Universe as I use in jBASE, but it is
not working properly on our Universe systems.

The beginning of my definitions on both jBASE and Universe look like this:

>ED DICT DH CA.ATTRS
DICT DH CA.ATTRS (BACS)
Top
.P

001 PH
002 PHONE-CHECK
003 COLL.SCORE
004 CA.AVAILCR
005 SSN.DECEASED
006 SSN.DOD
007 292
008 CA.BK7
009 CA.BK11
010 CA.BK13

The problem with the phrase is that it only lists the first definition in
the
phrase.  I just tested by
removing PHONE-CHECK (it is a Basic subroutine call, whereas all the others
are normal, local
definitions), but that is not the issue.  Here is the output:

LIST DH "6793700" CA.ATTRS 10:36:09am  18 Jul 2008  PAGE1
DEBHIST... COLLECTABILITY

6793700   592

1 records listed.
>
Many more attributes should have been listed.

Any ideas?


Boyd Parks
HOV Services
CUBS Software Engineering
O: 678-229-5002
C: 770-975-3303
Any technology distinguishable from magic is insufficiently advanced.
--Larry Niven's Corollary to Clarke's 3rd Law.

[cid:image001.jpg@01C8ED87.ACA82E10]
The information contained in this message, including any attachments, is
privileged and/or confidential information intended only for the use of the
individual or entity named as addressee. The review, dissemination,
distribution, or copying of this communication by or to anyone other than
the
intended addressee is strictly prohibited. If you have received this
communication in error, please immediately notify the sender by replying to
the message and destroy all copies of the original message








The information contained in this message, including any attachments, is
attorney privileged and/or confidential information intended only for the
use
of the individual or entity named as addressee. The review, dissemination,
distribution or copying of this communication by or to anyone other than the
intended addressee is strictly prohibited. If you have received this
communication in error, please immediately notify the sender by replying to
the message and destroy all copies of the original message.

[demime 1.01d removed an attachment of type image/jpeg which had a name of
image001.jpg]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] English phrases

2008-07-24 Thread Allen Egerton

Boyd Parks wrote:

I am trying to use the same phrase in Universe as I use in jBASE, but it is
not working properly on our Universe systems.

The beginning of my definitions on both jBASE and Universe look like this:


ED DICT DH CA.ATTRS

DICT DH CA.ATTRS (BACS)
Top
.P

001 PH
002 PHONE-CHECK
003 COLL.SCORE
004 CA.AVAILCR
005 SSN.DECEASED
006 SSN.DOD
007 292
008 CA.BK7
009 CA.BK11
010 CA.BK13

The problem with the phrase is that it only lists the first definition in the
phrase.  I just tested by
removing PHONE-CHECK (it is a Basic subroutine call, whereas all the others
are normal, local
definitions), but that is not the issue.  Here is the output:

LIST DH "6793700" CA.ATTRS 10:36:09am  18 Jul 2008  PAGE1
DEBHIST... COLLECTABILITY

6793700   592

1 records listed.
Many more attributes should have been listed.

Any ideas?


Sure.  Replace your FieldMarks with Spaces.

So, your dict item would look like:
<1> PH
<2> PHONE-CHECK COLL.SCORE CA.AVAILCR SSN.DECEASED SSN.DOD 292 CA.BK7 
CA.BK11 CA.BK13



--
Allen Egerton
aegerton at pobox dot com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] English phrases

2008-07-24 Thread Martin Phillips

Hi,

You need at add an underscore to the end of lines 2 to 9 to show that the 
phrase continues below.



Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200 
---

u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] English phrases

2008-07-24 Thread Richard A. Wilson

everything in field2 seperated by spaces should do it
PH
F1 F2 F3 F4 etc

Rich
Boyd Parks wrote:

I am trying to use the same phrase in Universe as I use in jBASE, but it is
not working properly on our Universe systems.

The beginning of my definitions on both jBASE and Universe look like this:


ED DICT DH CA.ATTRS

DICT DH CA.ATTRS (BACS)
Top
.P

001 PH
002 PHONE-CHECK
003 COLL.SCORE
004 CA.AVAILCR
005 SSN.DECEASED
006 SSN.DOD
007 292
008 CA.BK7
009 CA.BK11
010 CA.BK13

The problem with the phrase is that it only lists the first definition in the
phrase.  I just tested by
removing PHONE-CHECK (it is a Basic subroutine call, whereas all the others
are normal, local
definitions), but that is not the issue.  Here is the output:

LIST DH "6793700" CA.ATTRS 10:36:09am  18 Jul 2008  PAGE1
DEBHIST... COLLECTABILITY

6793700   592

1 records listed.
Many more attributes should have been listed.

Any ideas?


Boyd Parks
HOV Services
CUBS Software Engineering
O: 678-229-5002
C: 770-975-3303
Any technology distinguishable from magic is insufficiently advanced.
--Larry Niven's Corollary to Clarke's 3rd Law.

[cid:image001.jpg@01C8ED87.ACA82E10]
The information contained in this message, including any attachments, is
privileged and/or confidential information intended only for the use of the
individual or entity named as addressee. The review, dissemination,
distribution, or copying of this communication by or to anyone other than the
intended addressee is strictly prohibited. If you have received this
communication in error, please immediately notify the sender by replying to
the message and destroy all copies of the original message








The information contained in this message, including any attachments, is
attorney privileged and/or confidential information intended only for the use
of the individual or entity named as addressee. The review, dissemination,
distribution or copying of this communication by or to anyone other than the
intended addressee is strictly prohibited. If you have received this
communication in error, please immediately notify the sender by replying to
the message and destroy all copies of the original message.

[demime 1.01d removed an attachment of type image/jpeg which had a name of 
image001.jpg]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/




--
Richard A. Wilson
Lakeside Systems
Smithfield, RI, USA
Voice 401-231-3959
Fax   206-202-2064
[EMAIL PROTECTED]
www.lakeside-systems.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] RE: English phrases

2008-07-24 Thread Boyd Parks
Sorry to bother - I have found that on Universe , all the definitions have to 
be listed on attribute 2 instead of being in subsequent attributes as we can do 
on our jBASE system.

Boyd

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boyd Parks
Sent: Thursday, July 24, 2008 12:21 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] English phrases

I am trying to use the same phrase in Universe as I use in jBASE, but it is
not working properly on our Universe systems.

The beginning of my definitions on both jBASE and Universe look like this:

>ED DICT DH CA.ATTRS
DICT DH CA.ATTRS (BACS)
Top
.P

001 PH
002 PHONE-CHECK
003 COLL.SCORE
004 CA.AVAILCR
005 SSN.DECEASED
006 SSN.DOD
007 292
008 CA.BK7
009 CA.BK11
010 CA.BK13

The problem with the phrase is that it only lists the first definition in the
phrase.  I just tested by
removing PHONE-CHECK (it is a Basic subroutine call, whereas all the others
are normal, local
definitions), but that is not the issue.  Here is the output:

LIST DH "6793700" CA.ATTRS 10:36:09am  18 Jul 2008  PAGE1
DEBHIST... COLLECTABILITY

6793700   592

1 records listed.
>
Many more attributes should have been listed.

Any ideas?


Boyd Parks
HOV Services
CUBS Software Engineering
O: 678-229-5002
C: 770-975-3303
Any technology distinguishable from magic is insufficiently advanced.
--Larry Niven's Corollary to Clarke's 3rd Law.

[cid:image001.jpg@01C8ED87.ACA82E10]
The information contained in this message, including any attachments, is
privileged and/or confidential information intended only for the use of the
individual or entity named as addressee. The review, dissemination,
distribution, or copying of this communication by or to anyone other than the
intended addressee is strictly prohibited. If you have received this
communication in error, please immediately notify the sender by replying to
the message and destroy all copies of the original message








The information contained in this message, including any attachments, is
attorney privileged and/or confidential information intended only for the use
of the individual or entity named as addressee. The review, dissemination,
distribution or copying of this communication by or to anyone other than the
intended addressee is strictly prohibited. If you have received this
communication in error, please immediately notify the sender by replying to
the message and destroy all copies of the original message.

[demime 1.01d removed an attachment of type image/jpeg which had a name of 
image001.jpg]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

The information contained in this message, including any attachments, is 
attorney privileged and/or confidential information intended only for the use 
of the individual or entity named as addressee.  The review, dissemination, 
distribution or copying of this communication by or to anyone other than the 
intended addressee is strictly prohibited.  If you have received this 
communication in error, please immediately notify the sender by replying to the 
message and destroy all copies of the original message.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] English phrases

2008-07-24 Thread u2ug
List all items on line 2 - space delimited

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Boyd Parks
Sent: July 24, 2008 12:21 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] English phrases

I am trying to use the same phrase in Universe as I use in jBASE, but it
is
not working properly on our Universe systems.

The beginning of my definitions on both jBASE and Universe look like
this:

>ED DICT DH CA.ATTRS
DICT DH CA.ATTRS (BACS)
Top
.P

001 PH
002 PHONE-CHECK
003 COLL.SCORE
004 CA.AVAILCR
005 SSN.DECEASED
006 SSN.DOD
007 292
008 CA.BK7
009 CA.BK11
010 CA.BK13

The problem with the phrase is that it only lists the first definition
in the
phrase.  I just tested by
removing PHONE-CHECK (it is a Basic subroutine call, whereas all the
others
are normal, local
definitions), but that is not the issue.  Here is the output:

LIST DH "6793700" CA.ATTRS 10:36:09am  18 Jul 2008  PAGE1
DEBHIST... COLLECTABILITY

6793700   592

1 records listed.
>
Many more attributes should have been listed.

Any ideas?


Boyd Parks
HOV Services
CUBS Software Engineering
O: 678-229-5002
C: 770-975-3303
Any technology distinguishable from magic is insufficiently advanced.
--Larry Niven's Corollary to Clarke's 3rd Law.

[cid:image001.jpg@01C8ED87.ACA82E10]
The information contained in this message, including any attachments, is
privileged and/or confidential information intended only for the use of
the
individual or entity named as addressee. The review, dissemination,
distribution, or copying of this communication by or to anyone other
than the
intended addressee is strictly prohibited. If you have received this
communication in error, please immediately notify the sender by replying
to
the message and destroy all copies of the original message








The information contained in this message, including any attachments, is
attorney privileged and/or confidential information intended only for
the use
of the individual or entity named as addressee. The review,
dissemination,
distribution or copying of this communication by or to anyone other than
the
intended addressee is strictly prohibited. If you have received this
communication in error, please immediately notify the sender by replying
to
the message and destroy all copies of the original message.

[demime 1.01d removed an attachment of type image/jpeg which had a name
of image001.jpg]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] English phrases

2008-07-24 Thread roy
I always list all of the attributes on line 1 separated by spaces.

Try 001 PH
002 PHONE-CHECK COL.SCORE ...etc

Roy

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Boyd Parks
Sent: Thursday, July 24, 2008 12:21 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] English phrases

I am trying to use the same phrase in Universe as I use in jBASE, but it is
not working properly on our Universe systems.

The beginning of my definitions on both jBASE and Universe look like this:

>ED DICT DH CA.ATTRS
DICT DH CA.ATTRS (BACS)
Top
.P

001 PH
002 PHONE-CHECK
003 COLL.SCORE
004 CA.AVAILCR
005 SSN.DECEASED
006 SSN.DOD
007 292
008 CA.BK7
009 CA.BK11
010 CA.BK13

The problem with the phrase is that it only lists the first definition in
the
phrase.  I just tested by
removing PHONE-CHECK (it is a Basic subroutine call, whereas all the others
are normal, local
definitions), but that is not the issue.  Here is the output:

LIST DH "6793700" CA.ATTRS 10:36:09am  18 Jul 2008  PAGE1
DEBHIST... COLLECTABILITY

6793700   592

1 records listed.
>
Many more attributes should have been listed.

Any ideas?


Boyd Parks
HOV Services
CUBS Software Engineering
O: 678-229-5002
C: 770-975-3303
Any technology distinguishable from magic is insufficiently advanced.
--Larry Niven's Corollary to Clarke's 3rd Law.

[cid:image001.jpg@01C8ED87.ACA82E10]
The information contained in this message, including any attachments, is
privileged and/or confidential information intended only for the use of the
individual or entity named as addressee. The review, dissemination,
distribution, or copying of this communication by or to anyone other than
the
intended addressee is strictly prohibited. If you have received this
communication in error, please immediately notify the sender by replying to
the message and destroy all copies of the original message








The information contained in this message, including any attachments, is
attorney privileged and/or confidential information intended only for the
use
of the individual or entity named as addressee. The review, dissemination,
distribution or copying of this communication by or to anyone other than the
intended addressee is strictly prohibited. If you have received this
communication in error, please immediately notify the sender by replying to
the message and destroy all copies of the original message.

[demime 1.01d removed an attachment of type image/jpeg which had a name of
image001.jpg]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


FW: [U2] English phrases

2008-07-24 Thread roy
Line 2 sorry !


-Original Message-
From: roy [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 24, 2008 1:16 PM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] English phrases

I always list all of the attributes on line 1 separated by spaces.

Try 001 PH
002 PHONE-CHECK COL.SCORE ...etc

Roy

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Boyd Parks
Sent: Thursday, July 24, 2008 12:21 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] English phrases

I am trying to use the same phrase in Universe as I use in jBASE, but it is
not working properly on our Universe systems.

The beginning of my definitions on both jBASE and Universe look like this:

>ED DICT DH CA.ATTRS
DICT DH CA.ATTRS (BACS)
Top
.P

001 PH
002 PHONE-CHECK
003 COLL.SCORE
004 CA.AVAILCR
005 SSN.DECEASED
006 SSN.DOD
007 292
008 CA.BK7
009 CA.BK11
010 CA.BK13

The problem with the phrase is that it only lists the first definition in
the
phrase.  I just tested by
removing PHONE-CHECK (it is a Basic subroutine call, whereas all the others
are normal, local
definitions), but that is not the issue.  Here is the output:

LIST DH "6793700" CA.ATTRS 10:36:09am  18 Jul 2008  PAGE1
DEBHIST... COLLECTABILITY

6793700   592

1 records listed.
>
Many more attributes should have been listed.

Any ideas?


Boyd Parks
HOV Services
CUBS Software Engineering
O: 678-229-5002
C: 770-975-3303
Any technology distinguishable from magic is insufficiently advanced.
--Larry Niven's Corollary to Clarke's 3rd Law.

[cid:image001.jpg@01C8ED87.ACA82E10]
The information contained in this message, including any attachments, is
privileged and/or confidential information intended only for the use of the
individual or entity named as addressee. The review, dissemination,
distribution, or copying of this communication by or to anyone other than
the
intended addressee is strictly prohibited. If you have received this
communication in error, please immediately notify the sender by replying to
the message and destroy all copies of the original message








The information contained in this message, including any attachments, is
attorney privileged and/or confidential information intended only for the
use
of the individual or entity named as addressee. The review, dissemination,
distribution or copying of this communication by or to anyone other than the
intended addressee is strictly prohibited. If you have received this
communication in error, please immediately notify the sender by replying to
the message and destroy all copies of the original message.

[demime 1.01d removed an attachment of type image/jpeg which had a name of
image001.jpg]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Basic SORT() Function not avail in UniVerse?

2008-07-24 Thread Dave Laansma
My apologies.  I am on Unidata.

David Laansma
IT Manager
Hubbard Supply Co. 
Direct: 810-342-7143
Office:810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
"Delivering Products, Services, and Innovative Solutions"


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dianne Ackerman
Sent: Thursday, July 24, 2008 11:39 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Basic SORT() Function not avail in UniVerse?

I don't seem to have SORT.LIST on UV 10.1.14.  Is it on a later version?
-Dianne

Dave Laansma wrote:

>I think I like this one better than the Unix sort.  It is really quick
>too.  However I'd suggest using the SORT.LIST instead of the
>GET.LIST/MERGE.LIST:
>
>   SUBROUTINE HUB.SORT.C (ITAB)
>
>   SORT.KEY= "tmpsortfile"
>   SORT.KEY<2> = @UID
>   SORT.KEY<3> = @USERNO
>   SORT.KEY<4> = TIME()
>   SWAP @AM WITH "_" IN SORT.KEY
>
>   WRITELIST ITAB ON SORT.KEY
>
>   CMD = "SORT.LIST ":SORT.KEY
>   EXECUTE CMD CAPTURING MSG RETURNING ERR
>
>   READLIST ITAB FROM SORT.KEY ELSE ITAB = ""
>
> 
>
>   RETURN
>
>   END
>
>David Laansma
>IT Manager
>Hubbard Supply Co. 
>Direct: 810-342-7143
>Office:810-234-8681
>Fax: 810-234-6142
>www.hubbardsupply.com
>"Delivering Products, Services, and Innovative Solutions"
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] static/dynamic file(s) opinions wanted!

2008-07-24 Thread Brian Leach
All

I've missed the start of this thread, so apologies to all if this has been 
mentioned before.

On a 24x7 site, dynamic files should be the most useful (because there is no 
time available for resizing static files) but AFAIR beause the current load etc 
are held in shared memory, this prevents you simply pausing the database 
momentarily whilst splitting a mirror and then backing up that mirror. Unless 
of course the dbpause updates any open dynamic files with the the content of 
the shared memory stats before it exits (which would be sensible)... does 
anyone know whether it does?

Brian
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] English phrases

2008-07-24 Thread Boyd Parks
I am trying to use the same phrase in Universe as I use in jBASE, but it is
not working properly on our Universe systems.

The beginning of my definitions on both jBASE and Universe look like this:

>ED DICT DH CA.ATTRS
DICT DH CA.ATTRS (BACS)
Top
.P

001 PH
002 PHONE-CHECK
003 COLL.SCORE
004 CA.AVAILCR
005 SSN.DECEASED
006 SSN.DOD
007 292
008 CA.BK7
009 CA.BK11
010 CA.BK13

The problem with the phrase is that it only lists the first definition in the
phrase.  I just tested by
removing PHONE-CHECK (it is a Basic subroutine call, whereas all the others
are normal, local
definitions), but that is not the issue.  Here is the output:

LIST DH "6793700" CA.ATTRS 10:36:09am  18 Jul 2008  PAGE1
DEBHIST... COLLECTABILITY

6793700   592

1 records listed.
>
Many more attributes should have been listed.

Any ideas?


Boyd Parks
HOV Services
CUBS Software Engineering
O: 678-229-5002
C: 770-975-3303
Any technology distinguishable from magic is insufficiently advanced.
--Larry Niven's Corollary to Clarke's 3rd Law.

[cid:image001.jpg@01C8ED87.ACA82E10]
The information contained in this message, including any attachments, is
privileged and/or confidential information intended only for the use of the
individual or entity named as addressee. The review, dissemination,
distribution, or copying of this communication by or to anyone other than the
intended addressee is strictly prohibited. If you have received this
communication in error, please immediately notify the sender by replying to
the message and destroy all copies of the original message








The information contained in this message, including any attachments, is
attorney privileged and/or confidential information intended only for the use
of the individual or entity named as addressee. The review, dissemination,
distribution or copying of this communication by or to anyone other than the
intended addressee is strictly prohibited. If you have received this
communication in error, please immediately notify the sender by replying to
the message and destroy all copies of the original message.

[demime 1.01d removed an attachment of type image/jpeg which had a name of 
image001.jpg]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] uv - mkdbfile [not-secure]

2008-07-24 Thread Hennessey, Mark F.
UV 10.2.2, Solaris 10:

Friends, I'm having a braincramp. I can not get the syntax for mkdbfile
correct for the creation of a 64bit file. I have tried:

mkdbfile /path/to/file 30 1009 4 21 50 80 1638 64bit
mkdbfile /path/to/file 30 1009 4 21 50 80 1638 -64bit
mkdbfile 64bit /path/to/file 30 1009 4 21 50 80 1638 
mkdbfile -64bit /path/to/file 30 1009 4 21 50 80 1638

Any ideas?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Basic SORT() Function not avail in UniVerse?

2008-07-24 Thread Dianne Ackerman

I don't seem to have SORT.LIST on UV 10.1.14.  Is it on a later version?
-Dianne

Dave Laansma wrote:


I think I like this one better than the Unix sort.  It is really quick
too.  However I'd suggest using the SORT.LIST instead of the
GET.LIST/MERGE.LIST:

  SUBROUTINE HUB.SORT.C (ITAB)

  SORT.KEY= "tmpsortfile"
  SORT.KEY<2> = @UID
  SORT.KEY<3> = @USERNO
  SORT.KEY<4> = TIME()
  SWAP @AM WITH "_" IN SORT.KEY

  WRITELIST ITAB ON SORT.KEY

  CMD = "SORT.LIST ":SORT.KEY
  EXECUTE CMD CAPTURING MSG RETURNING ERR

  READLIST ITAB FROM SORT.KEY ELSE ITAB = ""



  RETURN

  END

David Laansma
IT Manager
Hubbard Supply Co. 
Direct: 810-342-7143

Office:810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
"Delivering Products, Services, and Innovative Solutions"

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Basic SORT() Function not avail in UniVerse?

2008-07-24 Thread Louie Bergsagel
That is a nifty idea if your values are all the same type.  It doesn't work
for 1-10:

>EDIT.LIST MYLIST
New record.

: I
0001= 2
0002= 1
0003= 3
0004= 5
0005= 10
0006= 7
0007= 6
0008= 4
0009= 9
0010= 8
0011=
Bottom at line 10.
: FILE
"MYLIST" filed in file "&SAVEDLISTS&".
>GET.LIST MYLIST

10 record(s) selected to SELECT list #0.
>>MERGE.LIST 0 UNION 0

10 record(s) selected to SELECT list #0.
>>SAVE.LIST MYLIST

10 record(s) SAVEd to SELECT list "MYLIST".
>EDIT.LIST MYLIST
10 lines long.

: P
0001: 1
0002: 10
0003: 2
0004: 3
0005: 4
0006: 5
0007: 6
0008: 7
0009: 8
0010: 9
Bottom at line 10.
: Q
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Basic SORT() Function not avail in UniVerse?

2008-07-24 Thread Dave Laansma
This is the best idea I've seen.  The simplicity is amazing.  The speed
is absolutely amazing.

David Laansma
IT Manager
Hubbard Supply Co. 
Direct: 810-342-7143
Office:810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
"Delivering Products, Services, and Innovative Solutions"

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Charlie Rubeor
Sent: Wednesday, July 23, 2008 4:41 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Basic SORT() Function not avail in UniVerse?

Before we had the SORT function, I wrote out the variable to a directory
and
used the *nix sort command.  I don't have the original program, but I
re-created it here as best I could.  I remember the program as being a
lot
more complicated then this, but here it is anyway.

SUBROUTINE SORT.STUFF(BIG.ARRAY,SORTED.ARRAY)
*
* Must have a temporary dir-type file
*
OPEN 'TEMPDIR' TO F.TEMPDIR ELSE STOP 201,'TEMPDIR'
TEMP.KEY = @USERNO:'*':@LEVEL
TEMP.PATH = FILEINFO(F.TEMPDIR,2):'/':TEMP.KEY
*
WRITE BIG.ARRAY ON F.TEMPDIR,TEMP.KEY
*
CMD = '!sort -o ':TEMP.PATH:' ':TEMP.PATH
EXECUTE CMD CAPTURING OUTPUT RETURNING ERROR.MESSAGE
*
READ SORTED.ARRAY FROM F.TEMPDIR,TEMP.KEY THEN
   DELETE F.TEMPDIR,TEMP.KEY
END ELSE
   PRINT;PRINT "Didn't work!"
END
RETURN

I only tested this once, it sorted a 1,000,000 line array in a couple of
seconds.

hth

- Original Message -
From: "Baker Hughes" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, July 22, 2008 10:50 AM
Subject: [U2] Basic SORT() Function not avail in UniVerse?


> Hey,
>
> I'm needing to SORT a dynamic array and apparently UniVerse doesn't
have
> this
> Function.
>
> Other MV implementations have this, such as D3 - "The sort() function
> sorts an
> attribute or value mark delimited str.exp in ascending order." [from
> ePick]
>
> There was also a user exit u1072 that did the same thing.
>
> Does anyone have a work around or fast path to same thing  maybe
I'm
> missing something but can't see this in UV docs.
>
> -Baker
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/

[demime 1.01d removed an attachment of type application/pgp-signature
which had a name of PGP.sig]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Basic SORT() Function not avail in UniVerse?

2008-07-24 Thread Dave Laansma
I think I like this one better than the Unix sort.  It is really quick
too.  However I'd suggest using the SORT.LIST instead of the
GET.LIST/MERGE.LIST:

   SUBROUTINE HUB.SORT.C (ITAB)

   SORT.KEY= "tmpsortfile"
   SORT.KEY<2> = @UID
   SORT.KEY<3> = @USERNO
   SORT.KEY<4> = TIME()
   SWAP @AM WITH "_" IN SORT.KEY

   WRITELIST ITAB ON SORT.KEY

   CMD = "SORT.LIST ":SORT.KEY
   EXECUTE CMD CAPTURING MSG RETURNING ERR

   READLIST ITAB FROM SORT.KEY ELSE ITAB = ""

 

   RETURN

   END

David Laansma
IT Manager
Hubbard Supply Co. 
Direct: 810-342-7143
Office:810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
"Delivering Products, Services, and Innovative Solutions"


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rex Gozar
Sent: Thursday, July 24, 2008 8:15 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Basic SORT() Function not avail in UniVerse?

And since no one has mentioned it yet, MERGE.LIST takes advantage of 
Universe's built-in (a.k.a "C") sorting ability.

SUBROUTINE SORT.ITEM(ITEM)
WRITELIST ITEM ON "MYLIST"
STMT = ""
STMT<-1> = "GET.LIST MYLIST"
STMT<-1> = "MERGE.LIST 0 UNION 0"
STMT<-1> = "SAVE.LIST MYLIST"
READLIST ITEM FROM "MYLIST" ELSE ABORTM "IMPOSSIBLE!"
DELETELIST "MYLIST"
RETURN
END

Of course, this still adds the i/o overhead of reading and writing, but 
is still faster than LOCATE's on 1000+ element items.

"[Another] aspect is that a lot dynamic arrays in programs do more than
just hold keys..."  which is why I wrote ROW2COL and QUICKSORT as 
complimentary subroutines (both on PickWiki).  ROW2COL will flip 
associated multivalues "sideways" so QUICKSORT can sort and subsort on 
values in the corresponding "rows"; then I use ROW2COL to flip them 
back.  Ideally, Universe should provide similar built-in functionality.

rex
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] static/dynamic file(s) opinions wanted!

2008-07-24 Thread Jeff Fitzgerald
Thanks for mentioning our website - the collection of papers we've
written is found in the Support section of the website under the
Technical Papers topic.  Here's a direct link:

http://www.fitzlong.com/Technical%20Papers.htm

Glad you found the info useful.

Jeff Fitzgerald
Fitzgerald & Long, Inc.
www.fitzlong.com
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2008 10:25 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] static/dynamic file(s) opinions wanted!

Hi Doug,

In addition to the great info from this group (like Dan provides), this
site http://www.fitzlong.com/ provides great insight into U2 files.  You
should take some time to read the papers that they've provided.  Also,
they have an incredible product called "fast" that can really help you
eliminate a lot of the maintenance headaches and increase your system
performance.

HTH
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Basic SORT() Function not avail in UniVerse?

2008-07-24 Thread Rex Gozar
And since no one has mentioned it yet, MERGE.LIST takes advantage of 
Universe's built-in (a.k.a "C") sorting ability.


   SUBROUTINE SORT.ITEM(ITEM)
   WRITELIST ITEM ON "MYLIST"
   STMT = ""
   STMT<-1> = "GET.LIST MYLIST"
   STMT<-1> = "MERGE.LIST 0 UNION 0"
   STMT<-1> = "SAVE.LIST MYLIST"
   READLIST ITEM FROM "MYLIST" ELSE ABORTM "IMPOSSIBLE!"
   DELETELIST "MYLIST"
   RETURN
END

Of course, this still adds the i/o overhead of reading and writing, but 
is still faster than LOCATE's on 1000+ element items.


"[Another] aspect is that a lot dynamic arrays in programs do more than
just hold keys..."  which is why I wrote ROW2COL and QUICKSORT as 
complimentary subroutines (both on PickWiki).  ROW2COL will flip 
associated multivalues "sideways" so QUICKSORT can sort and subsort on 
values in the corresponding "rows"; then I use ROW2COL to flip them 
back.  Ideally, Universe should provide similar built-in functionality.


rex
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/