I was asked a question today that ... well, it stumped me. Is there a
practical limit to an incrementing number on Unidata and if so, what is
that limit? I seem to recall something way back on Reality that said that
numbers could count to 1+e38 or something ridiculous like that, but is that
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Tuesday, July 10, 2012 12:03 PM
To: U2 Users List
Subject: [U2] Unidata Limits
I was asked a question today that ... well, it stumped me. Is there a
practical
Users List
Subject: [U2] Unidata Limits
I was asked a question today that ... well, it stumped me. Is there a
practical limit to an incrementing number on Unidata and if so, what is that
limit? I seem to recall something way back on Reality that said that numbers
could count to 1+e38
I have a vague recollection that I've seen something in the Unidata manuals
- years ago - documenting the maximums for a TCL statement, record size,
number of IDs that can be specified in a SELECT statement, that sort of
thing. I've searched the manual set but I can't seem to locate that
From TCL: LIMIT?
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Thursday, April 02, 2009 10:34 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Unidata limits - Where are they documented?
I have
...@listserver.u2ug.org]
On Behalf Of Kevin King [precisonl...@gmail.com]
Sent: 02 April 2009 09:33
To: u2-users@listserver.u2ug.org
Subject: [U2] Unidata limits - Where are they documented?
I have a vague recollection that I've seen something in the Unidata manuals
- years ago - documenting
Okay, I didn't know about LIMIT. Too cool. Thanks!
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
In message 4983be3c.4070...@advantos.net, Bill Haskett
wphask...@advantos.net writes
Ken:
I think so. I'm looking at this as the best (or easiest) alternative.
Thanks very much for the thought.
Bill
I've rethought my idea a bit. What I don't quite get is how you build up
that massive
-users@listserver.u2ug.org
Subject: Re: [U2] UniData LIMITs
The problem here isn't that you can only have a certain number of items
active in a select list, but that specifying them as explicit item ids on
the command line is ugly, bad and only supported up to a certain point.
Isn't this a job
Hi Bill
I can't see users selecting 300 users, there must be another criteria that
they choose to get those clients, can't that be used instead.
Otherwise:
I would set up another file SELECTEDCLIENTS with key @UserNo*Clientno with
f1 = 1 which holds the clientnos the user wants. The core
] On Behalf Of Bill Haskett
Sent: Thursday, January 29, 2009 12:44 PM
To: U2 Mail List
Subject: [U2] UniData LIMITs
We have a report writer that allows users to select the client they want
to
print any report for. This subroutine builds a list of clients available
to
any particular user
:49
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UniData LIMITs
Bill,
I would create a CLIENT Type field that you can lump the CLIENTS together
and use the Type field for your selections.
Thanks,
David A. Green
www.dagconsulting.com
(480) 813-1725
-Original Message-
From: owner-u2
@listserver.u2ug.org
Subject: Re: [U2] UniData LIMITs
Do the users have to type in all 300 customer numbers every time they want
to run a report?
Certainly not?
So there must be a file containing these numbers with some sort of ID.
In that case there should
I'm entering the fray late here, but I think I have a good, fast,
general solution, provided you're willing to index a field. I should
probably post it in U2UG's wiki the source code to the XSELECT utility
below.
Using your example, SELECT CUSTOMERS WITH CLIENTNO = 1234. :
1. Maintain an
Just goes to show that a problem like this will generate the same solution
many times over.My version of Chuck's XSELECT is called BSELECT.
e.g.
GET-LIST MYLIST (list of customer numbers)
BSELECT INVOICES CUST.NO(cust.no is an indexed field in INVOICES file)
Once you get used to it, it
-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Saturday, 31 January 2009 8:23 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniData LIMITs
Micki:
Thanks for the thoughts. We do have a single subroutine
@listserver.u2ug.org
Subject: Re: [U2] UniData LIMITs
So can't you substitute your bit of code that puts 'WITH CLIENTNO =
':MYBIGCOMMONLISTOFLITERALS into all your SELECTs and SORTs with
something that puts 'WITH EVAL
SUBR(MYROUTINETHATLOCATESINCOMMONLITERALS,CLIENTNO)' in the same place and
get
We have a report writer that allows users to select the client they want to
print any report for. This subroutine builds a list of clients available to
any particular user and uses this list to either compare against the clients
entered or of all clients are selected then the entire
There have always been limits on how big or complex a selection statement
can be. And as best I know, these things are not configurable. So... you
have to be creative on how you select the items.
For example, if you know the keys to the records of the customers to select
- or can build the keys
Subject: [U2] UniData LIMITs
We have a report writer that allows users to select the client they
want to
print any report for. This subroutine builds a list of clients
available to
any particular user and uses this list to either compare against the
clients
entered or of all clients
__
From: Marc Harbeson mharbe...@brinly.com
Sent: 1/29/2009 1:54 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniData LIMITs
Can't you just FORMLIST them, then list?
Aka:
CLIENTIDS = 1:@AM:2
FORMLIST CLIENTIDS TO 0
-Original
And the client records don't share any specific attribute, like a company
number or such that you could use in the selection?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
That's correct.
Bill
__
From: Kevin King precisonl...@gmail.com
Sent: 1/29/2009 2:37 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniData LIMITs
And the client records don't share any specific
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Thursday, January 29, 2009 7:12 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniData LIMITs
That's correct.
Bill
__
From: Kevin King precisonl
: Thursday, January 29, 2009 8:24 PM
Subject: RE: [U2] UniData LIMITs
What about something along the lines of splitting the client ID's into
two (or more) lists, selecting, and then MERGE.LIST them together then
list?
Kind of difficult to guess around it without seeing the whole picture
: Thursday, January 29, 2009 8:24 PM
Subject: RE: [U2] UniData LIMITs
What about something along the lines of splitting the client ID's into
two (or more) lists, selecting, and then MERGE.LIST them together then
list?
Kind of difficult to guess around it without seeing the whole picture.
-Original
@listserver.u2ug.org
Subject: RE: [U2] UniData LIMITs
What about something along the lines of splitting the client ID's into
two (or more) lists, selecting, and then MERGE.LIST them together then
list?
Kind of difficult to guess around it without seeing the whole picture.
-Original Message
applied to
modern hardware. :-(
Thanks again.
Bill
__
From: Ken Wallis ken_wal...@internode.on.net
Sent: 1/29/2009 9:04 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniData LIMITs
The problem here
28 matches
Mail list logo
