Re: [U2] unidata index

2014-03-13 Thread Dave Laansma
I do not believe so. I believe an index is only used during the SELECT statement and then only when the indexed field is the only field in the select criteria. So, if practical, use the indexed field in the first selection of the file, then all records will be in sorted order of the indexed fie

Re: [U2] Reporting Tools

2014-02-28 Thread Dave Laansma
Two things. First I tend to agree with the number of columns. Perhaps the report is trying to do more than just a couple of things. Consider evaluating the various uses of this report and producing more, smaller reports that provide only what the needs are. Second, I'm a programmer so I just pr

Re: [U2] Accuterm the Web version

2013-12-23 Thread Dave Laansma
Please elaborate. What exactly does Pete say. 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.or

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Dave Laansma
Frankly, this doesn't look like a very big file at all, and I'm amazed you're getting any 'performance' out of it at all with all those OVER files. Crazy! Sincerely, David Laansma Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com "Delivering Prod

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Dave Laansma
Agreed, the first step is to create the file so there are as many DAT files as necessary and only one or two OVER files. Once you've done that, copied all of the records over to the new file and it remains with only one or two OVER files, THEN do some analytics to establish the SPLIT/MERGE and t

Re: [U2] : Evaluating DCOUNT

2013-02-12 Thread Dave Laansma
g, 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.

Re: [U2] : Evaluating DCOUNT

2013-02-12 Thread Dave Laansma
ght 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 could > change within the loop. > > Personally if the size of is relat

Re: [U2] : Evaluating DCOUNT

2013-02-11 Thread Dave Laansma
f 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 wrote: > I would HOPE that it evaluates it each time since the size of could > change within the loop. &g

Re: [U2] : Evaluating DCOUNT

2013-02-11 Thread Dave Laansma
I would HOPE that it evaluates it each time since the size of could change within the loop. Personally if the size of is relatively small, DCOUNT is alright. However I've found REMOVE to be EXTREMELY faster and therefore use it whenever possible, even on small . For example, we have two file

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

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] O

Re: [U2] Inverting/Pivoting a table

2012-09-10 Thread Dave Laansma
:-) 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...@lis

Re: [U2] Inverting/Pivoting a table

2012-09-10 Thread Dave Laansma
f 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 L

Re: [U2] Inverting/Pivoting a table

2012-09-10 Thread Dave Laansma
g] 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

Re: [U2] Inverting/Pivoting a table

2012-09-10 Thread Dave Laansma
Lists To: u2-users 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 the

[U2] Inverting/Pivoting a table

2012-09-10 Thread Dave Laansma
I get flat files that I'd like to 'flip' to accommodate the multi-value database. For example, given this table: 123456DAVID JONES1234 MAIN ST.ANYWHEREMI12345 654321JOHN SMITH4321 MAIN ST.ANYWHEREMI12345 Is there a function that will change it to: 123456654321 DAVID JONESJOHN SMITH 1

Re: [U2] CSV to Array

2012-08-16 Thread Dave Laansma
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...@listser

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.

[U2] If dynamic files NEVER have to be resized ...

2012-07-20 Thread Dave Laansma
... then always create all dynamic files with a module of 1. This seems logical and easy for the administrator. I think this is ludicrous (because I needed a laugh this morning) and proves the point that modulo is an essential part of a properly defined and well configured dynamic file. Si

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

2012-07-12 Thread Dave Laansma
: 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.u2

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

2012-07-12 Thread Dave Laansma
ng 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...

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

2012-07-12 Thread Dave Laansma
ility) 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

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

2012-07-12 Thread Dave Laansma
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,

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

2012-06-29 Thread Dave Laansma
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 '

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

2012-06-29 Thread Dave Laansma
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 Fa

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

2012-06-29 Thread Dave Laansma
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:

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

2012-06-29 Thread Dave Laansma
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.u

[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 sen

Re: [U2] Learning about file sizing

2012-06-25 Thread Dave Laansma
-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 tha

Re: [U2] Can of worms FILE.STATUS

2012-06-20 Thread Dave Laansma
ize 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 > &

[U2] Can of worms FILE.STATUS

2012-06-20 Thread Dave Laansma
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 si

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

Re: [U2] Learning about file sizing

2012-06-06 Thread Dave Laansma
tions" -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Wednesday, June 06, 2012 2:57 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Learning about file sizing On 05/06/12 18:33, Dave Laansma wr

[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-61

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Dave Laansma
o: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

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Dave Laansma
nal 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

[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 dependen

Re: [U2] READU vs READ

2012-05-01 Thread Dave Laansma
ces 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 goo

Re: [U2] READU vs READ

2012-04-30 Thread Dave Laansma
cords were sizeable and that raises my eyebrow (just one) -----Original Message- From: Dave Laansma To: U2 Users List Sent: Mon, Apr 30, 2012 6:38 pm Subject: Re: [U2] READU vs READ No indexes and no triggers. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342

Re: [U2] READU vs READ

2012-04-30 Thread Dave Laansma
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 taki

Re: [U2] READU vs READ

2012-04-30 Thread Dave Laansma
creased 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 an

Re: [U2] READU vs READ

2012-04-30 Thread Dave Laansma
creased 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

Re: [U2] READU vs READ

2012-04-30 Thread Dave Laansma
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.o

Re: [U2] READU vs READ

2012-04-30 Thread Dave Laansma
/O is 100 times more expensive than reading and writing -Original Message- From: Dave Laansma To: U2-Users 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 j

[U2] READU vs READ

2012-04-30 Thread 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 conten

Re: [U2] EXIT ; EXIT inside a loop

2012-04-20 Thread Dave Laansma
Behalf Of Rex Gozar Sent: Friday, April 20, 2012 8:46 AM To: U2 Users List Subject: Re: [U2] EXIT ; EXIT inside a loop read the documentation -- you can step thru occurences On Fri, Apr 20, 2012 at 8:44 AM, Dave Laansma wrote: > I won't know it's the right string until I perform a f

Re: [U2] EXIT ; EXIT inside a loop

2012-04-20 Thread Dave Laansma
20, 2012 8:40 AM To: U2 Users List Subject: Re: [U2] EXIT ; EXIT inside a loop See FIND and/or FINDSTR in the BASIC reference guide. On Fri, Apr 20, 2012 at 8:30 AM, Dave Laansma wrote: > This example was brought up because I'm essentially 'searching' > through a 3-dim

Re: [U2] EXIT ; EXIT inside a loop

2012-04-20 Thread Dave Laansma
2 statement. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Thursday, April 19, 2012 1:36 PM To: u2-users@listserver.u2ug.org Subject: [U2] EXIT ; EXIT inside a loop Given: FOR A1 = 1 TO X

Re: [U2] EXIT ; EXIT inside a loop

2012-04-19 Thread Dave Laansma
Using this logic, I believe would still be executed. Sincerely, David Laansma -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Thursday, April 19, 2012 4:50 PM To: 'U2 Users List' Subject: Re: [U2]

[U2] EXIT ; EXIT inside a loop

2012-04-19 Thread Dave Laansma
Given: FOR A1 = 1 TO X FOR A2 = 1 TO Y IF G = H THEN EXIT ; EXIT NEXT A2 NEXT A1 The question is, if G = H, will the two EXIT commands drop out of both loops, skipping BOTH and , and resume execution at ? PLOUGH Sincerely, David Laansma IT Manager

Re: [U2] Case Statement with only two cases

2012-04-19 Thread Dave Laansma
Logically they are clearly the same. It just depends on what the programmer had in mind for the future of 'A'. 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 Solu

Re: [U2] Hello

2012-03-05 Thread Dave Laansma
Okay, I've got a pretty simple question ... How do I get a list of all files that are currently OPEN so I know whether I need to open a given file again? Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com "Deliv

Re: [U2] [OT] CareerBuider.com exploiting animals in their advertising

2012-02-06 Thread Dave Laansma
As much as this subject makes me go bananas, I'm hoping this thread is summarily ended, lest we all go ape over a subject that contributes nothing to the betterment of the U2 database and the primates that utilize it. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Offi

Re: [U2] A Thursday Quandry...

2012-01-26 Thread Dave Laansma
With all due respect ... ew! Put the DEBUG command in the INCLUDED code or make it a subroutine for the purpose of debugging it, THEN put it back when you fixed the problem. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubb

Re: [U2] brillant or not

2012-01-17 Thread Dave Laansma
"One difference between a smart programmer and a professional programmer is that the professional understands that clarity is king. Professionals use their powers for good and write code that others can understand." Robert C. Martin - "Clean Code - A Handbook of Agile Software Craftsmanship" Sinc

Re: [U2] Line Printer Control

2011-12-22 Thread Dave Laansma
[Other] + CONTENT TYPE [simple] + - Header/Trailer Page Options - Force BANNER? no + On Thu, Dec 22, 2011 at 3:14 PM, Dave Laansma wrote: > If you're on AIX, there are some

Re: [U2] Line Printer Control

2011-12-22 Thread Dave Laansma
If you're on AIX, there are some settings in smit that may be causing it too. 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

Re: [U2] End of Month date routine

2011-12-05 Thread Dave Laansma
No, this will fail on January 31st, every year. 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...@list

Re: [U2] End of Month date routine

2011-12-05 Thread Dave Laansma
Ditto. 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...@

Re: [U2] End of Month date routine

2011-12-05 Thread Dave Laansma
* BASICALLY, GET TO THE FIRST OF NEXT MONTH * THEN BACK UP ONE DAY TODAY = ICONV("12/15/11","D2/") ; * SAMPLE DATE THIS.MONTH = OCONV(TODAY,"DM") ; * GET 'THIS' MONTH NUMBER LAST.DAY = TODAY ; * ASSUME TODAY IS THE LAST DAY LOOP IF OCONV(LAST.DAY,"DM")

Re: [U2] UniBasic Question

2011-10-26 Thread Dave Laansma
- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Tuesday, October 25, 2011 4:59 PM To: U2 Users List Subject: Re: [U2] UniBasic Question Unless you know the keys to the records you're selecting, even the EXECUTE "SEL

Re: [U2] UniBasic Question

2011-10-25 Thread Dave Laansma
Unless you know the keys to the records you're selecting, even the EXECUTE "SELECT ..." is going to have to read each record, how else would it know which records to throw out? My point is, if one of your selection criteria were in the key, then my method bypasses the need to read the record if th

Re: [U2] UniBasic Question

2011-10-25 Thread Dave Laansma
I'd strongly suggest using the Unibasic SELECT TO instead of EXECUTE "SELECT " Then you just specify your selection criteria inside your loop. A few advantages that I've personally experienced, but there are probably more: The READNEXT begins immediately (does not wait for the whole file to b

Re: [U2] Comparing numeric strings

2011-08-12 Thread Dave Laansma
Call me a hack ... go ahead "A":FOO < "A":BAR "Numeric string" is an oxymoron in any language, I believe. 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 Solutio

Re: [U2] Is this worth rewriting?

2011-03-04 Thread Dave Laansma
Kevin, if you only knew ... 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 [mai

Re: [U2] Is this worth rewriting?

2011-03-02 Thread Dave Laansma
So far I'm liking this option the best. Doing some simple math: 500,000 records * 12 passes through this loop for each record = 6,000,000 passes. (This def needs to be rethought, but may not be able to be avoided) Then multiply that by the numerous times the OS needs spin through who knows how m

Re: [U2] Is this worth rewriting?

2011-03-02 Thread Dave Laansma
t;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 Steve Romanow Sent: Wednesday, March 02, 2011 11:50 AM To: U2 Users List Subject: Re: [U2] Is this wort

[U2] Is this worth rewriting?

2011-03-02 Thread Dave Laansma
This is some old code that I didn't write, so please don't use it for anything profitable ... The proposal to the group is: Due to the repeated references deep into the PARMS tables, if this were rewritten to reference these locations as few times as possible, IN YOUR OPINION, would there be a

Re: [U2] Frustrated with Rocket / Unidata 7.2

2011-02-18 Thread Dave Laansma
I must agree with Dave on this one. Through my 14-years of experience, the Unidata team has provided exceptional product development, support and seamless upgrades, version after version. Now I am by no means a 'power-user' of the database, but asking from a developers perspective, which of us hav

Re: [U2] [UV] UniVerse Uptime

2011-02-17 Thread Dave Laansma
users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Thursday, February 17, 2011 9:33 AM To: U2 Users List Subject: Re: [U2] [UV] UniVerse Uptime 'who -b' will tell you the date and time AIX restarted last. For us, if AIX

Re: [U2] [UV] UniVerse Uptime

2011-02-17 Thread Dave Laansma
'who -b' will tell you the date and time AIX restarted last. For us, if AIX is up, Unidata is up ... 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" -

Re: [U2] Does UV have a "BLOCK" command

2011-02-07 Thread Dave Laansma
I have to agree with Steve on this one, to my knowledge you're going to have to use either indented IF/THEN/END or GOTO. That is unless there is a different syntactical statement set available. The thing is they all likely decompile to the same instructions, so we're debating cosmetics here. Per

Re: [U2] How many will be selected?

2010-10-19 Thread Dave Laansma
The problem with this question is, if I understand correctly, the SELECT F.FILENAME statement does not truly select the entire file all at once. It essentially selects one group at a time and passes those keys to the READNEXT statement as they become available. Which is why the SELECT F.FILENAME

Re: [U2] Very much OT - AUTO: Haydon Bishop is out of the office (again)

2010-07-01 Thread Dave Laansma
"Where's Haden?" along the Waldo theme. 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.u2

Re: [U2] receiving error message XX record corrupt on logto

2010-05-22 Thread Dave Laansma
What are you people doing 'working' on a Saturday?! Sincerely, David Laansma IT Manager Hubbard Supply Co. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Susan Joslyn Sent: Saturday, May 22, 2010 6:37 PM To: u2-user

Re: [U2] AccuTerm File Transfer

2010-04-30 Thread Dave Laansma
The beauty of the Accuterm (and other direct 'push' features) is that there is virtually no setup required on the PC in order to transfer the data. If Accuterm is operational and you have a network connection, it simply works. And if you get really creative, after the file is transported to the P

Re: [U2] AccuTerm File Transfer

2010-04-29 Thread Dave Laansma
Yes, it is as you say. I use it primarily to move reports back and forth, not critical like an EDI transfer. Also, I have been using it for a number of months and have not had a single failure, that has been brought to my attention at any rate. I've been considering writing an ftp script/subrout

Re: [U2] AccuTerm File Transfer

2010-04-29 Thread Dave Laansma
Kevin, I've found using the ASCII version of the Accuterm transfer to be 'acceptable' regarding speed. A couple of things: Depending on the version of the FT programs, you may be limited to 10-meg files. A couple of tweaks here and there and that can easily be changed to 100-meg or more. Unfor

Re: [U2] Universe and stripped drives

2010-04-28 Thread Dave Laansma
ATA for the system drives - diffenent controllers). > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Dave Laansma > Sent: Wednesday, April 28, 2010 1:16 PM > To: U2 Users List > Subject: Re

Re: [U2] Universe and stripped drives

2010-04-28 Thread Dave Laansma
My opinion is to stripe all your data over as many drives as possible. Regarding mirroring, I would suggest a third mirror. The third mirror can be broken anytime during the day and used for backup, then 're-sync'd.' This configuration provides for minimum data loss due to (the number one cause

Re: [U2] windows/dos my documents environment variable

2010-03-05 Thread Dave Laansma
Thank you all for your help, however this subroutine from 2005 actually works perfectly: SUBROUTINE ATGETDOCPATH(PATH) * Get path to My Documents folder using AccuTerm Script SCR='InitSession.Output MyDocPath() & Chr$(13)' SCR=SCR:CHAR(25):'End Sub' SCR=SCR:CHAR(25):'Private Declare Function S

[U2] windows/dos my documents environment variable

2010-03-04 Thread Dave Laansma
I know this is not a U2 question, but I am trying to push a file from Unidata to the PC User's 'my documents' directory, using the Accuterm escape sequences for transferring a file. For those of you who are Dos savvy, what is the Dos environment variable that returns the full path of the users

Re: [U2] AccuTerm File Transfer

2010-02-15 Thread Dave Laansma
I would agree with the FT subroutines. Although compared to ftp, they are EXTREMELY slow and ineffective for my use on large files, even the non-verifying version. As to why U2 does not 'support' it directly, it is a function that is specific to Accuterm's terminal emulator. It would be impractic

Re: [U2] sending text messages to a regular cell phone

2009-11-05 Thread Dave Laansma
Typically sending a text to your cell phone is just as easy as sending it to any email, it just depends on the provider. For example, to send a text to my Verizon cell phone, the email address is 8105551...@vtext.com You just need to know what your cell provider's standard is. David Laansma IT M

Re: [U2] Re trieving Unix Date and Time stamp on records in a DIRtype file

2009-10-27 Thread Dave Laansma
Perfect. Thank you! 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.

[U2] Retrieving Unix Date and Time stamp on records in a DIR type file

2009-10-27 Thread Dave Laansma
Given any DIR type file, as defined in the VOC file. When I read a 'record' from that type of file, which is of course actually a file in a directory in Unix, how may I establish what the Unix date and time stamps are on that record/file within Unidata? I am interested specifically in Uniba

Re: [U2] U2-Users Digest, Vol 6, Issue 12

2009-10-14 Thread Dave Laansma
Agreed on the simple, top-down code with adequate documentation built in. FROM this kind of code, specs can be reverse-engineered. Then those specs can be presented to those utilizing the product to make sure THOSE specs fit the task at hand. And some advise I took from 'The Mob': "I don't t

Re: [U2] EXECUTE 'CLEARSELECT'

2009-10-12 Thread Dave Laansma
If you goal is to simply count the number of records that match a criteria, consider the COUNT statement. 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" -Ori

Re: [U2] ESC in Unidata

2009-07-31 Thread Dave Laansma
e. A subset of the commands available can be found here: http://h2.www2.hp.com/bizsupport/TechSupport/Document.jsp?objectID=b pl02705 HTH Drew -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent:

Re: [U2] ESC in Unidata

2009-07-31 Thread Dave Laansma
BTW, here the ESC variable can be replaced with CHAR(27) This would accomplish the same thing. 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 Me

Re: [U2] ESC in Unidata

2009-07-31 Thread Dave Laansma
It is probably the key, ascii 27. This syntax usually is telling a terminal (emulator) or printer to do something special. Each device has its own 'escape sequence' language, as such, that tells it to do different things. The sequence of characters that follow the character are very specific i

Re: [U2] Slow selects

2009-07-30 Thread Dave Laansma
And that will only last for a while before that information is flushed from memory. 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- F

Re: [U2] [UD] Logoff on Telnet Disconnect

2009-07-24 Thread Dave Laansma
mputer was suspended on and it thought the session was alive. I also did this to a non-existent tty (/dev/pts/7a) it also thought it was alive. if ! > /dev/pts/7a; then echo "dead"; else echo "alive"; fi alive Does the " >/dev/pts/??" set the $? return value?

Re: [U2] [UD] Logoff on Telnet Disconnect

2009-07-24 Thread Dave Laansma
Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Friday, July 24, 2009 1:38 PM To: U2 Users List Subject: Re: [U2] [UD] Logoff on Telnet Disconnect I have a script that I run periodically does this. H

Re: [U2] [UD] Logoff on Telnet Disconnect

2009-07-24 Thread Dave Laansma
I have a script that I run periodically does this. Here are the critical elements of said script: if ! > /dev/${devn} 2>/dev/null 1>/dev/null then /usr/udthome/bin/stopudt ${proid} fi ${devn} is derived earlier in the script from the 'listuser' command. Basically, if there is a pts in t

Re: [U2] UniVerse Unit Testing

2009-06-11 Thread Dave Laansma
Very interesting ... Hmmm 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" From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listser

Re: [U2] UniVerse Unit

2009-06-11 Thread Dave Laansma
Susan, What elements of data do you keep in this file? I have the same thing in mine and I keep the last 1,000 executions. Not sure why. Just seemed like a reasonable number. David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office:810-234-8681 Fax: 810-234-6142 www.hubbardsupp

RE: [U2] Opening UniBasic Source Code

2009-05-21 Thread Dave Laansma
FYI, Unix scripts are really handy for making 'mass' changes. 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: owner-u2-us...@lis

RE: [U2] [UV] How to 'transfer' a READU lock to another process/port

2009-05-04 Thread Dave Laansma
I have a situation where a file needs to be built from a series of 4 different programs before it can be processed by a fifth. These 5 programs cannot be 'daisy-chained' or called, one to the next. What I did is maintain a 'CONTROL' record in the dictionary file that says which of the 5 programs

RE: [U2] unibasic's sort function

2009-02-03 Thread Dave Laansma
From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: 03 February 2009 16:56 To: u2-users@listserver.u2ug.org Subject: RE: [U2] unibasic's sort function I am not sure about the SORT, but I would suggest simply: LIST = "&

  1   2   >