I'd suggest this subroutine. Brief and to the point:
SUBROUTINE HUB.SORT.B (ITAB)
OTAB =
FOR X = 1 TO DCOUNT(ITAB,@AM)
ELEM = ITABX
LOCATE ELEM IN OTAB BY AL SETTING PLACE ELSE NULL
OTAB = INSERT(OTAB,PLACE;ELEM)
NEXT X
ITAB = OTAB
RETURN
END
David Laansma
I've been experimenting and discovered something. Instead of waiting
until you have all (say) 100,000 elements to sort at once, why not sort
them in blocks of (say) 5,000. So I wrote this little subroutine that
takes two parameters, a relatively small un-sorted table and the larger
sorted table
] On Behalf Of Dianne Ackerman
Sent: Thursday, July 24, 2008 11:39 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Basic SORT() Function not avail in UniVerse?
I don't seem to have SORT.LIST on UV 10.1.14. Is it on a later version?
-Dianne
Dave Laansma wrote:
I think I like this one better than
Jeff, you wouldn't happen to have worked for EBS and VERSYSS?
David Laansma
IT Manager
Hubbard Supply Co.
Direct: 810-342-7143
Office:810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
Delivering Products, Services, and Innovative Solutions
-Original Message-
From: [EMAIL PROTECTED]
I have found the tab character to be extremely effective in delineating
columns of information. The simple command:
SWAP CHAR(9) WITH @VM IN report-table
Instantly changes the report to a usable table in UniBasic. Using any
'printing' character (like the pipe '|' or caret '^') is unreliable as
The 'COUNT' command is also very good at establishing if and how many
records match a certain criteria without utilizing a select list.
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
Solutions
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave Laansma
Sent: Friday, November 14, 2008 7:57 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] SELECT-READNEXT That's odd
The 'COUNT' command is also very good at establishing if and how many
Oh my goodness! This is incredible.
Okay, now I have a mixture of @VM and @AM in the table. The REMOVE
'stops' at every @VM and @AM. I only want it to 'stop' at @AMs. How do
I do that?
David Laansma
IT Manager
Hubbard Supply Co.
Direct: 810-342-7143
Office:810-234-8681
Fax: 810-234-6142
' all the other markers with 'strings' (SWAP
@VM
WITH VM IN RECORD) then you have to 'build' the line item up --
keep
removing until you see the remove hit the @AM and then process the
line...
DW
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave
argument. Makes it a lot more
flexible - you can declare it as a function, call it from SUBR in
i-descriptors, whatever whatever.
Cheers,
Wol
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave Laansma
Sent: 19 November 2008 14:05
To: u2-users
'u'.
compilation finished
COUNT STUDENTS
39635 record(s) counted.
NUMBER OF RECORDS: 39635
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave Laansma
Sent: Wednesday, November 19, 2008 10:24 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2
I am not sure about the SORT, but I would suggest simply:
LIST =
KEY =
LIST-1 = KEY
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
...@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 =
KEY =
LIST-1 = KEY
David Laansma
IT Manager
Hubbard Supply Co.
Direct
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
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:
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
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
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 the
-
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.
Here are the critical
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?
Thanks.
Jeff
Dave Laansma wrote:
I have a script that I
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-
It is probably the escape 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
ESC character are very
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
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: Friday, July 31, 2009
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
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
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
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
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
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
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
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
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
- 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: [U2] Universe and stripped drives
My opinion
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.
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
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
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:
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:
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
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.
'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
...@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 is up, Unidata is up
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
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
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 worth rewriting?
On 3/2/2011 11:43 AM, Dave
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
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 Solutions
I'd strongly suggest using the Unibasic SELECT file TO listname
instead of EXECUTE SELECT filename selection criteria
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
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 the
-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 SELECT ... is going to have
* 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) #
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
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:
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-
]
+
CONTENT TYPE [simple]
+
- Header/Trailer Page Options -
Force BANNER? no
+
On Thu, Dec 22, 2011 at 3:14 PM, Dave Laansma
dlaan...@hubbardsupply.comwrote:
If you're on AIX, there are some
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
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
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
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
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
Using this logic, I believe twisting little logic 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
-
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
FOR A2 = 1 TO Y
little twisted logic
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
dlaan...@hubbardsupply.com wrote:
This example was brought up because I'm essentially 'searching'
through a 3-dimensional table and when
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
dlaan...@hubbardsupply.com wrote:
I won't know it's the right string until I perform
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
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
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
, 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
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
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
eyebrow (just one)
-Original Message-
From: Dave Laansma dlaan...@hubbardsupply.com
To: U2 Users List u2-users@listserver.u2ug.org
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
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
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
-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
...@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
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:
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
.
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
, you may have to do some further
tinkering, such as repeat the process using a slightly higher 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
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
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:
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
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
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
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,
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
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
] 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
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:
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
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:
...@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
] 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
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
:-)
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
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]
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
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,
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
1 - 100 of 107 matches
Mail list logo