from:"Dave"

Uncomfortable with the portable part of pdf then?

We just move the file over to the windows client and run:

L:X -0START PDF Document /Dwindowsdirectory /WAIT filename.pdf

And they print from that.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce Conway - Bamac 
LTD
Sent: Thursday, April 04, 2013 11:54 AM
To: 'U2 Users List'
Subject: [U2] How do you print a .pdf from inside a Unix Box

I may have missed this discussion but if someone can help me that would be 
great.

We have been executing a SB command to windows to open Adobe and print the PDF 
document. We would like to either not have to open Adobe and print the document 
or print the document from within our Unix box.

We have a hp7640 11iv3 running on an Itanium processor.

Here is the Unidata information:
Module Name Version   Licensed

UniData RDBMS 7.2 Yes
Connection Pooling... 7.2 No
Device License... 7.2 No
NFA.. 7.2 No
RFS.. 7.2 No
EDA.. 7.2 No
721


Oh, love this list, I have been using Pick since 1985 and still going strong.

Bruce

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



Dave Davis
Team Lead, RD

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] How do you print a .pdf from inside a Unix Box

That's just the title that shows up at the top of the reader window.

You don't need to specify the Adobe path and Reader - windows will figure out 
what program is associated with the .pdf extension and run that - this is not 
necessarily Acrobat Reader but most likely will be if that's all that is 
installed.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce Conway - Bamac 
LTD
Sent: Thursday, April 04, 2013 1:45 PM
To: 'U2 Users List'
Subject: Re: [U2] How do you print a .pdf from inside a Unix Box

I like this - is the PDF Document portion of the command our Adobe path and 
Reader?



Bruce



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis
Sent: Thursday, April 04, 2013 12:24 PM
To: U2 Users List
Subject: Re: [U2] How do you print a .pdf from inside a Unix Box



Uncomfortable with the portable part of pdf then?



We just move the file over to the windows client and run:



L:X -0START PDF Document /Dwindowsdirectory /WAIT filename.pdf



And they print from that.



-Original Message-

From:  mailto:u2-users-boun...@listserver.u2ug.org
u2-users-boun...@listserver.u2ug.org [
mailto:u2-users-boun...@listserver.u2ug.org
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce Conway - Bamac 
LTD

Sent: Thursday, April 04, 2013 11:54 AM

To: 'U2 Users List'

Subject: [U2] How do you print a .pdf from inside a Unix Box



I may have missed this discussion but if someone can help me that would be 
great.



We have been executing a SB command to windows to open Adobe and print the PDF 
document. We would like to either not have to open Adobe and print the document 
or print the document from within our Unix box.



We have a hp7640 11iv3 running on an Itanium processor.



Here is the Unidata information:

Module Name Version   Licensed



UniData RDBMS 7.2 Yes

Connection Pooling... 7.2 No

Device License... 7.2 No

NFA.. 7.2 No

RFS.. 7.2 No

EDA.. 7.2 No

721





Oh, love this list, I have been using Pick since 1985 and still going strong.



Bruce



___

U2-Users mailing list

 mailto:U2-Users@listserver.u2ug.org U2-Users@listserver.u2ug.org

 http://listserver.u2ug.org/mailman/listinfo/u2-users
http://listserver.u2ug.org/mailman/listinfo/u2-users







Dave Davis

Team Lead, RD



P: 614-875-4910 x108

F: 614-875-4088

E:  mailto:dda...@harriscomputer.com dda...@harriscomputer.com

[http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg]



[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]
http://www.harriscomputer.com/ http://www.harriscomputer.com/

6110 Enterprise Parkway

Grove City, OH

43123


http://www.harris-schoolsolutions.com%3chttp:/www.harris-schoolsolutions.co
m www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com



This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.



___

U2-Users mailing list

 mailto:U2-Users@listserver.u2ug.org U2-Users@listserver.u2ug.org

 http://listserver.u2ug.org/mailman/listinfo/u2-users
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



Dave Davis
Team Lead, RD

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message

Re: [U2] How do you print a .pdf from inside a Unix Box

As long as the pdf extension has been linked to a reader program in windows, 
it should be opening up the document in the reader program automatically.

I have used the acrobat reader switch to automatically print before (bringing 
up the Windows printer dialog, I mean to say), but not with the start command 
- never had a good reason to, most people want to preview what they print 
anyway.  I did use it back when I called the acrobat reader program directly.  
I switched to start because that kept me from having to worry about where the 
reader program was located and what it was called - that gets changed a lot 
I've noticed.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce Conway - Bamac 
LTD
Sent: Thursday, April 04, 2013 2:15 PM
To: 'U2 Users List'
Subject: Re: [U2] How do you print a .pdf from inside a Unix Box

Oh Dave,

This just opens the window. I tried this and what it is doing is opening the 
windows folder and the user then double click on the document and print. I was 
looking for an automatic process to do the printing.

Bruce

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis
Sent: Thursday, April 04, 2013 12:24 PM
To: U2 Users List
Subject: Re: [U2] How do you print a .pdf from inside a Unix Box

Uncomfortable with the portable part of pdf then?

We just move the file over to the windows client and run:

L:X -0START PDF Document /Dwindowsdirectory /WAIT filename.pdf

And they print from that.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce Conway - Bamac 
LTD
Sent: Thursday, April 04, 2013 11:54 AM
To: 'U2 Users List'
Subject: [U2] How do you print a .pdf from inside a Unix Box

I may have missed this discussion but if someone can help me that would be 
great.

We have been executing a SB command to windows to open Adobe and print the PDF 
document. We would like to either not have to open Adobe and print the document 
or print the document from within our Unix box.

We have a hp7640 11iv3 running on an Itanium processor.

Here is the Unidata information:
Module Name Version   Licensed

UniData RDBMS 7.2 Yes
Connection Pooling... 7.2 No
Device License... 7.2 No
NFA.. 7.2 No
RFS.. 7.2 No
EDA.. 7.2 No
721


Oh, love this list, I have been using Pick since 1985 and still going strong.

Bruce

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



Dave Davis
Team Lead, RD

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http:
//www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.

___
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



Dave Davis
Team Lead, RD

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.

___
U2-Users

Re: [U2] How do you print a .pdf from inside a Unix Box

Interesting.

How long did it take to write a compliant reader?

We handle the problem in #8 with a Catalog entry in the PDF file.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Rasmussen
Sent: Thursday, April 04, 2013 4:32 PM
To: U2 Users List
Subject: Re: [U2] How do you print a .pdf from inside a Unix Box

Sometimes the hardest information to find is that what you want to do isn't 
possible. So let me tell you what is and what isn't possible, in printing PDFs 
in Windows.

1) You can OPEN a PDF based on its file extension.  From the command line, you 
can simply type type pathname of the PDF. From Windows Explorer, you can 
double-click. These use a system in Windows called file associations. 
Specifically here, you're using the OPEN verb. In the Windows registry there is 
a command associated with .PDF and open; typically it runs Adobe Reader. 
Once open, it is up to the user to print the file.

2) You can also execute the command string yourself, if you know what EXE to 
use. That is what you cited in a later email.

3) In Windows Explorer, you can also right-click on a PDF and select Print, 
to cause Windows to print the file on the default printer. This is using the 
print verb in the file association. Behind the scenes, this will run a 
command, typically running Adobe Reader with a /p parameter (for print).

4) There is NOT an equivalent way to do this from the command line.

5) You can create a shortcut to a specific printer on your desktop. Then you 
can drag a PDF to this shortcut, and it MAY print on this
(non-default) printer. This uses the less-documented printto verb in the 
system of file associations. Support in Reader for printing in this way has 
varied by version.

6) There is NOT an equivalent way to do this from the command line.

7) You MIGHT be able to invoke Reader with some command line parameters to 
cause it to print on a specific printer. Results may vary by version.

8) NONE of these will let you control various output options in Reader, such as 
whether the report should be shrunk to fit the printable page.

9) All of these assume that the PDF file to be printed exists on the Windows 
PC, or is accessible to it, such as via Samba. None will pull the file from an 
HTTP or FTP server.

Bottom line is that there is not a good and convenient way to do this using 
Windows commands.

However, we offer a solution, in the form of our Print Wizard product.
Consider the following command:
printwiz.exe http://somehost.com/somefile.pdf  /pMy laserjet printer
This will bring up printwiz.exe, which will fetch the PDF from the http server 
into memory (never being stored on the local disk), and print it to the 
specified printer. Printwiz is doing the PDF interpretation itself, it is not 
using any Adobe or other products.

There are a huge number of other options, such as shrink-to-fit, page range, 
multiple copies, password entry, preview, watermarking, form overlaying, and 
more.

See www.anzio.com for more details and a free demo.

On Thu, 4 Apr 2013, Bruce Conway - Bamac LTD wrote:

 I may have missed this discussion but if someone can help me that
 would be great.

 We have been executing a SB command to windows to open Adobe and print
 the PDF document. We would like to either not have to open Adobe and
 print the document or print the document from within our Unix box.

 We have a hp7640 11iv3 running on an Itanium processor.

 Here is the Unidata information:
Module Name Version   Licensed

 UniData RDBMS 7.2 Yes
 Connection Pooling... 7.2 No
 Device License... 7.2 No
 NFA.. 7.2 No
 RFS.. 7.2 No
 EDA.. 7.2 No
 721


 Oh, love this list, I have been using Pick since 1985 and still going
 strong.

 Bruce

 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users


Regards,
Bob Rasmussen,   President,   Rasmussen Software, Inc.

personal e-mail: r...@anzio.com
  company e-mail: r...@anzio.com
   voice: (US) 503-624-0360 (9:00-6:00 Pacific Time)
 fax: (US) 503-624-0760
 web: http://www.anzio.com
  street address: Rasmussen Software, Inc.
  10240 SW Nimbus, Suite L9
  Portland, OR  97223  USA 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



Dave Davis
Team Lead, RD

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris

Re: [U2] How do you print a .pdf from inside a Unix Box

With us - the issue was to keep it from defaulting to shrink to fit.

It wasn't important to make it always be one setting, just to get it 
defaulted the way I needed.

The users wouldn't typically know to change this to the appropriate value for 
themselves.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Rasmussen
Sent: Thursday, April 04, 2013 5:14 PM
To: U2 Users List
Subject: Re: [U2] How do you print a .pdf from inside a Unix Box

On Thu, 4 Apr 2013, Dave Davis wrote:

 Interesting.

 How long did it take to write a compliant reader?

It took YEARS. And I don't claim to be finished.

 We handle the problem in #8 with a Catalog entry in the PDF file.

I assume you're referring to the fit-to-page setting. But my understanding is 
that you can set the printing preferences to a) edge-to-edge, or b) default, 
which means to behave according to the reader's default setting.
There is NOT a way to set it to always shrink to fit. If I'm wrong, please 
provide specifics.


 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob
 Rasmussen
 Sent: Thursday, April 04, 2013 4:32 PM
 To: U2 Users List
 Subject: Re: [U2] How do you print a .pdf from inside a Unix Box

 Sometimes the hardest information to find is that what you want to do isn't 
 possible. So let me tell you what is and what isn't possible, in printing 
 PDFs in Windows.

 1) You can OPEN a PDF based on its file extension.  From the command line, 
 you can simply type type pathname of the PDF. From Windows Explorer, you can 
 double-click. These use a system in Windows called file associations. 
 Specifically here, you're using the OPEN verb. In the Windows registry there 
 is a command associated with .PDF and open; typically it runs Adobe 
 Reader. Once open, it is up to the user to print the file.

 2) You can also execute the command string yourself, if you know what EXE to 
 use. That is what you cited in a later email.

 3) In Windows Explorer, you can also right-click on a PDF and select Print, 
 to cause Windows to print the file on the default printer. This is using the 
 print verb in the file association. Behind the scenes, this will run a 
 command, typically running Adobe Reader with a /p parameter (for print).

 4) There is NOT an equivalent way to do this from the command line.

 5) You can create a shortcut to a specific printer on your desktop.
 Then you can drag a PDF to this shortcut, and it MAY print on this
 (non-default) printer. This uses the less-documented printto verb in the 
 system of file associations. Support in Reader for printing in this way has 
 varied by version.

 6) There is NOT an equivalent way to do this from the command line.

 7) You MIGHT be able to invoke Reader with some command line parameters to 
 cause it to print on a specific printer. Results may vary by version.

 8) NONE of these will let you control various output options in Reader, such 
 as whether the report should be shrunk to fit the printable page.

 9) All of these assume that the PDF file to be printed exists on the Windows 
 PC, or is accessible to it, such as via Samba. None will pull the file from 
 an HTTP or FTP server.

 Bottom line is that there is not a good and convenient way to do this using 
 Windows commands.

 However, we offer a solution, in the form of our Print Wizard product.
 Consider the following command:
printwiz.exe http://somehost.com/somefile.pdf  /pMy laserjet printer
 This will bring up printwiz.exe, which will fetch the PDF from the http 
 server into memory (never being stored on the local disk), and print it to 
 the specified printer. Printwiz is doing the PDF interpretation itself, it is 
 not using any Adobe or other products.

 There are a huge number of other options, such as shrink-to-fit, page range, 
 multiple copies, password entry, preview, watermarking, form overlaying, and 
 more.

 See www.anzio.com for more details and a free demo.

 On Thu, 4 Apr 2013, Bruce Conway - Bamac LTD wrote:

 I may have missed this discussion but if someone can help me that
 would be great.

 We have been executing a SB command to windows to open Adobe and
 print the PDF document. We would like to either not have to open
 Adobe and print the document or print the document from within our Unix box.

 We have a hp7640 11iv3 running on an Itanium processor.

 Here is the Unidata information:
Module Name Version   Licensed

 UniData RDBMS 7.2 Yes
 Connection Pooling... 7.2 No
 Device License... 7.2 No
 NFA.. 7.2 No
 RFS.. 7.2 No
 EDA.. 7.2 No
 721


 Oh, love this list, I have been using Pick since 1985 and still going
 strong.

 Bruce

 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org

Re: [U2] unidata env var

2013-03-21 Thread Dave Davis

Uppercase has always worked for me.

$VFIELDSIZE and $vfieldsize are distinct variables to the operating system, so 
I suspect you should stick with uppercase.

6000 - that's huge - what are you putting in these things?  I've had to 
increase to 380 or so before.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera
Sent: Thursday, March 21, 2013 6:52 AM
To: U2 Users List
Subject: [U2] unidata env var

We've had some issues with i-desc failing over years and the solution was to 
set the evironment variable VFIELDSIZE to some amount (6000 or more).

My real question is does unidata care about case for this variable (on *nix, 
not windoze)?  I've seen it documented both as VFIELDSIZE and vfieldsize and 
not sure unidata sees one or both of these.

--
Jeffrey Butera, PhD
Associate Director for Application and Web Services Information Technology 
Hampshire College
413-559-5556

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



Dave Davis
Team Lead, RD

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [UD] correlative syntax

2013-02-28 Thread Dave Davis

I believe this means if result of last expression is not empty, where last 
expression is oconv(@,file;x;0;0) in this case.

Written another way:

OCONV(OCONV(@ID,G0*1),FILE;X;0;0) # 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
bradley.sch...@usbank.com
Sent: Thursday, February 28, 2013 4:29 PM
To: 'U2 Users List'
Subject: [U2] [UD] correlative syntax

A coworker just ran across the following in one of our DICTs. The name of the 
item indicates it was written by someone who is no longer with the organization 
and was well known for knowing wonderful arcane UniData tidbits. We can't find 
anything describing what exactly is going on. The end result is very useful. 
I'm wondering if anyone can explain the @#
bit.


OCONV(@ID,G*1); OCONV(@,FILE;X;0;0); @#


The file the DICT is in has a compound key: ACCOUNT.NUMBER*sequential.
What this item does is grab the account number, attempt to read from FILE and 
return a 0 if the account doesn't exist in FILE or a 1 if it does.
Pretty nifty.

UD7.1
AIX5.3


TIA,
Brad.
U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains 
information that is, or may be, covered by electronic communications privacy 
laws, and is also confidential and proprietary in nature. If you are not the 
intended recipient, please be advised that you are legally prohibited from 
retaining, using, copying, distributing, or otherwise disclosing this 
information in any manner. Instead, please reply to the sender that you have 
received this communication in error, and then immediately delete it. Thank you 
in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



Dave Davis
Team Lead, RD

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] : Evaluating DCOUNT

2013-02-12 Thread Dave Laansma

Hey Allen,

The REMOVE so fast How fast is it?! Match Game throwback that I suspect the 
time it takes to interpret the difference between a VM and AM is negligible. I 
could be wrong.

And as far as using dimensioned arrays, agreed. They do seem to improve speed 
... but still not in comparison to the REMOVE virtual bow to the REMOVE god.

Sincerely,
David Laansma
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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Egerton
Sent: Monday, February 11, 2013 9:02 AM
To: U2 Users List
Subject: Re: [U2] : Evaluating DCOUNT

David,

You're correct that the remove is faster, and it is because it maintains an 
internal pointer to the next item, as opposed to positioning to it for each 
reference.

And I'm pretty sure that you can make it run even faster with:
LINE.KEYS = RAISE(HEADER.REC200)

As a matter of preference, I would set D1 to 999 or some other numeric value 
rather than a null, only because Universe/Unidata is typeless, and I would be 
afraid that the null, (), might be treated as a zero; but that's just 
personal fear and preference not based on a horror story.


On 2/11/2013 8:30 AM, Dave Laansma wrote:
 I would HOPE that it evaluates it each time since the size of array could 
 change within the loop.
 
 Personally if the size of array is relatively small, DCOUNT is alright. 
 However I've found REMOVE to be EXTREMELY faster and therefore use it 
 whenever possible, even on small arrays.
 
 For example, we have two files, a 'header' and 'detail' file. The keys to the 
 'detail' file are stored in attribute 200 of the header file. So I'll pull 
 the keys out of the header record, such:
 
 LINE.KEYS = HEADER.REC200
 D1 = 
 LOOP UNTIL D1 = 0
   REMOVE LINE.KEY FROM LINE.KEYS SETTING D1
   loop statements
 REPEAT
 
 As opposed to:
 
 FOR V1 = 1 TO DCOUNT(HEADER.REC200,@VM)
   LINE.KEY = HEADER.REC200,V1
   loop statements
 NEXT V1
 
 Based on historical dialogs on this subject on this forum, I have seen an 
 improvement in overall performance.
 
 Sincerely,
 David Laansma
 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: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey 
 Butera
 Sent: Monday, February 11, 2013 7:55 AM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] : Evaluating DCOUNT
 
 On 02/11/2013 12:14 AM, Peter Cheney wrote:
 Hi Everyone,

 Does a DCOUNT get evaluated again for each iteration of a loop?
 Or is UniVerse these days intelligent enough to keep track of what's going 
 on?

 e.g.

 for i = 1 to dcount(array,@fm)
 *commands here
 next i

 versus

 totalattributes = dcount(array,@fm)
 for i = 1 to totalattributes
 *commands here
 next i

 Apart from readability and perhaps easier debugging is there an actual 
 internal difference?
 I know it was an issue on older pick releases but I cannot remember if it 
 ever affected UV?
 
 Not sure about universe, but unidata defintely checks the DCOUNT for each 
 iteration.  This produces 4 (not 2):
 
 
 CT=0
 X=45:@VM:58
 FOR I=1 TO DCOUNT(X,@VM)
CT+=1
IF I=2 THEN
  X1,-1 = 99
END
 NEXT I
 CRT CT
 
 

___
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

Re: [U2] : Evaluating DCOUNT

2013-02-12 Thread Dave Laansma

Interesting ... certainly worth := trying!

Sincerely,
David Laansma
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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore
Sent: Tuesday, February 12, 2013 1:43 PM
To: U2 Users List
Subject: Re: [U2] : Evaluating DCOUNT

Hi,
When you have more than about 1,000 values in a field, changing the value mark 
to a field mark, is significant.  I had a program that needed to work through 
two fields with over 20,000 values.  Initially, I left the strings as value 
delimited, used a for/next loop and assigned the results to a new field 
delimited string using -1.  The program took about 15 minutes to perform the 
tasks needed.  I then raised each string, used remove and concatenated 
@FM:item.  It was done almost immediately, there was no perception of a delay 
getting to TCL.  To put it in code snippet, the first took 15 minutes and the 
second took maybe a second.

X=20K values
Y=20K values
Z=''
MAX=DCOUNT(X,@VM)
FOR C=1 TO MAX
   I1=X1,C
   I2=Y1,C
   ZC=I1*I2
NEXT C


X=RAISE(20Kvalues)
Y=RASE(20Kvalues)
Z=''
LOOP
   REMOVE I1 FROM X  SETTING XPOS
   REMOVE I2 FROM Y SETING YPOS
UNTIL I1='' AND I2='' AND XPOS=0 AND YPOS=0
  IF (Z) 
  THEN Z:=@AM:I1*I2
  ELSE Z=I1*I2
REPEAT

There are several things:
1) REMOVE is faster than extract, especially when you are working with values
2) Strings are treated different from dynamic arrays even though in theory you 
are doing the same thing (appending to the end of the string).
3) COUNT will scan the string, then the extract will scan the string when it is 
value delimited.  Field marks are indexes so the first scan resolves the 
location where each field begins.

Tom
RATEX Business Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: Tuesday, February 12, 2013 1:21 PM
To: 'U2 Users List'
Subject: Re: [U2] : Evaluating DCOUNT

Hey Allen,

The REMOVE so fast How fast is it?! Match Game throwback that I suspect the 
time it takes to interpret the difference between a VM and AM is negligible. I 
could be wrong.

And as far as using dimensioned arrays, agreed. They do seem to improve speed 
... but still not in comparison to the REMOVE virtual bow to the REMOVE god.

Sincerely,
David Laansma
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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Egerton
Sent: Monday, February 11, 2013 9:02 AM
To: U2 Users List
Subject: Re: [U2] : Evaluating DCOUNT

David,

You're correct that the remove is faster, and it is because it maintains an 
internal pointer to the next item, as opposed to positioning to it for each 
reference.

And I'm pretty sure that you can make it run even faster with:
LINE.KEYS = RAISE(HEADER.REC200)

As a matter of preference, I would set D1 to 999 or some other numeric value 
rather than a null, only because Universe/Unidata is typeless, and I would be 
afraid that the null, (), might be treated as a zero; but that's just 
personal fear and preference not based on a horror story.


On 2/11/2013 8:30 AM, Dave Laansma wrote:
 I would HOPE that it evaluates it each time since the size of array could 
 change within the loop.
 
 Personally if the size of array is relatively small, DCOUNT is alright. 
 However I've found REMOVE to be EXTREMELY faster and therefore use it 
 whenever possible, even on small arrays.
 
 For example, we have two files, a 'header' and 'detail' file. The keys to the 
 'detail' file are stored in attribute 200 of the header file. So I'll pull 
 the keys out of the header record, such:
 
 LINE.KEYS = HEADER.REC200
 D1 = 
 LOOP UNTIL D1 = 0
   REMOVE LINE.KEY FROM LINE.KEYS SETTING D1
   loop statements
 REPEAT
 
 As opposed to:
 
 FOR V1 = 1 TO DCOUNT(HEADER.REC200,@VM)
   LINE.KEY = HEADER.REC200,V1
   loop statements
 NEXT V1
 
 Based on historical dialogs on this subject on this forum, I have seen an 
 improvement in overall performance.
 
 Sincerely,
 David Laansma
 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: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey 
 Butera
 Sent: Monday, February 11, 2013 7:55 AM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] : Evaluating DCOUNT
 
 On 02/11/2013 12:14 AM, Peter Cheney wrote:
 Hi Everyone,

 Does a DCOUNT get evaluated again for each iteration of a loop?
 Or is UniVerse these days intelligent

Re: [U2] : Evaluating DCOUNT

2013-02-11 Thread Dave Laansma

I would HOPE that it evaluates it each time since the size of array could 
change within the loop.

Personally if the size of array is relatively small, DCOUNT is alright. 
However I've found REMOVE to be EXTREMELY faster and therefore use it whenever 
possible, even on small arrays.

For example, we have two files, a 'header' and 'detail' file. The keys to the 
'detail' file are stored in attribute 200 of the header file. So I'll pull 
the keys out of the header record, such:

LINE.KEYS = HEADER.REC200
D1 = 
LOOP UNTIL D1 = 0
  REMOVE LINE.KEY FROM LINE.KEYS SETTING D1
  loop statements
REPEAT

As opposed to:

FOR V1 = 1 TO DCOUNT(HEADER.REC200,@VM)
  LINE.KEY = HEADER.REC200,V1
  loop statements
NEXT V1

Based on historical dialogs on this subject on this forum, I have seen an 
improvement in overall performance.

Sincerely,
David Laansma
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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera
Sent: Monday, February 11, 2013 7:55 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] : Evaluating DCOUNT

On 02/11/2013 12:14 AM, Peter Cheney wrote:
 Hi Everyone,

 Does a DCOUNT get evaluated again for each iteration of a loop?
 Or is UniVerse these days intelligent enough to keep track of what's going on?

 e.g.

 for i = 1 to dcount(array,@fm)
 *commands here
 next i

 versus

 totalattributes = dcount(array,@fm)
 for i = 1 to totalattributes
 *commands here
 next i

 Apart from readability and perhaps easier debugging is there an actual 
 internal difference?
 I know it was an issue on older pick releases but I cannot remember if it 
 ever affected UV?

Not sure about universe, but unidata defintely checks the DCOUNT for each 
iteration.  This produces 4 (not 2):


CT=0
X=45:@VM:58
FOR I=1 TO DCOUNT(X,@VM)
   CT+=1
   IF I=2 THEN
 X1,-1 = 99
   END
NEXT I
CRT CT


-- 
Jeffrey Butera, PhD
Associate Director for Application and Web Services
Information Technology
Hampshire College
413-559-5556

___
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

Re: [U2] : Evaluating DCOUNT

2013-02-11 Thread Dave Laansma

Jeff,

My understanding is part of our problem is the fact that my multivalues are at 
position 200 and each time it has to count how many multivalues there are, it 
has to skim through the first 200 attributes, multivalues and subvalues to 
get to 200 before it even starts counting.

So it's not so much of an issue of how many multivalues there are in 200, 
it's everything in 1-199 as well.

Which in turn suggests that, when designing files, it may be a good idea to 
cluster your multivalue attributes near the beginning of your records. But 
that's another discussion.

Sincerely,
David Laansma
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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera
Sent: Monday, February 11, 2013 8:35 AM
To: U2 Users List
Cc: U2 Users List
Subject: Re: [U2] : Evaluating DCOUNT

David is correct (re: performance). Most of our app here have MV lists under 
40-50 so it's not a huge issue. If you app has hundreds+ this could be a big 
challenge.

Jeff Butera
--
A tree falls the way it leans.
Be careful which way you lean.
The Lorax

On Feb 11, 2013, at 8:30 AM, Dave Laansma dlaan...@hubbardsupply.com wrote:

 I would HOPE that it evaluates it each time since the size of array could 
 change within the loop.
 
 Personally if the size of array is relatively small, DCOUNT is alright. 
 However I've found REMOVE to be EXTREMELY faster and therefore use it 
 whenever possible, even on small arrays.
 
 For example, we have two files, a 'header' and 'detail' file. The keys to the 
 'detail' file are stored in attribute 200 of the header file. So I'll pull 
 the keys out of the header record, such:
 
 LINE.KEYS = HEADER.REC200
 D1 = 
 LOOP UNTIL D1 = 0
  REMOVE LINE.KEY FROM LINE.KEYS SETTING D1  loop statements REPEAT
 
 As opposed to:
 
 FOR V1 = 1 TO DCOUNT(HEADER.REC200,@VM)  LINE.KEY = 
 HEADER.REC200,V1  loop statements NEXT V1
 
 Based on historical dialogs on this subject on this forum, I have seen an 
 improvement in overall performance.
 
 Sincerely,
 David Laansma
 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: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey 
 Butera
 Sent: Monday, February 11, 2013 7:55 AM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] : Evaluating DCOUNT
 
 On 02/11/2013 12:14 AM, Peter Cheney wrote:
 Hi Everyone,
 
 Does a DCOUNT get evaluated again for each iteration of a loop?
 Or is UniVerse these days intelligent enough to keep track of what's going 
 on?
 
 e.g.
 
 for i = 1 to dcount(array,@fm)
*commands here
 next i
 
 versus
 
 totalattributes = dcount(array,@fm)
 for i = 1 to totalattributes
*commands here
 next i
 
 Apart from readability and perhaps easier debugging is there an actual 
 internal difference?
 I know it was an issue on older pick releases but I cannot remember if it 
 ever affected UV?
 
 Not sure about universe, but unidata defintely checks the DCOUNT for each 
 iteration.  This produces 4 (not 2):
 
 
 CT=0
 X=45:@VM:58
 FOR I=1 TO DCOUNT(X,@VM)
   CT+=1
   IF I=2 THEN
 X1,-1 = 99
   END
 NEXT I
 CRT CT
 
 
 --
 Jeffrey Butera, PhD
 Associate Director for Application and Web Services Information 
 Technology Hampshire College
 413-559-5556
 
 ___
 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

Re: [U2] : Evaluating DCOUNT

2013-02-11 Thread Dave Davis

I think every time, since it's the second argument.

If it doesn't matter, you can do for i = dcount(array,@fm) to 1 step -1 to 
have it evaluate once.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
Sent: Monday, February 11, 2013 12:15 AM
To: U2 Users List (u2-users@listserver.u2ug.org)
Subject: [U2] : Evaluating DCOUNT

Hi Everyone,

Does a DCOUNT get evaluated again for each iteration of a loop?
Or is UniVerse these days intelligent enough to keep track of what's going on?

e.g.

for i = 1 to dcount(array,@fm)
   *commands here
next i

versus

totalattributes = dcount(array,@fm)
for i = 1 to totalattributes
   *commands here
next i

Apart from readability and perhaps easier debugging is there an actual internal 
difference?
I know it was an issue on older pick releases but I cannot remember if it ever 
affected UV?

Cheers
Peter

 ---
Note:
This email (inc all attachments) is for the use of the intended recipient(s) 
only.
Privileged or confidential information may be contained in this communication. 
If you have received this email in error, please notify the sender immediately 
and then delete all copies of this message from your computer network. If you 
are not the intended recipient, you must not keep, use, disclose, copy or 
distribute this email without the author's prior permission. If you are the 
intended recipient and you do not wish to receive similar electronic messages 
from us in future, then please respond to the sender to this effect.
We have taken precautions to minimise the risk of transmitting software 
viruses, but advise you to carry out your own virus checks on this email and 
its attachments. We do not accept liability for any loss or damage caused by 
software viruses and do not represent that this transmission is free from 
viruses or other defects.
Firstmac Limited (ABN 59 094 145 963) (AFSL 290600)
 ---
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Dave Davis
Team Lead, RD

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] {BDT] Commenting A Block Of Code

2013-01-10 Thread Dave Davis

You could surround the lines with an IF statement that always evaluates to 
false.

Not the same as commenting out of course.

IF (0) THEN
  Code you don't want to run.
END

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Wednesday, January 09, 2013 8:25 PM
To: U2 Users List
Subject: [U2] {BDT] Commenting A Block Of Code

Rather than going line-by-line... is there a way... or a trick to highlighting 
several lines of code...

And commenting out all of these lines in aggregate?

I have a legacy program whose code is no longer compliant... that I am trying 
to isolate.

--Bill
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



Dave Davis
Team Lead, RD

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unidata 6.1.15 Oddity

2012-11-09 Thread Dave Davis

Were you doing an OCONVS or just an OCONV?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Friday, November 09, 2012 11:46 AM
To: U2 Users List
Subject: Re: [U2] Unidata 6.1.15 Oddity

Thank you everyone for the feedback.  I had some suspicion in the back of my 
mind that doing an OCONV MCU on a full mv'd string was a Somewhat Bad Idea, now 
I know why. :-)

On Thu, Nov 8, 2012 at 10:56 AM, Woodward, Bob bob_woodw...@k2sports.comwrote:

 Hi Kevin,

 Two times in my Unidata career I've had a problem like this where
 something doesn't work in a subroutine.  My work around, both times,
 was to add a simple line of code at the beginning of the program.
 Usually just assigning a value to a new, unused, variable like
 JUNK=JUNK is all it would take.  With it, the program would work
 flawlessly but if I took it back out, or commented it out, the odd behavior 
 returned.

 BobW

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
 Sent: Wednesday, November 07, 2012 4:26 PM
 To: U2 Users List
 Subject: [U2] Unidata 6.1.15 Oddity

 We have a customer who has a system that was rebooted a couple days ago.
  Since then, and only in one certain subroutine, when doing an MCU
 conversion on a multivalued list, the ASCII 253 value marks are
 replaced with ASCII 221.  Understanding that the difference between an
 lower and upper case A is 32 in the ASCII table (97 - 65), it seems
 like Unidata is treating the delimiters like normal characters.  But
 again, this only happens in certain programs.  If I extract the lines
 of code that exhibit this behavior into its own program, the problem does not 
 occur.

 Any ideas what might be causing this and only in one subroutine?  Both
 my test program and the real program with the problem are $BASICTYPE
 U.
 ___
 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

Dave Davis
Team Lead, RD

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread Dave Laansma

Excellent news.

However, is there a way to utilize two indexes with the SELECTINDEX
command in Unibasic?

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune
Sent: Wednesday, November 07, 2012 11:47 AM
To: U2 Users List
Subject: Re: [U2] Multiple UniData Indexes in same select

From the Using UniData manual:

Alternate Indexes in UniQuery Statement
Prior to UniData 5.2, only one index was used in the selection criteria
of a UniQuery statement, even if the selection criteria contained more
than one indexed attribute. UniQuery now uses all available indexes when
processing a statement containing selection criteria.Note: You cannot
use an alternate index with a LIKE clause when the comparative attribute
is numeric.

Wally Terhune
Technical Support Engineer
Rocket Software
4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA
t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w:
u2.rocketsoftware.com



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Farmer
Sent: Wednesday, November 07, 2012 7:35 AM
To: U2 Users List
Subject: [U2] Multiple UniData Indexes in same select

Good morning, 

I should know this, but as the gray gets thicker, some of the old
knowledge seeps away.

If you have indexes on multiple attributes on a file in UniData AND you
include both of those indexed attributes in the same Select statement,
how does UniData know which index to use? Does it use both? Neither?

Thanks in advance,

Doug


This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We cannot accept
liability for any loss or damage caused by software viruses. Any views
and/or opinions expressed in this e-mail are of the author only and do
not represent the views of Epicor Software Corporation or any other
company within its group.


This message has been scanned for malware by Websense. www.websense.com
___
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

Re: [U2] Universe and data-stacking

2012-09-27 Thread Dave Davis

Have you tried SB.LOGIN.RP instead?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Susan Joslyn
Sent: Wednesday, September 26, 2012 10:23 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Universe and data-stacking

Hi geniuses!
I know that in Unidata there is a udt options flag that allows data-stacking to 
work.  I can't find anything similar in Universe.  But even if I could, my 
problem seems to run a little deeper than that.  I can write a test program 
that data stacks two pieces of info into another program that has two input 
commands.  No problem, that works.  But if I try to CHAIN or EXECUTE SB.LOGIN 
datastacking the user ID and password it fails.  But get this - it succeeds in 
some of the accounts (universe directory accounts) but fails in others.  Is 
there something about the accounts, the flavor, some setting that would prevent 
a datastack from making it -- maybe because it is a chained command?  I tried 
it with EXECUTE, no difference.

Anyone run into something like this?  Anyone who is an SB+ user might suggest 
that I use the AUTOLOGIN option, but that doesn't change the behavior at all.  
It still makes me login, still won't take the data stack.

I am not well-versed at administrative commands that might tell me things about 
the account settings and flavor and tunable parameters - so if there is 
something obvious I could look at, don't assume that I know it.

Any and all help, as always, greatly appreciated!

Susan

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Dave Davis
Team Lead, RD

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unidata 7.1.16 Multiple Active Select Lists

2012-09-24 Thread Dave Davis

'PASSLIST' or Misuse of Reserved Word 'RTNLIST'.
I've tried UDTEXECUTE with no compilation errors but also no
improvement on the problem. I've even tried MDPERFORM but I get
the misuse errors with the RTNLIST and PASSLIST options. Oddly
enough, removing $BASICTYPE U I don't get an error on MDPERFORM
but I can't READNEXT from a numbered select without the $BASICTYPE U.

How should I structure this SUBR(..) so that it does not consume
list
0 when selecting to list 3?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

This communication, its contents and any file attachments
transmitted with it are intended solely for the addressee(s) and
may contain confidential proprietary information.
Access by any other party without the express written permission of
the sender is STRICTLY PROHIBITED.
If you have received this communication in error you may not copy,
distribute or use the contents, attachments or information in any way.
Please destroy it and contact the sender.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Click
https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg==
04y!LlOoL8USVGrPZehFfPKcPPmbfFPdrr1lqOECv!Swg== to report this
email as spam.

Epicor Software (UK) is a limited company registered in England Wales.
Registration Number: 2338274. Registered Office: 6th Floor, One
London
Wall, London EC2Y 5EB
This e-mail is for the use of the intended recipient(s) only. If
you have received this e-mail in error, please notify the sender
immediately and then delete it. If you are not the intended
recipient, you must not use, disclose or distribute this e-mail
without the
author's
prior permission.
We have taken precautions to minimize the risk of transmitting
software viruses, but we advise you to carry out your own virus
checks on any attachment to this message. We cannot accept
liability for any loss or damage caused by software viruses. Any
views and/or opinions expressed in this e-mail are of the author
only and do not represent the views of Epicor Software (UK) Limited
or any other company within
its
group.

This message has been scanned for malware by Websense.
www.websense.com ___
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

Dave Davis
Team Lead, RD

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com

This message is intended exclusively for the individual or entity to which it
is addressed. This communication may contain information that is proprietary,
privileged or confidential or otherwise legally exempt from disclosure. If you
are not the named addressee, you are not authorized to read, print, retain,
copy or disseminate this message or any part of it. If you have received this
message in error, please notify the sender immediately by e-mail and delete all
copies of the message.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unidata 7.1.16 Multiple Active Select Lists

2012-09-24 Thread Dave Davis

What we do in situations like this is set up a subroutine that retrieves the 
list of record keys in B, given the value of the index I want to retrieve.  
This can then be called from an I-type in A, or from another subroutine.

I do the sort the hard way (in basic) so that the keys are in the correct 
order, usually using LOCATE with AL or AR and INSERT.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Monday, September 24, 2012 1:55 PM
To: U2 Users List
Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists

Good thought on the index, but alas, no index on the file.  We could probably 
add one, but then how do we control the order of the records being retrieved 
from the list?  (The order is important to our process.)

On Mon, Sep 24, 2012 at 11:49 AM, Dave Davis dda...@harriscomputer.comwrote:

 Aren't these nested selects kind of slow?

 If the field in file b is indexed, I would use the SETINDEX and
 READFWD statements in place of the SELECT statement.  You are using
 Unidata, so unless you need to make this work for Universe as well
 that's what I would do.

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org [mailto:
 u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
 Sent: Monday, September 24, 2012 1:43 PM
 To: U2 Users List
 Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists

 Well, that success was short lived.  While the READLIST and FORMLIST
 allow my SUBR(..) field to not consume the active select list zero,
 these two commands produce different results:

 LIST ORDER.LINE WITH fieldName fieldName

 ...this will show the lines that have this field set, and will show
 the field properly.  However, this command returns no items:

 SELECT ORDER.LINE WITH fieldName

 Basically my program is doing this:

 READLIST ACTIVE.LIST FROM 0 ELSE NULL
 *
 CMD = select ... TO 2
 EXECUTE CMD CAPTURING OUTPUT
 *
 EOF = @FALSE
 LOOP
   READNEXT ID FROM 2 ELSE EOF = @TRUE
 UNTIL EOF DO
   ..
 REPEAT
 *
 CLEARSELECT 2
 *
 FORMLIST ACTIVE.LIST TO 0

 All other input/ideas appreciated.

 On Mon, Sep 24, 2012 at 11:26 AM, Kevin King ke...@precisonline.com
 wrote:

  And we have a winner!  Thank you everyone!  The READLIST and
  FORMLIST will work; seems kinda kludgy, but hey, it's working.
 
 
  On Mon, Sep 24, 2012 at 11:21 AM, David A. Green
  dgr...@dagconsulting.com
   wrote:
 
  If you already have an active list then you'll have to save it,
  then restore it.  See READLIST and FORMLIST.
 
  David A. Green
  (480) 813-1725
  DAG Consulting
 
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin
  King
  Sent: Monday, September 24, 2012 10:11 AM
  To: U2 Users List
  Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
 
  It's all fine if the program controls both lists, but in this case
  the
  SUBR(..) type field could be accessed in just about any context,
  from TCL, from a download, from MITS, from another BASIC routine,
  with or without a select list...
 
  The RTNLIST doesn't solve the problem of my select command
  consuming the active list 0.  It seems that the PASSLIST extension
  to EXECUTE is designed specifically for this purpose, but it
  produces nothing but compilation
  errors:
 
  CMD = select ...
  EXECUTE CMD CAPTURING OUTPUT RTNLIST 2 PASSLIST 2
 
  ...produces a compilation error about the misuse of RTNLIST,
  despite the documentation saying this should be possible.
 
  The point is that I want to leave select list 0 entirely alone,
  which is why I'm using $BASICTYPE U.  BASICTYPE P - standard on
  these
  SB+ systems - does not allow one to READNEXT from anything but list
  0, and I want to leave list zero untouched.
 
  Gotta be a way, right?
 
  -K
 
  On Mon, Sep 24, 2012 at 10:56 AM, Martin Braid mbr...@epicor.com
 wrote:
 
   Hi Kevin, Any reason why you are using type U ? This certainly
   works using P ...
  
   S='SELECT SOMEFILE WITH SOMETHING = OOJIT'
   EXECUTE S RTNLIST MYLIST CAPTURING ANYOUTPUT
   EOF=0
   LOOP UNTIL EOF DO
 READNEXT MYID FROM MYLIST THEN
   GSOUB MYMESS
 END ELSE EOF=1
   REPEAT
  
   Martin
  
  
   -Original Message-
   From: u2-users-boun...@listserver.u2ug.org
   [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker
   Hughes
   Sent: 24 September 2012 17:49
   To: 'U2 Users List'
   Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
  
   Can you use SELECT yourfile WITH whatever TO 8 {specific list
   number} in the master process, and let your SUBR virtual field
   default to list
   0 {zero}?
  
   The other option could be to do a READLIST within the SUBR
   function and reset the list when RETURNing, but this could be
   onerous in terms of processing speed.
  
   HTH
   -Baker
  
  
  
   -Original Message-
   From: u2-users-boun

Re: [U2] Unidata 7.1.16 Multiple Active Select Lists

2012-09-24 Thread Dave Davis

Well aware of all that, especially the negative numbers issue.

I restrict use of AR, DR locates to non-negative integers.

Otherwise I use comparisons inside of a loop.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Monday, September 24, 2012 3:44 PM
To: U2 Users List
Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists

Dave,

Be careful with that because LOCATE's sort BY AR or DR may be different 
from LIST's sort BY an R-justified field.  Leading zeros, negative numbers, 
decimals with trailing zeros all come to mind.
If I recall that inconsistency is consistent across several MV platforms.

However,  it might be more consistent of UD to be inconsistent with the 
MV-world (the MV-universe) on this point.

cds

On 9/24/2012 1:04 PM, Dave Davis wrote:
 What we do in situations like this is set up a subroutine that retrieves the 
 list of record keys in B, given the value of the index I want to retrieve.  
 This can then be called from an I-type in A, or from another subroutine.

 I do the sort the hard way (in basic) so that the keys are in the
 correct order, usually using LOCATE with AL or AR and INSERT

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



Dave Davis
Team Lead, RD

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Inverting/Pivoting a table

2012-09-11 Thread Dave Laansma

SPLICE ... now THAT'S a cool little tool! I'll have to do some testing
with null attributes and values, but this just may work!

Thank you Rex and Stuart!

Sincerely,
David Laansma

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rex Gozar
Sent: Tuesday, September 11, 2012 1:08 PM
To: U2 Users List
Subject: Re: [U2] Inverting/Pivoting a table

Not a function, but there are some subroutines that flip posted on
PickWiki:

http://www.pickwiki.com/cgi-bin/wiki.pl?Row2Col

AND

http://www.pickwiki.com/cgi-bin/wiki.pl?Row2Col_II

rex
___
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] Inverting/Pivoting a table

I get flat files that I'd like to 'flip' to accommodate the multi-value
database. For example, given this table:

 

123456vmDAVID JONESvm1234 MAIN ST.vmANYWHEREvmMIvm12345am

654321vmJOHN SMITHvm4321 MAIN ST.vmANYWHEREvmMIvm12345

 

Is there a function that will change it to:

 

123456vm654321am

DAVID JONESvmJOHN SMITHam

1234 MAIN ST.vm4321 MAIN ST.am

ANYWHEREvmANYWHEREam

MIvmMIam

12345vm12345

 

Right now I use these nested loops, which tend to take a while depending
on the size of TABLE:

 

NEW.TABLE = 

 

FOR A1 = 1 TO DCOUNT(TABLE,@AM)

  FOR V1 = 1 TO DCOUNT(TABLEA1,@VM)

NEW.TABLEV1,A1 = TABLEA1,V1

  NEXT V1

NEXT A1

 

TABLE = NEW.TABLE

 

Sincerely,

David Laansma

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Inverting/Pivoting a table

REFORMAT perhaps?

I am find no reference to a Unibasic command/statement REFORMAT.

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, September 10, 2012 2:20 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Inverting/Pivoting a table


REFOMAT



-Original Message-
From: Wols Lists antli...@youngman.org.uk
To: u2-users u2-users@listserver.u2ug.org
Sent: Mon, Sep 10, 2012 11:07 am
Subject: Re: [U2] Inverting/Pivoting a table


On 10/09/12 14:39, Dave Laansma wrote:
 I get flat files that I'd like to 'flip' to accommodate the 
 multi-value database. For example, given this table:
 
I thought there was a command that would flip a FILE like that. I've
never used it, but I recall a colleague making good use of it ...
  
 123456vmDAVID JONESvm1234 MAIN ST.vmANYWHEREvmMIvm12345am
 
 654321vmJOHN SMITHvm4321 MAIN ST.vmANYWHEREvmMIvm12345
 
  
 
 Is there a function that will change it to:
 
  
 
 123456vm654321am
 
 DAVID JONESvmJOHN SMITHam
 
 1234 MAIN ST.vm4321 MAIN ST.am
 
 ANYWHEREvmANYWHEREam
 
 MIvmMIam
 
 12345vm12345
 
  
 
 Right now I use these nested loops, which tend to take a while 
 depending on the size of TABLE:
 
And here you're using dynamic arrays. If you're in PI syntax, do a
DCOUNT to get the number of people, dimension some static arrays, and
dump the data into that. It'll be MUCH faster. You can REMOVE the
elements from the original dynamic array (fast), dump them into your
static array(s) (fast), and MATBUILD your new array (fast).
  
 
 NEW.TABLE = 
 
  
 
 FOR A1 = 1 TO DCOUNT(TABLE,@AM)
 
   FOR V1 = 1 TO DCOUNT(TABLEA1,@VM)
 
 NEW.TABLEV1,A1 = TABLEA1,V1
 
   NEXT V1
 
 NEXT A1
 
  
 
 TABLE = NEW.TABLE
 
  
 
 Sincerely,
 
 David Laansma
 
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

Re: [U2] Inverting/Pivoting a table

REFORMAT appears to be a UniQuery command and appears to be used to copy
records from one file to another.

I'm looking for this type of functionality in a UniBasic program.

Sincerely,
David Laansma

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben
Sent: Monday, September 10, 2012 3:41 PM
To: U2 Users List
Subject: Re: [U2] Inverting/Pivoting a table

REFORMAT is a TCL command.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: September-10-12 12:39 PM
To: U2 Users List
Subject: Re: [U2] Inverting/Pivoting a table

REFORMAT perhaps?

I am find no reference to a Unibasic command/statement REFORMAT.

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, September 10, 2012 2:20 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Inverting/Pivoting a table


REFOMAT



-Original Message-
From: Wols Lists antli...@youngman.org.uk
To: u2-users u2-users@listserver.u2ug.org
Sent: Mon, Sep 10, 2012 11:07 am
Subject: Re: [U2] Inverting/Pivoting a table


On 10/09/12 14:39, Dave Laansma wrote:
 I get flat files that I'd like to 'flip' to accommodate the 
 multi-value database. For example, given this table:

I thought there was a command that would flip a FILE like that. I've
never used it, but I recall a colleague making good use of it ...

 123456vmDAVID JONESvm1234 MAIN ST.vmANYWHEREvmMIvm12345am

 654321vmJOHN SMITHvm4321 MAIN ST.vmANYWHEREvmMIvm12345



 Is there a function that will change it to:



 123456vm654321am

 DAVID JONESvmJOHN SMITHam

 1234 MAIN ST.vm4321 MAIN ST.am

 ANYWHEREvmANYWHEREam

 MIvmMIam

 12345vm12345



 Right now I use these nested loops, which tend to take a while 
 depending on the size of TABLE:

And here you're using dynamic arrays. If you're in PI syntax, do a
DCOUNT to get the number of people, dimension some static arrays, and
dump the data into that. It'll be MUCH faster. You can REMOVE the
elements from the original dynamic array (fast), dump them into your
static array(s) (fast), and MATBUILD your new array (fast).


 NEW.TABLE = 



 FOR A1 = 1 TO DCOUNT(TABLE,@AM)

   FOR V1 = 1 TO DCOUNT(TABLEA1,@VM)

 NEW.TABLEV1,A1 = TABLEA1,V1

   NEXT V1

 NEXT A1



 TABLE = NEW.TABLE



 Sincerely,

 David Laansma

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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Inverting/Pivoting a table

Excerpt from page 1-161 of the UniQuery Commands Reference available
at

http://www.rocketsoftware.com/u2/products/unidata/resources/manuals/unid
ata-7.3-documentation/uniquery-commands-reference/view

REFORMAT
Syntax
REFORMAT filename attributes [selection_criteria]
Description
The UniQuery REFORMAT command copies record attributes you specify from
one data file to another data file. The destination file must already
exist. REFORMAT uses the first attribute named in the UniQuery statement
as the record ID in the destination file. The remaining attributes in
the UniQuery statement become record attributes in the destination file.
UniQuery prompts for the name of the destination file after you enter
the REFORMAT command.

Sincerely,
David Laansma

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, September 10, 2012 4:02 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Inverting/Pivoting a table


 EXECUTE REFORMAT
it doesn't copy, it changes the format as well in other words, it
pivots, as you asked

 

 

-Original Message-
From: Dave Laansma dlaan...@hubbardsupply.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Sep 10, 2012 12:59 pm
Subject: Re: [U2] Inverting/Pivoting a table


REFORMAT appears to be a UniQuery command and appears to be used to copy
records from one file to another.

I'm looking for this type of functionality in a UniBasic program.

Sincerely,
David Laansma

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben
Sent: Monday, September 10, 2012 3:41 PM
To: U2 Users List
Subject: Re: [U2] Inverting/Pivoting a table

REFORMAT is a TCL command.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: September-10-12 12:39 PM
To: U2 Users List
Subject: Re: [U2] Inverting/Pivoting a table

REFORMAT perhaps?

I am find no reference to a Unibasic command/statement REFORMAT.

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, September 10, 2012 2:20 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Inverting/Pivoting a table


REFOMAT



-Original Message-
From: Wols Lists antli...@youngman.org.uk
To: u2-users u2-users@listserver.u2ug.org
Sent: Mon, Sep 10, 2012 11:07 am
Subject: Re: [U2] Inverting/Pivoting a table


On 10/09/12 14:39, Dave Laansma wrote:
 I get flat files that I'd like to 'flip' to accommodate the 
 multi-value database. For example, given this table:

I thought there was a command that would flip a FILE like that. I've
never used it, but I recall a colleague making good use of it ...

 123456vmDAVID JONESvm1234 MAIN ST.vmANYWHEREvmMIvm12345am

 654321vmJOHN SMITHvm4321 MAIN ST.vmANYWHEREvmMIvm12345



 Is there a function that will change it to:



 123456vm654321am

 DAVID JONESvmJOHN SMITHam

 1234 MAIN ST.vm4321 MAIN ST.am

 ANYWHEREvmANYWHEREam

 MIvmMIam

 12345vm12345



 Right now I use these nested loops, which tend to take a while 
 depending on the size of TABLE:

And here you're using dynamic arrays. If you're in PI syntax, do a
DCOUNT to get the number of people, dimension some static arrays, and
dump the data into that. It'll be MUCH faster. You can REMOVE the
elements from the original dynamic array (fast), dump them into your
static array(s) (fast), and MATBUILD your new array (fast).


 NEW.TABLE = 



 FOR A1 = 1 TO DCOUNT(TABLE,@AM)

   FOR V1 = 1 TO DCOUNT(TABLEA1,@VM)

 NEW.TABLEV1,A1 = TABLEA1,V1

   NEXT V1

 NEXT A1



 TABLE = NEW.TABLE



 Sincerely,

 David Laansma

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
___
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

Re: [U2] Inverting/Pivoting a table

:-)

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Monday, September 10, 2012 4:31 PM
To: U2 Users List
Subject: Re: [U2] Inverting/Pivoting a table

Why is the Kink's song Lola suddenly playing in my mind!

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, September 10, 2012 4:21 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Inverting/Pivoting a table

Columns become rows
Rows become columns

___
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

Re: [U2] SB.SMART.QUERY

2012-08-20 Thread Dave Davis

You need to go to AdminSB+ SetupSB+ Configuration PatternsF5-System Defaults 
and set the SB+ Subroutines in Dictionaries field to Y

After that you would need to regenerate the dictionary entries so that the 
default ERROR i-type gets replaced with an i-type that uses the 
SB.SMART.QUERY function.  Try re-saving one or two fields you are interested in 
after you set the flag above.

What SB.SMART.QUERY does is use the executable expression of your SB+ 
expression to return a value that can be used in query statements.  What the 
flag does is tell SB+ to generate the executable expression and create the 
i-type that uses it with SB.SMART.QUERY, after you save a field definition.

I did a similar thing myself before they made SB.SMART.QUERY available.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dennis bartlett
Sent: Sunday, August 19, 2012 8:00 PM
To: U2 Users List
Subject: [U2] SB.SMART.QUERY

Hi

Does anyone know how I can get SB.SMART.QUERY documentation? Alternatively (or 
maybe in addition) do you know how to call SB.SMART.QUERY to decifer DICT items 
much like ITYPE(xx) does in BASIC?

The IBM release notes talk about SB.SMART.QUERY being IBM's response to people 
wanting to use SB reporting outside of the SB+ environment - now this is 
EXACTLY what I need, but I can't figure out how to do it. I've written my own 
half-blown version, but it would be oh-so-easy to simply use theirs..

Thanks

Dennis Bartlett
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



Dave Davis
Team Lead, RD

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] CSV to Array

2012-08-16 Thread Dave Laansma

Like

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne
Ackerman
Sent: Thursday, August 16, 2012 8:52 AM
To: U2 Users List
Subject: Re: [U2] CSV to Array

I actually enjoy reading wjhonson's puzzle posts with code examples,
etc.  Maybe they can be flagged in the header so those of you who don't
want to read them can just skip them.
-Dianne

On 8/15/2012 5:49 PM, Tony Gravagno wrote:
 Anyone getting paid to play guessing games? Dude, get to the point. If

 this were presented as I need help I think many people would jump to

 help. But presenting this as a Mensa challenge is just wasting 
 people's time.
 T

 Wjhonson wrote:
Rex Gozar uploaded this code, and someone (perhaps him) corrected 
 it,
 but there's a redundancy here.  I'm trying to fix it, in my own
 version,
 mostly perhaps I *hate* the CONTINUE, but the logic is a bit
 convoluted
 eh?  Anyone spot the redundancy ?
 ___

___
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

Re: [U2] OT: A little life humor

2012-07-30 Thread Dave Laansma

Sounds like a facebook post unto itself!

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Monday, July 30, 2012 11:09 AM
To: U2 Users
Subject: [U2] OT: A little life humor

Over the weekend, my son told us not buy any more cards or gifts for his
girlfriend, because they have broken up. (not the humorous part).

When we told him we were not surprised because we could see the writing
on the wall, he seemed stunned
   And wanted to know whose wall we saw it on!  (facebook reference). He
still seem puzzled when we explained
   That it was just a figure of speech, and couldn't understand why we
were laughing when we realized he
   Thought we saw it on facebook.
___
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

Re: [U2] Select Statement Invalid

2012-07-12 Thread Dave Davis

Maybe your statement is too long.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt
Sent: Wednesday, July 11, 2012 7:19 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Select Statement Invalid

Unidata 7.1.20, pick flavor

I have this quick paragraph to select records based on partial keys:

001: PA

002: SELECT WIPMTLRQ WITH @ID =
299486]302667]318583]337991]374396]376742]382767]385661]
398932]415256]445409]453821]

454353]478175]478845]502457]

Bottom.

However, this is what I get when I run it: No data retrieved from
current (S)SELECT statement.

Yet if I run SELECT WIPMTLRQ WITH @ID = 299486]

I get records returned.

What am I missing?

Thanks.

Albert DeWitt, CPIM

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Dave Davis
Team Lead, RD

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] trimming a list (a test of your ability)

This is the best solution, using REMOVE and building a new list instead of 
constantly 'shrinking' the original table.

That being said, as NEW.LIST gets rather large, adding new elements to it can 
get 'time' consuming. Just like the REMOVE keeps track of the pointer as you 
spin through a table, I wish there was a comparable statement that kept track 
of the pointer as we added new elements -1 to tables.

Sincerely,
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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marco Manyevere
Sent: Thursday, July 12, 2012 4:14 AM
To: U2 Users List
Subject: Re: [U2] trimming a list (a test of your ability)

Is this what the OP is asking about or I'm missing something? The 2 code 
fragments look totally different. We dont know what's happening in 
GET.UTILITY.RECORD or the significance of UTILITY.NAME and LAST.NAME to totally 
eliminate them during the 'optimisation'

I would rather do:
 
NEW.LIST = ''
LOOP
  REMOVE UTILITY.ID FROM KEY.LIST SETTING MORE WHILE MORE:UTILITY.ID
  GOSUB GET.UTILITY.RECORD
   IF INDEX(UTILITY.NAME,LAST.NAME,1) = 0 THEN CONTINUE
   NEW.LIST-1 = UTILITY.ID
REPEAT
KEY.LIST = NEW.LIST
NEW.LIST = '' ;* free the memory
 


 From: Kate Stanton k...@walstan.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Thursday, 12 July 2012, 4:27
Subject: Re: [U2] trimming a list (a test of your ability)
  
I am getting sucked in!

NLST =                                                        ;* For new list 
MAXI = DCOUNT(KEY.LIST1,@vM)         ;* Count items FOR INO =1 TO MAXI        
                           ;* Each key in list
  KEY.ID = KEY.LIST1,INO                        ;* A key ID
  LOCATE(KEY.ID,NLST,1;POS;'AL') ELSE  ;* see if there
    INS KEY.ID BEFORE NLIST1,POS       ;* Sort to list
  END
NEXT INO                                                      ;* Check all keys 
On 12 July 2012 12:09, Wjhonson wjhon...@aol.com wrote:


 1295          FOR DISPLAY.LOOP = 1 TO KEY.COUNT
 1296             UTILITY.ID = KEY.LIST1,DISPLAY.LOOP
 1297             GOSUB GET.UTILITY.RECORD
 1298             IF INDEX(UTILITY.NAME,LAST.NAME,1) = 0 THEN
 1299                KEY.LIST = DELETE(KEY.LIST,1,DISPLAY.LOOP,0)
 1300                DISPLAY.LOOP -= 1
 1301                KEY.COUNT -= 1
 1302             END
 1303          NEXT DISPLAY.LOOP


 Comments?


 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users




--
Kate Stanton
Walstan Systems Ltd
4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand
Phone: + 64 9 360 5310  Mobile: + 64 21 400 486
Email: k...@walstan.com
___
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

Re: [U2] trimming a list (a test of your ability)

Is this technique significantly faster? It still has to search to the end of 
the table each time it appends this string, doesn't it?

Sincerely,
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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, July 12, 2012 9:30 AM
To: U2 Users List
Subject: Re: [U2] trimming a list (a test of your ability)

Instead of -1, use  string=string:char(254):additionalelement

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: Thursday, July 12, 2012 9:20 AM
To: Marco Manyevere; U2 Users List
Subject: Re: [U2] trimming a list (a test of your ability)

This is the best solution, using REMOVE and building a new list instead of 
constantly 'shrinking' the original table.

That being said, as NEW.LIST gets rather large, adding new elements to it can 
get 'time' consuming. Just like the REMOVE keeps track of the pointer as you 
spin through a table, I wish there was a comparable statement that kept track 
of the pointer as we added new elements -1 to tables.

Sincerely,
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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marco Manyevere
Sent: Thursday, July 12, 2012 4:14 AM
To: U2 Users List
Subject: Re: [U2] trimming a list (a test of your ability)

Is this what the OP is asking about or I'm missing something? The 2 code 
fragments look totally different. We dont know what's happening in 
GET.UTILITY.RECORD or the significance of UTILITY.NAME and LAST.NAME to totally 
eliminate them during the 'optimisation'

I would rather do:
 
NEW.LIST = ''
LOOP
  REMOVE UTILITY.ID FROM KEY.LIST SETTING MORE WHILE MORE:UTILITY.ID
  GOSUB GET.UTILITY.RECORD
   IF INDEX(UTILITY.NAME,LAST.NAME,1) = 0 THEN CONTINUE
   NEW.LIST-1 = UTILITY.ID
REPEAT
KEY.LIST = NEW.LIST
NEW.LIST = '' ;* free the memory
 


 From: Kate Stanton k...@walstan.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Thursday, 12 July 2012, 4:27
Subject: Re: [U2] trimming a list (a test of your ability)
  
I am getting sucked in!

NLST =                                                        ;* For new list 
MAXI = DCOUNT(KEY.LIST1,@vM)         ;* Count items FOR INO =1 TO MAXI        
                           ;* Each key in list
  KEY.ID = KEY.LIST1,INO                        ;* A key ID
  LOCATE(KEY.ID,NLST,1;POS;'AL') ELSE  ;* see if there
    INS KEY.ID BEFORE NLIST1,POS       ;* Sort to list
  END
NEXT INO                                                      ;* Check all keys 
On 12 July 2012 12:09, Wjhonson wjhon...@aol.com wrote:


 1295          FOR DISPLAY.LOOP = 1 TO KEY.COUNT
 1296             UTILITY.ID = KEY.LIST1,DISPLAY.LOOP
 1297             GOSUB GET.UTILITY.RECORD
 1298             IF INDEX(UTILITY.NAME,LAST.NAME,1) = 0 THEN
 1299                KEY.LIST = DELETE(KEY.LIST,1,DISPLAY.LOOP,0)
 1300                DISPLAY.LOOP -= 1
 1301                KEY.COUNT -= 1
 1302             END
 1303          NEXT DISPLAY.LOOP


 Comments?


 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users




--
Kate Stanton
Walstan Systems Ltd
4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand
Phone: + 64 9 360 5310  Mobile: + 64 21 400 486
Email: k...@walstan.com
___
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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] trimming a list (a test of your ability)

I'm puzzled by '... doesn't care ...' terminology. Of course it 'cares'
about pointers, it still has to get to the end of the 'string' one way
or another.

So, the question then is, does concatenation := establish and append to
a 'string' faster than -1?

And if so, why doesn't the database use the same logic for -1 as it
does for := since technically they're accomplishing the same thing?

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid
Sent: Thursday, July 12, 2012 9:41 AM
To: U2 Users List
Subject: Re: [U2] trimming a list (a test of your ability)

String concatenation will probably work faster since it doesn't care
about pointers IF NEW.LIST# THEN NEW.LIST := @AM  (or @VM if you want
in the original format) NEW.LIST := UTILITY.ID

Martin


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: 12 July 2012 14:20
To: Marco Manyevere; U2 Users List
Subject: Re: [U2] trimming a list (a test of your ability)

This is the best solution, using REMOVE and building a new list instead
of constantly 'shrinking' the original table.

That being said, as NEW.LIST gets rather large, adding new elements to
it can get 'time' consuming. Just like the REMOVE keeps track of the
pointer as you spin through a table, I wish there was a comparable
statement that kept track of the pointer as we added new elements -1
to tables.

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marco
Manyevere
Sent: Thursday, July 12, 2012 4:14 AM
To: U2 Users List
Subject: Re: [U2] trimming a list (a test of your ability)

Is this what the OP is asking about or I'm missing something? The 2 code
fragments look totally different. We dont know what's happening in
GET.UTILITY.RECORD or the significance of UTILITY.NAME and LAST.NAME to
totally eliminate them during the 'optimisation'

I would rather do:
 
NEW.LIST = ''
LOOP
  REMOVE UTILITY.ID FROM KEY.LIST SETTING MORE WHILE MORE:UTILITY.ID
  GOSUB GET.UTILITY.RECORD
   IF INDEX(UTILITY.NAME,LAST.NAME,1) = 0 THEN CONTINUE
   NEW.LIST-1 = UTILITY.ID
REPEAT
KEY.LIST = NEW.LIST
NEW.LIST = '' ;* free the memory
 


 From: Kate Stanton k...@walstan.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Thursday, 12 July 2012, 4:27
Subject: Re: [U2] trimming a list (a test of your ability)
  
I am getting sucked in!

NLST =;* For
new list MAXI = DCOUNT(KEY.LIST1,@vM) ;* Count items FOR INO
=1 TO MAXI   ;* Each key in list
  KEY.ID = KEY.LIST1,INO;* A key ID
  LOCATE(KEY.ID,NLST,1;POS;'AL') ELSE  ;* see if there
INS KEY.ID BEFORE NLIST1,POS   ;* Sort to list
  END
NEXT INO  ;* Check
all keys On 12 July 2012 12:09, Wjhonson wjhon...@aol.com wrote:


 1295  FOR DISPLAY.LOOP = 1 TO KEY.COUNT
 1296 UTILITY.ID = KEY.LIST1,DISPLAY.LOOP
 1297 GOSUB GET.UTILITY.RECORD
 1298 IF INDEX(UTILITY.NAME,LAST.NAME,1) = 0 THEN
 1299KEY.LIST = DELETE(KEY.LIST,1,DISPLAY.LOOP,0)
 1300DISPLAY.LOOP -= 1
 1301KEY.COUNT -= 1
 1302 END
 1303  NEXT DISPLAY.LOOP


 Comments?


 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users




--
Kate Stanton
Walstan Systems Ltd
4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand
Phone: + 64 9 360 5310  Mobile: + 64 21 400 486
Email: k...@walstan.com
___
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


Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg==  to report
this email as spam.


Epicor Software (UK) is a limited company registered in England  Wales.

Registration Number: 2338274.   Registered Office:  6th Floor, One
London Wall, London EC2Y 5EB 
This e-mail

Re: [U2] trimming a list (a test of your ability)

HOLY SMOKES!

X = X : string

Is CRAZY slow! I had to break out.

My results on Unidata/AIX, -1 was SLIGHTLY faster than := for 1,000,000 
appendages to a null table.

Sincerely,
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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green
Sent: Thursday, July 12, 2012 12:25 PM
To: 'U2 Users List'
Subject: Re: [U2] trimming a list (a test of your ability)

Ah, but try it with := instead of Y = Y:

David A. Green
(480) 813-1725
DAG Consulting

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: Thursday, July 12, 2012 8:56 AM
To: U2 Users List
Subject: Re: [U2] trimming a list (a test of your ability)

ROUNDS = 1
LOOP
   X = '' ; Y = ''
   START.TIME = TIME()
   FOR I = 1 TO ROUNDS
  X-1 = I
   NEXT I
   END.TIME = TIME()
   CRT END.TIME-START.TIME :  vs  :
   START.TIME = TIME()
   FOR I = 1 TO ROUNDS
  Y = Y:CHAR(254):I
   NEXT I
   END.TIME = TIME()
   CRT END.TIME-START.TIME
   ROUNDS *= 2
REPEAT



Results suggest that you should od -1, not the multiple concatenation.

Dan McGrath
Product Manager
Rocket Software
4600 S. Ulster Street ..Suite 1100 ..Denver, CO 80237 . USA
t: +1.720.475.8098 . m: +1.617.630.7392 . e:dmcgr...@rocketsoftware.com w:
rocketsoftware.com/u2





-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, July 12, 2012 7:30 AM
To: U2 Users List
Subject: Re: [U2] trimming a list (a test of your ability)

Instead of -1, use  string=string:char(254):additionalelement

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: Thursday, July 12, 2012 9:20 AM
To: Marco Manyevere; U2 Users List
Subject: Re: [U2] trimming a list (a test of your ability)

This is the best solution, using REMOVE and building a new list instead of 
constantly 'shrinking' the original table.

That being said, as NEW.LIST gets rather large, adding new elements to it can 
get 'time' consuming. Just like the REMOVE keeps track of the pointer as you 
spin through a table, I wish there was a comparable statement that kept track 
of the pointer as we added new elements -1 to tables.

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marco Manyevere
Sent: Thursday, July 12, 2012 4:14 AM
To: U2 Users List
Subject: Re: [U2] trimming a list (a test of your ability)

Is this what the OP is asking about or I'm missing something? The 2 code 
fragments look totally different. We dont know what's happening in 
GET.UTILITY.RECORD or the significance of UTILITY.NAME and LAST.NAME to totally 
eliminate them during the 'optimisation'

I would rather do:
 
NEW.LIST = ''
LOOP
  REMOVE UTILITY.ID FROM KEY.LIST SETTING MORE WHILE MORE:UTILITY.ID
  GOSUB GET.UTILITY.RECORD
   IF INDEX(UTILITY.NAME,LAST.NAME,1) = 0 THEN CONTINUE
   NEW.LIST-1 = UTILITY.ID
REPEAT
KEY.LIST = NEW.LIST
NEW.LIST = '' ;* free the memory
 


 From: Kate Stanton k...@walstan.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Thursday, 12 July 2012, 4:27
Subject: Re: [U2] trimming a list (a test of your ability)
  
I am getting sucked in!

NLST =                                                        ;* For new list 
MAXI = DCOUNT(KEY.LIST1,@vM)         ;* Count items FOR INO =1 TO MAXI        
                           ;* Each key in list
  KEY.ID = KEY.LIST1,INO                        ;* A key ID
  LOCATE(KEY.ID,NLST,1;POS;'AL') ELSE  ;* see if there
    INS KEY.ID BEFORE NLIST1,POS       ;* Sort to list
  END
NEXT INO                                                      ;* Check all keys 
On 12 July 2012 12:09, Wjhonson wjhon...@aol.com wrote:


 1295          FOR DISPLAY.LOOP = 1 TO KEY.COUNT
 1296             UTILITY.ID = KEY.LIST1,DISPLAY.LOOP
 1297             GOSUB GET.UTILITY.RECORD
 1298             IF INDEX(UTILITY.NAME,LAST.NAME,1) = 0 THEN
 1299                KEY.LIST = DELETE(KEY.LIST,1,DISPLAY.LOOP,0)
 1300                DISPLAY.LOOP -= 1
 1301                KEY.COUNT -= 1
 1302             END
 1303          NEXT DISPLAY.LOOP


 Comments?


 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users




--
Kate Stanton
Walstan Systems Ltd
4 Kelmarna Ave, Herne Bay

Re: [U2] Exiting UniData

2012-07-03 Thread Dave Davis

Runs the globally cataloged program _SB_SH.OFF

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Tuesday, July 03, 2012 10:31 AM
To: 'U2 Users List'
Subject: [U2] Exiting UniData

Going back to my post about runaway processes:
According to our UniData manuals, the official commands to terminate a UniData 
session are BYE, LO and QUIT.

I have since found that LO and OFF (not sure where this came from) simply run 
the QUIT command.

QUIT runs an SB command called SH.OFF (which we obviously do not have the 
source code to review).

BYE still runs the verb BYE, so nothing different there.

We are using Avanté which obviously is built with SB.

My question is this: do ALL SB sites change the value of QUIT to run SH.OFF, or 
was this something that Epicor does?

If anyone is using SB but NOT using an Epicor product, what does your QUIT 
command do?

Thanks

John
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Dave Davis
Team Lead, RD

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Really trying to understand dynamic file sizing

Doesn't 1% split load seem a little low?

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch
Sent: Thursday, June 28, 2012 8:56 PM
To: U2 Users List
Subject: Re: [U2] Really trying to understand dynamic file sizing

On Thu, Jun 28, 2012 at 6:50 PM, Doug Averch dave...@gmail.com wrote:


 126/4064   (Correction, too late to be working on this)

1  (Correction average Load before split)

And that matches your numbers

Regards,
Doug
www.u2logic.com
___
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

Re: [U2] Really trying to understand dynamic file sizing

Greetings Doug,

This is where my confusion is. The formula that I'm using to compute the
split load does not change, regardless of the block size. And yet you're
saying changing my block size to 2k will change it from 1% to 6%.

So, here's my formula, based on the very informative FAQ from Rocket:

SPLIT = INT(RECORDS PER BLOCK * IDSIZE * 100 / BLOCKSIZE)

SPLIT = INT(1 * 21 * 100 / 2048) = 1
SPLIT = INT(2 * 21 * 100 / 4096) = 1

Given this formula, the split will never change, regardless of the block
size because the RECORDS PER BLOCK will generally increase
proportionally to the BLOCK SIZE.

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch
Sent: Friday, June 29, 2012 1:38 PM
To: U2 Users List
Subject: Re: [U2] Really trying to understand dynamic file sizing

Hi Dave:

You cannot get any lower than one percent.  If you set your block size
to 2K that will fix the split problem making about 6%.  Your average
record size is 1537 which means you will get about one record per block
so split by key will be worthless and you will be into Level 2 and/or
Level 1 overflow.

I have found if you spend a lot of time on one file try to optimize it,
then you had 100K worth of records to the file and your work is does not
matter.  What you want to do is get the file in best shape you can
considering growth and usability, then look at this file or all your
files in a week or month and see what has happened.

Regards,
Doug
www.u2logic.com
XLr8Resizer for fast resizing
___
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

Re: [U2] Really trying to understand dynamic file sizing

Thank you Wally. That's what I was looking for, a 'base' line. 1% or
even 6% seemed low.

Doesn't splitting basically happen when too many keys are hashed to the
same group for KEYONLY hashed files?

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune
Sent: Friday, June 29, 2012 3:06 PM
To: U2 Users List
Subject: Re: [U2] Really trying to understand dynamic file sizing

I wouldn't go below 10%. You could end up with lots of splitting and
very sparsely populated groups.

Wally Terhune
Technical Support Engineer
Rocket Software
4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA
t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w:
rocketsoftware.com/u2




-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch
Sent: Friday, June 29, 2012 11:38 AM
To: U2 Users List
Subject: Re: [U2] Really trying to understand dynamic file sizing

Hi Dave:

You cannot get any lower than one percent.  If you set your block size
to 2K that will fix the split problem making about 6%.  Your average
record size is 1537 which means you will get about one record per block
so split by key will be worthless and you will be into Level 2 and/or
Level 1 overflow.

I have found if you spend a lot of time on one file try to optimize it,
then you had 100K worth of records to the file and your work is does not
matter.  What you want to do is get the file in best shape you can
considering growth and usability, then look at this file or all your
files in a week or month and see what has happened.

Regards,
Doug
www.u2logic.com
XLr8Resizer for fast resizing
___
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

Re: [U2] Really trying to understand dynamic file sizing

Hey Doug,

Thanks for your confirmation of my understanding Wally's adeptness in
Unidata. I always wait anxiously for his replies to these threads.

I believe the *100 simply gets the percentage to a whole number so the
INT() works.

I am indeed going to go to the 8k block size to reduce the % of 'wasted'
space to  2%. That just seems like a reasonable without going all the
way to 16k blocks.

I'm also going to increase the modulo by 20% from the number of records
so it will have a little extra room to grow over the next few months.

I'll probably configure the SPLIT for 10% and MERGE for 5% unless
someone discourages me before noon tomorrow. That's when I'm pulling the
trigger on this resize.

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch
Sent: Friday, June 29, 2012 4:17 PM
To: U2 Users List
Subject: Re: [U2] Really trying to understand dynamic file sizing

Hi Dave and others:

Having worked for Wally many years ago at Unidata, his knowledge is
unparalleled about Unidata.  So given that I've been doing this for a
number of years, I'm not sure where the 100 number is coming.  The other
numbers I have reams of paper, CD's, and thumb drives backing up all of
the other numbers.

I have tested many a file with different blocks sizes with the same data
either adding or subtracting records.  I found the split and merge to
not
happen when I would expect it to.   If you put more keys into a smaller
modulo the percentage will change because you are using KEYONLY.

Your record size is quite large so that is why going to a 2K block size
will make things worse.  I would recommend going to a 8K block size
leaving the current modulo since you a near 100% overflow.  You can try
it on a temporary file and either tell me I'm wrong or I'm right.

Regards,
Doug
www.u2logic.com/tools.html

___
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] Really trying to understand dynamic file sizing

2012-06-28 Thread Dave Laansma

I've only got a handful of dynamic files but of course they're huge and
have a big impact on our daily and monthly processing. I'd REALLY like
to understand the tuning mechanisms for these files, specifically
SPLIT/MERGE.

 

The formulas that I got on previous responses just don't seem to make
sense on one particular file.

 

So here's a FILE.STAT and ANALYZE.FILE of a file that I believe is in
need of resizing and/or reconfiguring. I believe that if I can get some
input on this file, I'll be able to apply that knowledge to my other
files.

 

First, I understand quite clearly that the modulo of 235889 is about
half of what it should be, at least for a block size of 4096.

 

Second, unless I'm doing something wrong, I computed my SPLIT LOAD to be
1, which just doesn't seem right.

 

I'd like to resize this file this weekend and I know that if I do one
thing incorrectly it could make my performance even worse.

 

Any input would be greatly appreciated.

 

File name(Dynamic File)   = OH

Number of groups in file (modulo) = 235889

Dynamic hashing, hash type= 0

Split/Merge type  = KEYONLY

Block size= 4096

File has 234167 groups in level one overflow.

Number of records = 1387389

Total number of bytes = 2132217978

 

Average number of records per group   = 5.9

Standard deviation from average   = 1.6

Average number of bytes per group = 9039.1

Standard deviation from average   = 9949.2

 

Average number of bytes in a record   = 1536.9

Average number of bytes in record ID  = 12.4

Standard deviation from average   = 4009.7

Minimum number of bytes in a record   = 659

Maximum number of bytes in a record   = 2205579

 

Minimum number of fields in a record  = 237

Maximum number of fields in a record  = 414

Average number of fields per record   = 328.3

Standard deviation from average   = 32.0

 

Dynamic File name = OH

Number of groups in file (modulo) = 235889

Minimum groups of file= 235889

Hash type = 0, blocksize = 4096

Split load = 10, Merge load = 5

Split/Merge type = KEYONLY

 

 

Sincerely,

David Laansma

IT Manager

Hubbard Supply Co.

Direct: 810-342-7143

Office: 810-234-8681

Fax: 810-234-6142

www.hubbardsupply.com http://www.hubbardsupply.com 

Delivering Products, Services and Innovative Solutions

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Learning about file sizing

2012-06-25 Thread Dave Laansma

 or lower
split load percent than was calculated.  
 
 
 
  

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: Tuesday, June 05, 2012 12:33 PM
To: U2-Users@listserver.u2ug.org
Subject: [U2] Learning about file sizing

Can anyone point me to a good document that will give me guidelines for
'proper' file sizing of dynamic files in particular?

 

And when to use KEYONLY vs KEYDATA?

 

Thanks!

 

Sincerely,

David Laansma

IT Manager

Hubbard Supply Co.

Direct: 810-342-7143

Office: 810-234-8681

Fax: 810-234-6142

www.hubbardsupply.com http://www.hubbardsupply.com 

Delivering Products, Services and Innovative Solutions

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


--
CONFIDENTIALITY NOTICE: If you have received this email in error, please
immediately notify the sender by e-mail at the address shown.  
This email transmission may contain confidential information.  This
information is intended only for the use of the individual(s) or entity
to whom it is intended even if addressed incorrectly.  Please delete it
from your files if you are not the intended recipient.  Thank you for
your compliance.  Copyright (c) 2012 Cigna

==

___
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

Re: [U2] Regarding: Unidata dictionaries

2012-06-21 Thread Dave Davis

Create a dialog definition and use an expression to contain your message.  Put 
your text in @VALUE.  Use the DIALOG process to display the definition.  It 
should work fine.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce
Sent: Thursday, June 21, 2012 1:55 PM
To: 'U2 Users List'
Subject: Re: [U2] Regarding: Unidata dictionaries

I have just come across a problem that is sort of related to the problem
with UniQuery and single quotes noted in Dan's article. I thought that I
would share what is happening to see if there is an answer.

We are using Unidata 7.1 and SB+ 5.3. I have written a Basic program to
extract a file and when it finishes I will either display the error message
or if it was successful I want to print a message that tells them that they
can find their file at C:\WINDOWS\TEMP\filename.xml. The method that I use
for displaying the messages is CALL SB.DISP(4,message here). When I run
the job it does not display the message but if I remove the '\' characters
it works fine. Is there some way to get this message to display without
removing the '\' characters?

I find it very interesting that I have never seen this problem before and
then the very next day after reading the article by Dan McGrath it happens
to me.

Thanks in advance,
Bruce

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: Wednesday, June 20, 2012 12:25 PM
To: U2 Users List
Subject: Re: [U2] Regarding: Unidata dictionaries

Satya,

I have a small write up I did a while ago that might help you:
http://u2tech.wordpress.com/tips-hints/dictionary-tips-hints/

Regards,
Dan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of satya satya
Sent: Wednesday, June 20, 2012 10:18 AM
To: U2 Users List
Subject: [U2] Regarding: Unidata dictionaries

Hi,

Could you let,me know what is the difference between PH- type records,
D-type records,V-type records,X-type records

Thank you,
Satya
___
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

Dave Davis
Team Lead, RD

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Can of worms FILE.STATUS

2012-06-20 Thread Dave Laansma

Mecki,

What block size and why?

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki
Foerthmann
Sent: Wednesday, June 20, 2012 12:45 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Can of worms FILE.STATUS

Nothing really -  less than 10% overflow is not too bad.
I would have chosen a smaller block size though.

On 20/06/2012 17:20, Dave Laansma wrote:
 I have my thoughts already in place but I'd like to hear input on
this.
 What is wrong with this file?



 File name(Dynamic File)   = OHL

 Number of groups in file (modulo) = 740972

 Dynamic hashing, hash type= 0

 Split/Merge type  = KEYONLY

 Block size= 4096

 File has 455028 groups in level one overflow.

 Number of records = 4835502

 Total number of bytes = 3100999567



 Average number of records per group   = 6.5

 Standard deviation from average   = 2.4

 Average number of bytes per group = 4185.0

 Standard deviation from average   = 1856.2



 Average number of bytes in a record   = 641.3

 Average number of bytes in record ID  = 14.8

 Standard deviation from average   = 283.6

 Minimum number of bytes in a record   = 133

 Maximum number of bytes in a record   = 8622



 Minimum number of fields in a record  = 110

 Maximum number of fields in a record  = 334

 Average number of fields per record   = 218.3

 Standard deviation from average   = 47.9

 File has 2 over files, 3 prime files



 Sincerely,

 David Laansma

 IT Manager

 Hubbard Supply Co.

 Direct: 810-342-7143

 Office: 810-234-8681

 Fax: 810-234-6142

 www.hubbardsupply.comhttp://www.hubbardsupply.com

 Delivering Products, Services and Innovative Solutions



 ___
 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

Re: [U2] Regarding : Usage of the SEL.CMD

2012-06-08 Thread Dave Laansma

Just my two-cents, this would have been a much more appropriate FIRST response 
to Satya's humble request.

He/she is clearly new and needs additional training and experience. Does anyone 
have any suggestions for Satya to obtain said training?

Sincerely,
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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Paul Wilson
Sent: Friday, June 08, 2012 10:51 AM
To: satya satya
Cc: U2 Users List
Subject: Re: [U2] Regarding : Usage of the SEL.CMD

http://www.rocketsoftware.com/u2/resources/technical-resources
 
Here's the link to the manuals
 


 From: Paul Wilson sfr192...@yahoo.com
To: satya satya satyapal...@gmail.com 
Cc: U2 Users List u2-users@listserver.u2ug.org 
Sent: Friday, June 8, 2012 10:49 AM
Subject: Re: [U2] Regarding : Usage of the SEL.CMD
  

Read the Fu..ing Manual 
 
You ask an obtuse question about code that you are working on - since noone 
else has seen the code - how do you expect a 'quality' and/or defined response.
 
Also - the manuals are FREE and downloadable off Rocket's website - 
http://www.rocketsoftware.com/u2/resources/downloads
 


 From: satya satya satyapal...@gmail.com
To: Paul Wilson sfr192...@yahoo.com 
Sent: Friday, June 8, 2012 10:43 AM
Subject: Re: [U2] Regarding : Usage of the SEL.CMD
  

Hi Paul Wilson,

What is This RTFM i have never heard about it.

Thank you,
Satya


On Fri, Jun 8, 2012 at 8:09 PM, Paul Wilson sfr192...@yahoo.com wrote:

RTFM - just like everyone else !! 

 
 From: satya satya satyapal...@gmail.com
To: U2 Users List u2-users@listserver.u2ug.org 
Sent: Friday, June 8, 2012 10:31 AM
Subject: [U2] Regarding : Usage of the SEL.CMD
 

Hi Everyone,

Can any  Explain What is the use of  SEL .CMD? In the program i have
observed many times using this statement. but i didn't getting clarity on
it. So Let, me know your valuable suggestions on this topic.

Thank you,
Satya.
___
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] Learning about file sizing

2012-06-05 Thread Dave Laansma

Can anyone point me to a good document that will give me guidelines for
'proper' file sizing of dynamic files in particular?

 

And when to use KEYONLY vs KEYDATA?

 

Thanks!

 

Sincerely,

David Laansma

IT Manager

Hubbard Supply Co.

Direct: 810-342-7143

Office: 810-234-8681

Fax: 810-234-6142

www.hubbardsupply.com http://www.hubbardsupply.com 

Delivering Products, Services and Innovative Solutions

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Dave Laansma

I have a file that is taking a very long time to update, seemingly
longer and longer each month. Here is briefly how the attributes are
organized, a relatively simple example:

 

Attribute 1 is multivalued with our G/L Period, i.e. 12-01 vm 12-02 vm
12-03 etc.

Attributes 2 through 30 are dependent on attribute 1 and contain a
variety of dollar amounts that are accumulated for the respective period
in attribute 1.

 

At the end of each month, a new G/L Period is inserted into the
multivalued position of attribute 1 as well as each of the respective
multivalued positions in attributes 2 through 30. Nothing complicated.

 

My question is this and is aimed largely at the technicians at Rocket
...

 

If, at the beginning of the year, I were to insert each of the
12-periods into their respective multivalues in attribute 1 and insert
respective null multivalues into attributes 2 through 30, thus
performing all of the 'inserts' at once, will the processing each month
run faster as numbers are simply accumulated into attributes 2 through
30 and no inserting of new multivalues will have to be performed?

 

A couple nuggets of information:

 

This is only an example. In the actual file, these records contain many
other attributes and the records overall are relatively large, averaging
lengths of about 3,000 according to FILE.STAT

These are not my files so reorganizing them is not an option.

 

The heart of this question is, as a (numeric) number is accumulated in
an attribute, multivalue or subvalue, what causes the record to
'stretch' in length, thus presumably impacting performance?

 

I would like to think that numeric information is stored in a more
'compact' method than strings, thus using less space within the database
... but what I 'like' and what 'is' are often quite different.

 

Thanks!

 

Sincerely,

David Laansma

IT Manager

Hubbard Supply Co.

Direct: 810-342-7143

Office: 810-234-8681

Fax: 810-234-6142

www.hubbardsupply.com http://www.hubbardsupply.com 

Delivering Products, Services and Innovative Solutions

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Dave Davis

You are probably better off sizing the file correctly, or sizing it to the size 
it will be at the end of the year, than trying to do what you are proposing.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: Friday, June 01, 2012 10:30 AM
To: U2-Users@listserver.u2ug.org
Subject: [U2] Monthly Multivalue Inserts and Speed

I have a file that is taking a very long time to update, seemingly
longer and longer each month. Here is briefly how the attributes are
organized, a relatively simple example:

Attribute 1 is multivalued with our G/L Period, i.e. 12-01 vm 12-02 vm
12-03 etc.

Attributes 2 through 30 are dependent on attribute 1 and contain a
variety of dollar amounts that are accumulated for the respective period
in attribute 1.

At the end of each month, a new G/L Period is inserted into the
multivalued position of attribute 1 as well as each of the respective
multivalued positions in attributes 2 through 30. Nothing complicated.

My question is this and is aimed largely at the technicians at Rocket
...

If, at the beginning of the year, I were to insert each of the
12-periods into their respective multivalues in attribute 1 and insert
respective null multivalues into attributes 2 through 30, thus
performing all of the 'inserts' at once, will the processing each month
run faster as numbers are simply accumulated into attributes 2 through
30 and no inserting of new multivalues will have to be performed?

A couple nuggets of information:

This is only an example. In the actual file, these records contain many
other attributes and the records overall are relatively large, averaging
lengths of about 3,000 according to FILE.STAT

These are not my files so reorganizing them is not an option.

The heart of this question is, as a (numeric) number is accumulated in
an attribute, multivalue or subvalue, what causes the record to
'stretch' in length, thus presumably impacting performance?

I would like to think that numeric information is stored in a more
'compact' method than strings, thus using less space within the database
... but what I 'like' and what 'is' are often quite different.

Thanks!

Sincerely,

David Laansma

IT Manager

Hubbard Supply Co.

Direct: 810-342-7143

Office: 810-234-8681

Fax: 810-234-6142

www.hubbardsupply.com http://www.hubbardsupply.com

Delivering Products, Services and Innovative Solutions

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Dave Davis
Team Lead, RD

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Dave Laansma

Results of the ANALYZE.FILE:

Dynamic File name = WHSE.STAT
Number of groups in file (modulo) = 67801
Minimum groups of file= 67801
Hash type = 0, blocksize = 16384
Split load = 10, Merge load = 5
Split/Merge type = KEYONLY

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L.
Wasylenko
Sent: Friday, June 01, 2012 10:32 AM
To: U2 Users List
Subject: Re: [U2] Monthly Multivalue Inserts and Speed

3k isn't large.
#1 thing to look at is file size.

Change the file-type to dynamic.  It will not give the best performance
compared to monitoring file size of a static file type, but over the
long-term, avoids sizing issues that are the #1 reason for bad
performance.

Can you perform an ANALYZE.FILE {filename}  and post the result?

... david ...

David L. Wasylenko
President, Pick Professionals, Inc
w) 314 558 1482
d...@pickpro.com


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: Friday, June 01, 2012 9:30 AM
To: U2-Users@listserver.u2ug.org
Subject: [U2] Monthly Multivalue Inserts and Speed

I have a file that is taking a very long time to update, seemingly
longer and longer each month. Here is briefly how the attributes are
organized, a relatively simple example:

 

Attribute 1 is multivalued with our G/L Period, i.e. 12-01 vm 12-02 vm
12-03 etc.

Attributes 2 through 30 are dependent on attribute 1 and contain a
variety of dollar amounts that are accumulated for the respective period
in attribute 1.

 

At the end of each month, a new G/L Period is inserted into the
multivalued position of attribute 1 as well as each of the respective
multivalued positions in attributes 2 through 30. Nothing complicated.

 

My question is this and is aimed largely at the technicians at Rocket
...

 

If, at the beginning of the year, I were to insert each of the
12-periods into their respective multivalues in attribute 1 and insert
respective null multivalues into attributes 2 through 30, thus
performing all of the 'inserts' at once, will the processing each month
run faster as numbers are simply accumulated into attributes 2 through
30 and no inserting of new multivalues will have to be performed?

 

A couple nuggets of information:

 

This is only an example. In the actual file, these records contain many
other attributes and the records overall are relatively large, averaging
lengths of about 3,000 according to FILE.STAT

These are not my files so reorganizing them is not an option.

 

The heart of this question is, as a (numeric) number is accumulated in
an attribute, multivalue or subvalue, what causes the record to
'stretch' in length, thus presumably impacting performance?

 

I would like to think that numeric information is stored in a more
'compact' method than strings, thus using less space within the database
... but what I 'like' and what 'is' are often quite different.

 

Thanks!

 

Sincerely,

David Laansma

IT Manager

Hubbard Supply Co.

Direct: 810-342-7143

Office: 810-234-8681

Fax: 810-234-6142

www.hubbardsupply.com http://www.hubbardsupply.com 

Delivering Products, Services and Innovative Solutions

 

___
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

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Dave Laansma

FILE.STAT results:

  MOD OV HTY   ITEMS   BYTES MNI/G MXI/G MNB/I MXB/I
67801  0  64  731825 2197829057 02719 14300

---- ---
67801 731825 2197829057

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L.
Wasylenko
Sent: Friday, June 01, 2012 12:07 PM
To: U2 Users List
Subject: Re: [U2] Monthly Multivalue Inserts and Speed

What's the record count and total byte count?

... david ...

David L. Wasylenko
President, Pick Professionals, Inc
w) 314 558 1482
d...@pickpro.com


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: Friday, June 01, 2012 9:41 AM
To: U2 Users List
Subject: Re: [U2] Monthly Multivalue Inserts and Speed

Results of the ANALYZE.FILE:

Dynamic File name = WHSE.STAT
Number of groups in file (modulo) = 67801
Minimum groups of file= 67801
Hash type = 0, blocksize = 16384
Split load = 10, Merge load = 5
Split/Merge type = KEYONLY

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L.
Wasylenko
Sent: Friday, June 01, 2012 10:32 AM
To: U2 Users List
Subject: Re: [U2] Monthly Multivalue Inserts and Speed

3k isn't large.
#1 thing to look at is file size.

Change the file-type to dynamic.  It will not give the best performance
compared to monitoring file size of a static file type, but over the
long-term, avoids sizing issues that are the #1 reason for bad
performance.

Can you perform an ANALYZE.FILE {filename}  and post the result?

... david ...

David L. Wasylenko
President, Pick Professionals, Inc
w) 314 558 1482
d...@pickpro.com


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: Friday, June 01, 2012 9:30 AM
To: U2-Users@listserver.u2ug.org
Subject: [U2] Monthly Multivalue Inserts and Speed

I have a file that is taking a very long time to update, seemingly
longer and longer each month. Here is briefly how the attributes are
organized, a relatively simple example:

 

Attribute 1 is multivalued with our G/L Period, i.e. 12-01 vm 12-02 vm
12-03 etc.

Attributes 2 through 30 are dependent on attribute 1 and contain a
variety of dollar amounts that are accumulated for the respective period
in attribute 1.

 

At the end of each month, a new G/L Period is inserted into the
multivalued position of attribute 1 as well as each of the respective
multivalued positions in attributes 2 through 30. Nothing complicated.

 

My question is this and is aimed largely at the technicians at Rocket
...

 

If, at the beginning of the year, I were to insert each of the
12-periods into their respective multivalues in attribute 1 and insert
respective null multivalues into attributes 2 through 30, thus
performing all of the 'inserts' at once, will the processing each month
run faster as numbers are simply accumulated into attributes 2 through
30 and no inserting of new multivalues will have to be performed?

 

A couple nuggets of information:

 

This is only an example. In the actual file, these records contain many
other attributes and the records overall are relatively large, averaging
lengths of about 3,000 according to FILE.STAT

These are not my files so reorganizing them is not an option.

 

The heart of this question is, as a (numeric) number is accumulated in
an attribute, multivalue or subvalue, what causes the record to
'stretch' in length, thus presumably impacting performance?

 

I would like to think that numeric information is stored in a more
'compact' method than strings, thus using less space within the database
... but what I 'like' and what 'is' are often quite different.

 

Thanks!

 

Sincerely,

David Laansma

IT Manager

Hubbard Supply Co.

Direct: 810-342-7143

Office: 810-234-8681

Fax: 810-234-6142

www.hubbardsupply.com http://www.hubbardsupply.com 

Delivering Products, Services and Innovative Solutions

 

___
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

Re: [U2] Excel Worksheets

2012-06-01 Thread Dave Davis

That would be nice.

I create separate CSV files and use macros to load each into a separate sheet.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jim Koca
Sent: Saturday, June 02, 2012 3:17 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Excel Worksheets

I am sending a CSV file to excel, and would like to divide it into separate
worksheets. Is there a special value I can insert in the file which would
cause the following data to create a separate work sheet ?

Thanks,

Jim Koca

Cell Phone: 630.253.0007
Home Office: 630.629.5589
Email: jk...@comcast.net

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Dave Davis
Team Lead, RD

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] READU vs READ

2012-05-01 Thread Dave Laansma

Thank you Colin. I wouldn't post these types of 'issues' if I were
thin-skinned and didn't appreciate input.

There are certainly some efficiencies in the updating of the
multi-values. Unfortunately I cannot reorganize the data in the records,
only the code that updates said data.

I'll consider posting it. Names will have to be changed to protect 'the
innocent' copyright.

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke
Sent: Tuesday, May 01, 2012 10:05 AM
To: 'U2 Users List'
Subject: Re: [U2] READU vs READ

Dave;

A couple more things:
 - do you have any other processes running at the same time? I found
(long
ago) that a couple of our big processes ran 5X faster consecutively than
they did concurrently.
 - subroutine calls with file opens. I inherited a process that was
running for 3 days and was 65% done. I put all of the file opens in
common (well, the file variables) and re-ran in hours.

You may want to re-think posting some of the code. There can be some
efficiencies found in processing large dynamic arrays. You said it
wasn't code you wrote - so try to take the criticism as constructive :)

hth
Colin

-Original Message-
From: Tom Whitmore
Sent: May 1, 2012 5:50 AM
To: U2 Users List
Subject: Re: [U2] READU vs READ

Hi,
The question of READU vs READ when you are doing updates is moot.  If
you do a READ then a WRITE, UniVerse/UniData will perform the record
lock.  The only difference is with READ you are gambling that no one
else is updating the record before you perform your WRITE.

Performance, as others suggested, there are several things to do: 
Tune your files.  
If you are using dynamic files, make sure you have the
MINIMUM.MODULUS set to reduce the shrink and merging
If the records are lumpy redesign them so you have a header file
and a detail file, with detail files being individual records for the
associated values. 
Use LIST.INDEX with the STATISTICS option to see if you have huge
index value, you may need to refine the index.  
Check your hardware, you may have a bottleneck due to slow disk, I/O
pipe.
Minimize the number of times you go through the associated values.  
Use READU with the LOCKED clause, if the record is locked, add
logic to queue it up and try the records again once everything else is
processed (WRITEs will hang on a lock if you don't have the LOCKED
clause, just like a READU without the LOCKED clause.

Good luck!
Tom
RATEX Business Solutions

-Original Message-
From: Symeon Breen

Have you been able to do any os level tools to see what the utilisation
of resources is. E.g. on linux, vmstat, top, iostat will show you if it
is a diskio or cpu bottleneck.  If it is diskio (i.e. high wait on io
times) then you may need to upgrade the disks or add more ram so you
have more data in cache.


-Original Message-
From: Dave Laansma

Oh ... you're good ... I ALMOST pasted it ...

I know better that to put even FICTITIOUS code on this board ... unless
I'm just trying to rile things up about the OS. |-)

I do appreciate all of the input. Thank y'all for the info. I'll see
what I can do.

Sincerely,
David Laansma


___
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] READU vs READ

If I don't HAVE TO lock a record before modifying it writing it back,
will a program run significantly faster if I just WRITE it back without
locking it first? I'm updating about 700,000 records and it's just
taking TOO long.

 

I DO understand the risks of other users changing the record's content
during so let's not go down that road. I'm interested in the SPEED
dialog.

 

Thank you folks!

 

Sincerely,

David Laansma

IT Manager

Hubbard Supply Co.

Direct: 810-342-7143

Office: 810-234-8681

Fax: 810-234-6142

www.hubbardsupply.com http://www.hubbardsupply.com 

Delivering Products, Services and Innovative Solutions

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] READU vs READ

Understood about the screen I/O ... def not an issue here.

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, April 30, 2012 8:40 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] READU vs READ


Remove the line that after each read says xxx record written
Terminal I/O is 100 times more expensive than reading and writing








-Original Message-
From: Dave Laansma dlaan...@hubbardsupply.com
To: U2-Users U2-Users@listserver.u2ug.org
Sent: Mon, Apr 30, 2012 5:32 pm
Subject: [U2] READU vs READ


If I don't HAVE TO lock a record before modifying it writing it back,
ill a program run significantly faster if I just WRITE it back without
ocking it first? I'm updating about 700,000 records and it's just aking
TOO long.
 
I DO understand the risks of other users changing the record's content
uring so let's not go down that road. I'm interested in the SPEED ialog.
 
Thank you folks!
 
Sincerely,
David Laansma
IT Manager
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com http://www.hubbardsupply.com Delivering
Products, Services and Innovative Solutions
 
___
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://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

Re: [U2] READU vs READ

Yes, using SELECT and READNEXT. These are sizable records. The logic is
very straight forward, just updating several multi-valued fields in each
record (month end).

500,000 have been updated and I'm 2:45:00 into the process.

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy
(Contractor, Logitek Systems)
Sent: Monday, April 30, 2012 8:48 PM
To: U2 Users List
Subject: Re: [U2] READU vs READ

Depends on how much twisted logic you have...   Seriously, I would
guess that your bottleneck is disk access.

Are you using basic SELECT and READNEXT ?   Is your list in sorted order
(SSELECT) or not (SELECT).

Processing the updates in group order will minimize the I/O.   I don't
think the READU overhead on today's machines are anything that would
slow it down.   I just tested 100,000 records with and without locking
and I get six seconds both ways.   Because it was cached data, my test
eliminates disk i/o and measures the lock overhead which seems to be
negligible on universe 11.1.1.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: Monday, April 30, 2012 5:33 PM
To: U2-Users@listserver.u2ug.org
Subject: [U2] READU vs READ

If I don't HAVE TO lock a record before modifying it writing it back,
will a program run significantly faster if I just WRITE it back without
locking it first? I'm updating about 700,000 records and it's just
taking TOO long.

 

I DO understand the risks of other users changing the record's content
during so let's not go down that road. I'm interested in the SPEED
dialog.

 

Thank you folks!

 

Sincerely,

David Laansma

IT Manager

Hubbard Supply Co.

Direct: 810-342-7143

Office: 810-234-8681

Fax: 810-234-6142

www.hubbardsupply.com http://www.hubbardsupply.com 

Delivering Products, Services and Innovative Solutions

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


_
Scanned by IBM Email Security Management Services powered by
MessageLabs. For more information please visit http://www.ers.ibm.com

This email is intended only for the use of the party to which it is
addressed and may contain information that is privileged, confidential,
or protected by law.  If you are not the intended recipient you are
hereby notified that any dissemination, copying or distribution of the
email or its contents is strictly prohibited.  If you have received this
message in error, please notify us immediately, by replying to the
message and deleting it from your computer.

WARNING: Internet communications are not assured to be secure or clear
of inaccuracies as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses.  Therefore, we
do not accept responsibility for any errors or omissions that are
present in this email, or any attachment, that have arisen as a result
of e-mail transmission.

_
___
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

Re: [U2] READU vs READ

It's a dynamic file. FILE-STAT shows no overflow.

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy
(Contractor, Logitek Systems)
Sent: Monday, April 30, 2012 9:12 PM
To: U2 Users List
Subject: Re: [U2] READU vs READ

Inefficient file sizing and disk I/O are your possible issues with
slowness.   You might be able to address the first at your desk, the
latter may require a purchase order. How old is your hardware?

We recently upgraded to a virtual server and just using more current
technology hard drives we doubled all of our disk I/O from what we had 5
or 6 years ago.  CPU speed increased as well, but that was not as
suprising.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: Monday, April 30, 2012 6:01 PM
To: U2 Users List
Subject: Re: [U2] READU vs READ

Yes, using SELECT and READNEXT. These are sizable records. The logic is
very straight forward, just updating several multi-valued fields in each
record (month end).

500,000 have been updated and I'm 2:45:00 into the process.



_
Scanned by IBM Email Security Management Services powered by
MessageLabs. For more information please visit http://www.ers.ibm.com

This email is intended only for the use of the party to which it is
addressed and may contain information that is privileged, confidential,
or protected by law.  If you are not the intended recipient you are
hereby notified that any dissemination, copying or distribution of the
email or its contents is strictly prohibited.  If you have received this
message in error, please notify us immediately, by replying to the
message and deleting it from your computer.

WARNING: Internet communications are not assured to be secure or clear
of inaccuracies as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses.  Therefore, we
do not accept responsibility for any errors or omissions that are
present in this email, or any attachment, that have arisen as a result
of e-mail transmission.

_
___
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

Re: [U2] READU vs READ

No indexes and no triggers.

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott
Sent: Monday, April 30, 2012 9:22 PM
To: U2 Users List
Subject: Re: [U2] READU vs READ

Add to the mix indexes and triggers. They can both add to the time
needed to update just one record.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy
(Contractor, Logitek Systems)
Sent: Tuesday, 1 May 2012 11:12 AM
To: U2 Users List
Subject: Re: [U2] READU vs READ

Inefficient file sizing and disk I/O are your possible issues with
slowness.   You might be able to address the first at your desk, the
latter may require a purchase order. How old is your hardware?

We recently upgraded to a virtual server and just using more current
technology hard drives we doubled all of our disk I/O from what we had 5
or 6 years ago.  CPU speed increased as well, but that was not as
suprising.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: Monday, April 30, 2012 6:01 PM
To: U2 Users List
Subject: Re: [U2] READU vs READ

Yes, using SELECT and READNEXT. These are sizable records. The logic is
very straight forward, just updating several multi-valued fields in each
record (month end).

500,000 have been updated and I'm 2:45:00 into the process.



_
Scanned by IBM Email Security Management Services powered by
MessageLabs. For more information please visit http://www.ers.ibm.com

This email is intended only for the use of the party to which it is
addressed and may contain information that is privileged, confidential,
or protected by law.  If you are not the intended recipient you are
hereby notified that any dissemination, copying or distribution of the
email or its contents is strictly prohibited.  If you have received this
message in error, please notify us immediately, by replying to the
message and deleting it from your computer.

WARNING: Internet communications are not assured to be secure or clear
of inaccuracies as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses.  Therefore, we
do not accept responsibility for any errors or omissions that are
present in this email, or any attachment, that have arisen as a result
of e-mail transmission.

_
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
--
Message  protected by DealerGuard: e-mail anti-virus, anti-spam and
content filtering.
http://www.pentanasolutions.com

Click here to report this message as spam:
https://login.mailguard.com.au/report/1EE0zigg55/70gcZxRJUITQXy3UHcVFYT/
0.002


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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] READU vs READ

I learned terminal I/O problems last millennium.

Unfortunately I wrote neither the code nor did I design the files. I
just want to speed the silly thing up.

It also appears that each record is getting several MVs added, so each
record is effectively getting larger with each WRITE ... yea ... :-/ ...
it must have seemed like a good idea at the time.

(My apologies for whining)

Sincerely,
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Monday, April 30, 2012 9:22 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] READU vs READ

(Saw other responses come in as I was writing this - oh well, this might
help someone else...)

 From: Dave Laansma
 If I don't HAVE TO lock a record before modifying it writing it
back, will a
 program run significantly faster if I just WRITE it back without
locking it
 first? I'm updating about 700,000 records and it's just taking TOO
long.
 
 I DO understand the risks of other users changing the record's
content
 during so let's not go down that road. I'm interested in the SPEED 
 dialog.

I don't know what you meant by SPEED dialog but if WJ is right and
you're displaying an item count as you run through records, then he is
also right that that IO will destroy performance.

Try this as related experiment: Loop to display the numbers 1 through
1 million. Watch it stream on your terminal emulator. Now run it again,
minimize the emulator, then re-normalize it. I believe you will find
that while the output was hidden it streamed through most or all of the
output. Same thing happens if you're doing a copy or delete and tapping
your fingers as you wait for the IDs to  stream by - a watched kettle
takes longer to boil... :)

About READU vs READ... You're doing a READU just because you're doing a
WRITE? Nah, if you don't care about contentions don't bother to ReadU.
You're reading and updating lock tables and semaphors with READU and
that's huge performance hit.

Here's another experiment: When you're copying or restoring items, use
the appropriate option to overlay items, even if you know the target
file is empty. Why? Because Copy needs to do a Read first to see if it
needs to warn you about an existing item. If you tell it to overlay it
will just do the Write (sure, there's a lower level read there anyway
but less code is executed).

Combining these... if you use a Copy (Pick flavor, don't recall options
otherwise) with both overlay and ID suppress, it avoids a ton of
internal DBMS code, so it goes a lot faster than a no-option copy.

I haven't benched those scenarios for years. If anyone does the tests,
please let us know if this is valid or not, and your DBMS/flavors.

T

___
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

Re: [U2] READU vs READ