+--+
|
| STOP statement
|
Hello,
We recently upgraded to a new Windows 2012 R2 server with the latest version of
UniVerse (11.2.x). Everything
seems to be working great except we noticed that 1 index on 1 record is taking
a TON of time to do a rebuild.
The basic syntax we're using is
EXECUTE 'CREATE.INDEX
...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Monday, April 21, 2014 11:39 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] INDEX taking forever to rebuild after server upgrade.
Hello,
We recently upgraded to a new Windows 2012 R2 server with the latest version
of UniVerse (11.2.x
] INDEX taking forever to rebuild after server upgrade.
Chris, did you open a support case with Rocket on this?
On Apr 21, 2014, at 9:39 AM, Chris Austin cjausti...@hotmail.com wrote:
Hello,
We recently upgraded to a new Windows 2012 R2 server with the latest
version of UniVerse (11.2.x
I guessing could do all that.. OR have excel refresh the tables when u
connect...
Maintaining separate tables just for ODBC is silly
From: troy.b...@nordsonasymtek.com
To: u2-users@listserver.u2ug.org
Date: Sat, 15 Feb 2014 13:21:37 -0500
Subject: Re: [U2] ODBC - Not finding the MV fields.
We have a ton of I descriptors and it's quick when u set the option to refresh
in excel.. How many I descriptors do u gave?
From: troy.b...@nordsonasymtek.com
To: u2-users@listserver.u2ug.org
Date: Sat, 15 Feb 2014 13:21:37 -0500
Subject: Re: [U2] ODBC - Not finding the MV fields.
I tend
I found the answer in case anyone stumbles upon this. In Excel, under UniVerse
ODBC Data Source Setup
there's a radio button that's defaulted to Fast Connect (Old OTL). This was
the problem..
When you bring MultiValue fields into ODBC it treats them like tables and you
need to have refresh
...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Thursday, February 13, 2014 4:04 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] ODBC - Not finding the MV fields.
We're running UniVerse 11.x and we've had ODBC setup for a while but
recently started
We're running UniVerse 11.x and we've had ODBC setup for a while but recently
started to use it more. The single-value fields work just fine, but on some of
the Multi-Value fields (only certain tables) we can get the ODCB to work in
excel by manually entering the SQL command but they don't show
Hello,
I noticed an error when doing a UVRESTORE. We have a UniVerse region with
client information and data. When doing a UVRESTORE I get the following
Restoring c:\CHRIS/I_CLIENT (21:35:56)
Restoring c:\CHRIS/I_CLIENT/INDEX.000 (21:35:56)
Restoring c:\CHRIS/I_CLIENT/INDEX.001 (21:35:58)
not valid UTF-8
characters.
-John
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Tuesday, November 26, 2013 8:16 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] UvRestore error
Hello
-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Tuesday, November 26, 2013 1:39 PM
To: U2 Users List
Subject: Re: [U2] UvRestore error
John, Thanks for the reply.
I'll write a utility to parse the ID's on that table and see
that just does a DCOUNT on @ID. Then you
can simply select the I-descriptor for the bad keys.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Tuesday, November 26, 2013 1:50 PM
To: U2 Users
the I-descriptor for the bad keys.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Tuesday, November 26, 2013 1:50 PM
To: U2 Users List
Subject: Re: [U2] UvRestore error
for indexing.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Wednesday, 27 November 2013 9:32 AM
To: U2 Users List
Subject: Re: [U2] UvRestore error
I wrote a program to check for @VM
Harold,
I don't see the big deal with downloading the
HP-UX Internet Express for HP-UX 11i
v2https://h20392.www2.hp.com/portal/swdepot/displayProductInfo.do?productNumber=HPUXIEXP1123jumpid=reg_R1002_USEN
that contains curl, along with several other useful tools would be? I can't see
too
COMO = Common Output
COMI = Common Input
From: johnisr...@daytonsuperior.com
To: u2-users@listserver.u2ug.org
Date: Mon, 22 Jul 2013 19:47:55 +
Subject: Re: [U2] Origin of the word 'COMO'
Not sure, but back in the Pr1me days, I think we had both COMOs and COMIs.
That was a LNG
For pagination we setup an I-Descriptor for a CLIENT table as follows:
ROW_NUMBER I @1+1 ; INT(@1)MD0 Row Number 5R
S
The trick is the @1+1 ; INT(@1) bit.
Chris
From: dgr...@dagconsulting.com
To:
We have a user on our system who's not an admin, just a regular user on the
server. When he tries to execute a UVRESTORE he gets the
following error:
Warning: Access list denial: Function UVBACKUP, File
c:\universe_region/file_name
WARNING: Unable to open file 'c:\universe_region/file_name'.
Ok I can see where to edit it now in UV.ACCESS - UVBACKUP:
uvadmýrootýNT AUTHORITY\system
READýWRITE
If I wanted to add read\write properties for a user called USER1, would I just
add the user to line #1 and keep line #2 the same?
Chris
From: cjausti...@hotmail.com
To:
-
om: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org]
n Behalf Of Chris Austin
nt: Thursday, July 05, 2012 11:21 AM
: u2-users@listserver.u2ug.org
bject: Re: [U2] RESIZE - dynamic files
ick,
ou are correct, I should be using the smaller size (I just
Disk space is not a factor, as we are a smaller shop and disk space comes
cheap. However, one thing I did notice is when I increased the modulus to a
very large
number which then increased my disk space to about 3-4x of my record data, my
SELECT queries were slower.
Are the 2 factors when
I was able to drop from 30% overflow to 12% by making 2 changes:
1) changed the split from 80% to 70% (that alone reduce 10% overflow)
2) changed the MINIMUM.MODULUS to 118,681 (calculated this way - [ (record
data + id) * 1.1 * 1.42857 (70% split load)] / 4096 )
My disk size only went up 8%..
...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: 05 July 2012 15:19
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] RESIZE - dynamic files
I was able to drop from 30% overflow to 12% by making 2 changes:
1) changed the split from 80% to 70
[mailto:u2-users-boun...@listserver.u2ug.org]
n Behalf Of Chris Austin
nt: Thursday, July 05, 2012 11:21 AM
: u2-users@listserver.u2ug.org
bject: Re: [U2] RESIZE - dynamic files
ick,
ou are correct, I should be using the smaller size (I just haven't changed it
t). Based on the reading I
File name .. GENACCTRN_POSTED
Pathname ... GENACCTRN_POSTED
File type .. DYNAMIC
File style and revision 32BIT Revision 12
Hashing Algorithm .. GENERAL
No. of groups (modulus) 92776 current ( minimum 31, 89 empty,
No worries Doug. I'm just wondering if the calculation makes sense (if we use
the example below):
File name .. GENACCTRN_POSTED
Pathname ... GENACCTRN_POSTED
File type .. DYNAMIC
File style and revision 32BIT Revision 12
Hashing
, 4096, group size. You will end up with twice the number of records
per group vs 2048 (~ 13 vs ~ 7 ), and a little slower keyed access.
-Rick
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent
Doug,
The data is growing over time with this file. Does that mean I should ignore
the formula? Or should I still use a lower MINIMUM.MODULO than the
actual modulo #..
Is the idea to reduce overflow by lowering the split? What is this 'overflow'
referring to?
2) SPLIT - would 90% seem
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Tuesday, July 03, 2012 9:48 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] RESIZE - dynamic files
File name .. GENACCTRN_POSTED
Pathname ... GENACCTRN_POSTED
File type
overflow (unless you have sequential keys like
sized records).
-Rick
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Tuesday, July 03, 2012 12:54 PM
To: u2-users@listserver.u2ug.org
-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Tuesday, July 03, 2012 12:54 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] RESIZE - dynamic files
Using the formula below, and changing
But the total size of your file is up 60%. Reading in 60% more records in a
full select of the file is going to be much slower than a few more overflows.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris
have a perfectly
hashed file with uniformly sized records.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Tuesday, July 03, 2012 2:38 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2
I was wondering if anyone had instructions on RESIZE with a dynamic file? For
example I have a file called 'TEST_FILE'
with the following:
01 ANALYZE.FILE TEST_FILE
File name .. TEST_FILE
Pathname ... TEST_FILE
File type .. DYNAMIC
File
I was wondering if anyone had instructions on RESIZE with a dynamic file? For
example I have a file called 'TEST_FILE'
with the following:
01 ANALYZE.FILE TEST_FILE
File name .. TEST_FILE
Pathname ... TEST_FILE
File type .. DYNAMIC
File
The dynamic file I'm working with is below. What do 'overflowed' and 'badly'
refer to under MODULUS? Is the goal of the RESIZE to eliminate that
overflow? Any ideas what I should change to achieve this?
File name .. TEST_FILE
Pathname ... TEST_FILE
File type
Of Chris Austin
Sent: 02 July 2012 20:22
To: u2-users@listserver.u2ug.org
Subject: [U2] RESIZE - dynamic files
I was wondering if anyone had instructions on RESIZE with a dynamic file? For
example I have a file called 'TEST_FILE'
with the following:
01 ANALYZE.FILE TEST_FILE
File name
I usually get my exploded list and then DEDUPE using the following:
LOCATE VALUE.TO.FIND IN UNIQUE.LIST BY AL SETTING POS ELSE
UNIQUE.LIST = INSERT(UNIQUE.LIST,1,POS,0,VALUE.TO.FIND)
END
This puts everything in a nice ARRAY called UNIQUE.LIST, I then can use a FOR
loop to loop through as
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Thursday, May 17, 2012 1:20 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
I usually get my exploded list and then DEDUPE using the following:
LOCATE VALUE.TO.FIND
-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Thursday, May 17, 2012 1:20 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
I usually get my exploded list and then DEDUPE using the following
...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Thursday, May 17, 2012 5:00 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
That works beautifully George, thanks for the tip! I've never used the
MERGE.LIST command before, I assume the line you have
syntactic
way to use MERGE.LIST to dedupe.
-Rick
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Thursday, May 17, 2012 1:20 PM
To: u2-users@listserver.u2ug.org
Subject: Re
the deduping when it's
finished the merge as it does the sorting.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Thursday, May 17, 2012 5:11 PM
To: u2-users@listserver.u2ug.org
Harold,
I just did this upgrade about a week ago.. it was super easy. I actually went
from 10.1.18 to 11.1.1 and the transition was smooth but
there were a couple things to note:
1) Install Universe 11.x under the 'modify' setting.
2) The file paths are diff (c:\ibm\uv vs. c:\u2\uv), so agree
Here is the writeup from one user (who upgraded to 11.1):
http://nebula-rnd.com/blog/tech/mv/2011/04/u2upgrade2.html
Chris
From: cjausti...@hotmail.com
To: u2-users@listserver.u2ug.org
Date: Tue, 6 Mar 2012 14:03:56 -0600
Subject: Re: [U2] Universe 10.2 to 11.1
Harold,
I just did
I just upgraded my UniVerse server from version 10.1.18 to 11.1.1. Everything
seems ok except when I try and run the uvrestore command from one of our
UniVerse version 10.3.3 backups.
I don't know if this is a problem with just uvrestore or other uv commands but
when I try to execute a
I just upgraded my UniVerse server from version 10.1.18 to 11.1.1. Everything
seems ok except when I try and run the uvrestore command from one of our
UniVerse version 10.3.3 backups.
I don't know if this is a problem with just uvrestore or other uv commands but
when I try to execute a
The problem happens when I try and execute the UV command (see below):
CHRISDOS
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:\CHRISUV
A fatal error has occurred in uniVerse
Unable to create or attach the Printer Segment
So this isn't just with uvrestore but
you executed uvregen after the upgrade?
Regards
--
Augusto
2012/2/28 Chris Austin cjausti...@hotmail.com
I just upgraded my UniVerse server from version 10.1.18 to 11.1.1.
Everything seems ok except when I try and run the uvrestore command from
one of our UniVerse version 10.3.3
] On Behalf Of Chris Austin
Sent: 28 February 2012 16:56
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] uvrestore - Unable to create or attach the Printer Segment
We did an upgrade by using the 'modify' option during the install. We also
used the option during the install
to copy all
path environment
variable changed to the new \u2\uv\bin ?
Could it be trying to run the old binaries?
Brian
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: 28 February 2012 16:56
To: u2
13:12:53 -0500
Subject: Re: [U2] uvrestore - Unable to create or attach the Printer Segment
Do you mean you log into Universe, go to TCL, type DOS, get the DOS prompt,
then try uv at that point?
-Original Message-
From: Chris Austin cjausti...@hotmail.com
To: u2-users u2-users
Subject: Re: [U2] uvrestore - Unable to create or attach the Printer Segment
Connect to your server directly through RADMIN or PCAnywhere.
Start a DOS Shell without going into Universe.
Go to the Universe directory
Try uv then.
-Original Message-
From: Chris Austin cjausti
--
Augusto
2012/2/28 Chris Austin cjausti...@hotmail.com
We did an upgrade by using the 'modify' option during the install. We also
used the option during the install
to copy all the files from the old \IBM\UV directory to the new U2\UV
directory. I'm not sure if that has anything
to do
--
Augusto
2012/2/28 Chris Austin cjausti...@hotmail.com
We did an upgrade by using the 'modify' option during the install. We also
used the option during the install
to copy all the files from the old \IBM\UV directory to the new U2\UV
directory. I'm not sure if that has
or PCAnywhere.
Start a DOS Shell without going into Universe.
Go to the Universe directory
Try uv then.
-Original Message-
From: Chris Austin cjausti...@hotmail.com
To: u2-users u2-users@listserver.u2ug.org
Sent: Tue, Feb 28, 2012 10:15 am
Subject: Re: [U2] uvrestore
I'm just about to do an upgrade. The current server is Windows 2003 Server
running UniVerse 10.1.18 (build 8330).
I'm looking to upgrade to version 11.1.1, is there anything I should be aware
of? What's the best way to do this upgrade..
should I simply uninstall UniVerse 10.1.18 and then
:
The upgrade is simple and use the modify option. I've done a number of
sites with no problems.
Regards,
Doug
www.u2logic.com
On Mon, Feb 27, 2012 at 12:41 PM, Chris Austin cjausti...@hotmail.comwrote:
I'm just about to do an upgrade. The current server is Windows 2003 Server
running
whatever... :) )
From: Chris Austin
I'm just about to do an upgrade. The current server is Windows 2003
Server running UniVerse 10.1.18 (build 8330).
I'm looking to upgrade to version 11.1.1, is there anything I should
be
aware of? What's the best way to do this upgrade..
should I simply
I found this article, and thought it may be of use to you:
https://u2devzone.rocketsoftware.com/accelerate/articles/u2-xml/u2-xml
Chris
Date: Wed, 9 Nov 2011 12:44:44 -0600
From: bwor...@coburns.com
To: u2-users@listserver.u2ug.org
Subject: [U2] Extracting XML attributes
Does anyone
in the same boat. I have not had time to
try it.
On 9/13/11, Chris Austin cjausti...@hotmail.com wrote:
Thanks Glenn, I will give this a try in the morning!
Chris
Date: Tue, 13 Sep 2011 23:48:26 +0200
From: u...@glennsallis.de
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] 64
Oh cool. If I ever get through the heap I'll have to give this a try.
On Wed, Sep 14, 2011 at 3:37 PM, Chris Austin cjausti...@hotmail.comwrote:
I just got the ODBC to work on my 64-bit machine. I used Glenn's advice and
downloaded the 11.x UniVerse client and then installed the ODBC
I'm running a 64-bit version of Windows 7 and trying to install the ODBC driver
that came with the UniVerse 10.1 client disk but
I keep getting a message when I run the INSTALL application. The error states:
'The version of this file is not compatible with the version of windows you're
13.09.2011 23:17, schrieb Chris Austin:
I'm running a 64-bit version of Windows 7 and trying to install the ODBC
driver that came with the UniVerse 10.1 client disk but
I keep getting a message when I run the INSTALL application. The error
states:
'The version of this file
-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Thursday, August 18, 2011 1:30 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] easy way to get count of a DIM()?
I'm trying to get the count of a dimensioned array
up to the last physical data in the array, and ignore the trailing
blank slots.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Thursday, August 18, 2011 1:44 PM
To: u2
blank slots.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Thursday, August 18, 2011 1:44 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] easy way
If you're talking in regards to RPC timeouts they can be changed at the
following path
$root\IBM\unishared\unirpc\unirpcservices
I have no idea if this will help with your issue at hand, does the exception
throw any code#?
Chris
Date: Tue, 9 Aug 2011 15:10:25 -0400
From:
, Aug 9, 2011 at 3:53 PM, Chris Austin cjausti...@hotmail.com wrote:
If you're talking in regards to RPC timeouts they can be changed at the
following path
$root\IBM\unishared\unirpc\unirpcservices
I have no idea if this will help with your issue at hand, does the
exception throw
We've been using the following command to select a name regardless of how it's
capitalized:
SELECT CLIENT WITH NAME CONV MCU = BRUCE]
However, after I indexed the field NAME on the CLIENT table the same command
only returns
the values that match the case-sensitive. In other words after we
2011 09:32:48 -0700
Subject: Re: [U2] CONV MCU on indexed field?
Could you create another dict item called NAME.UPCASE and put the MCU in
that definition?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris
to or couldn't do that then another definition could
be created that forced the name to be upper-case.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Tuesday, July 26, 2011 9:36 AM
To: u2-users
...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Tuesday, July 26, 2011 10:37 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] CONV MCU on indexed field?
I changed the DICT entry for field NAME on the CLIENT table to the
following:
NAME
0001 D
0002 5
0003 MCU
0004 Name
0005
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Tuesday, July 26, 2011 10:37 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] CONV MCU on indexed field?
I changed the DICT entry for field NAME on the CLIENT table to the
following:
NAME
0001 D
0002 5
a
computation? A virtual attribute on unidata or a correlative on universe with
does the upcasing? In that case then your literal in the query would be
compared against the calculated value. An index would also be built on the
calculated value
On Jul 26, 2011, at 1:37 PM, Chris Austin
Stewart
Chris Austin cjausti...@hotmail.com wrote:
Could you create another dict item called NAME.UPCASE and put the MCU in
that definition?
I guess I'm not sure what the above dictionary entry would look like. Would
this be a dictionary entry
that's just used to do the conversion
on
the calculated value
On Jul 26, 2011, at 1:37 PM, Chris Austin wrote:
I changed the DICT entry for field NAME on the CLIENT table to the
following:
NAME
0001 D
0002 5
0003 MCU
0004 Name
0005 25L
0006 S
0007
0008 CHARACTER,25
But it still doesn't seem to work
... Although I have no
idea how to do that. I'm sure someone on the list does though.
On 7/26/11, Chris Austin cjausti...@hotmail.com wrote:
Ed,
You're right on the money here ( I believe). The difference seems to be with
the wildcards:
Before indexing the field NAME I could use
in error,
please immediately reply to the sender and delete this information from your
system. Use, dissemination, distribution, or reproduction of this
transmission by unintended recipients is not authorized and may be unlawful.
Chris Austin cjausti...@hotmail.com 7/26/2011 1:57 PM
I'm
George,
I just rebuilt the indices on the CLINE table, then tried the LIKE using the
'...' as a wildcard, so I tried:
SELECT CLIENT WITH NAME LIKE BRUCE...
and unfortunately that worked the exact same way as the [] wildcards, returning
1 result.
The approach I'm going to use is the one you
I'm working on a screen in our webapp where we're using a dojo widjet to create
a drop down with client names. The problem
is that we have 1,000's of clients and when we do a SELECT on this many clients
it takes a while. I know we can index the field but
I was wondering if you can do smart
Doug,
Thanks for the reply. I'm a little confused as to how to execute your
suggestion though.
EXECUTE 'SELECT CLIENT WITH @ID = A] SAMPLE 10' CAPTURING CAPTURED PASSLIST
REC.COUNT = @SELECTED*SYSTEM(11)
IF REC.COUNT THEN
EXECUTE 'SAVE.LIST CLIENT.LIST '
END
RETURN
In the above example we
Bill,
I was curious if you had a quick example? I'm just curious how you guys are
suggesting to do this
Chris
Date: Wed, 20 Jul 2011 11:13:04 -0700
From: wphask...@advantos.net
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SELECT question, paginated select.
Chris:
I'm betting
Bill,
I guess my question is regarding how to traverse the index. In this case the
field we're using is the @ID, so it's
indexed by default. Below you stated that we have to traverse in BASIC, is this
using the SAVE.LIST approach that Doug
talks about?
In your example:
SELECT VENDCHECKS
a dropdown list, even
using a combo box list allows the user to provide some criteria to narrow the
search.
Hth
Curt Stewart
Chris Austin cjausti...@hotmail.com wrote:
Bill,
I was curious if you had a quick example? I'm just curious how you guys are
suggesting to do this
Chris
...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Wednesday, July 20, 2011 12:19 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SELECT question, paginated select.
Curt,
My problem is understanding how to traverse the query. Our dropdown is
paginated, we can specify the # of results per
using SQL on
UV
to do your selection, which was able to produce a row number, then only
include
certain row numbers on the final query.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Chris
, This should work.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Wednesday, July 20, 2011 1:15 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] SELECT question, paginated select
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Wednesday, July 20, 2011 4:34 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SELECT question, paginated select.
George
on a
later release of UV, if it's a feature, it's a cool one.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Wednesday, July 20, 2011 5:26 PM
To: u2-users@listserver.u2ug.org
GETCLIENTS ALEX 6
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Wednesday, July 20, 2011 5:26 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SELECT question
CLIENT WITH PAGE =
4'
EXECUTE CMD1 [RTNLIST] [CAPTURING]
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Wednesday, July 20, 2011 5:46 PM
To: u2-users@listserver.u2ug.org
Subject: Re
been
SELECT CLIENT WITH PAGE = I3,PAGENO
That should clear up the error.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Wednesday, July 20, 2011 6:02 PM
To: u2-users
.
that should have been
SELECT CLIENT WITH PAGE = I3,PAGENO
That should clear up the error.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Wednesday, July 20, 2011 6:02 PM
We recently switched to a new server and I've been having some weird RPC
failures. Every night we run a nightly
cycle that processes our batches and transactions. During the monthly cycles
(which take a little longer), we have
a process at the very end that will connect to our java data pool
I recently noticed that one of our tables is taking forever to return a simple
SELECT statement. Upon further review I noticed
1 difference between the tables that run fast and the slow table. That
difference is noticed when you type LIST.INDEX table_name.
File... POLACCTRN_POSTED
try this, your loops are using too many conditionals. What kind of data is
this, string, integer, etc?
MONTHLY.USAGE:
--
CM = MONTH + LY.CNT
TEA = PARMS(12)101,CM
EAT = PARMS(12)133,CM
ATE = PARMS(12)134,CM
FOR M = 1 TO 12
IF TEA+EAT+ATE '' THEN CUM(M) = TEA+EAT+ATE
YAM =
I didn't realize the CM var could be used so I re-wrote it.
This program logic looks horrible though, I would definitely
re-write it with consideration of indexing some fields to make it
run more efficient.
Chris
MONTHLY.USAGE:
CM = MONTH+LY.CNT
FOR M = 1 TO 12
TEA = PARMS(12)101,CM
EAT =
, just rounding
Regards
John Woollam | Group Function Support 1 (Finance Systems) | Travis
Perkins PLC | 01604 682751
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: 13 October 2010 22
1 - 100 of 142 matches
Mail list logo