+--+
|
| STOP statement
|
for HOURS without
finishing.
Any ideas what would cause this or how to remedy the situation? Maybe the index
is corrupt?
Thanks,
Chris
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http
Ryan,
That's a good point, we do have a lot of strings with NULL so maybe setting
NULLS to NO would help.
Chris
From: ryan.l...@meritain.com
To: u2-users@listserver.u2ug.org
Date: Mon, 21 Apr 2014 12:47:38 -0400
Subject: Re: [U2] INDEX taking forever to rebuild after server upgrade
No, we have not since I wasn't sure if it was something on our end or with the
new version of UniVerse. Has
this come up with anyone else by chance that you know of?
Chris
From: neilri...@gmail.com
Date: Mon, 21 Apr 2014 09:48:07 -0700
To: u2-users@listserver.u2ug.org
Subject: Re: [U2
] ODBC - Not finding the MV fields.
Chris:
1. The legacy dictionaries here tend to have overhead not needed by ODBC.
2. Only after experiencing some difficult ODBC problems here... and trying to
simplify the problem... did I realize that some traditional DICT
characteristics are problematic
- Not finding the MV fields.
Chris:
1. The legacy dictionaries here tend to have overhead not needed by ODBC.
2. Only after experiencing some difficult ODBC problems here... and trying to
simplify the problem... did I realize that some traditional DICT
characteristics are problematic to ODBC
I didn't get a log
after running it.
Any help is appreciated, thanks.
Chris
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Bill,
Not sure why you would do those 6 steps, when running HS.UPDATE.FILEINFO from a
command line or program
will do the same thing (reset the cache w the updated tables).
I like to limit the amount of dictionary entries I have.
Chris
From: bi...@hkmetalcraft.com
To: u2-users
and it wasn't much help since I didn't get a log after
running it.
Any help is appreciated, thanks.
Chris
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
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
John, Thanks for the reply.
I'll write a utility to parse the ID's on that table and see if I find any
@VM's.. I did notice some unconventional ID's being used when I did a LIST by
ID.. probably best to remove those and re-index.
Chris
Date: Tue, 26 Nov 2013 13:35:42 -0800
From: jhes
-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
Thanks Bob,
I like the idea of using an I-descriptor to DCOUNT on the @ID :)
Cheers
Chris
Date: Tue, 26 Nov 2013 13:58:22 -0800
From: bob_woodw...@k2sports.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UvRestore error
One of the ways that I've used in the past to check
wonder if it comes from a field we have
INDEXED (indexed I-descriptor).
Chris
From: cjausti...@hotmail.com
To: u2-users@listserver.u2ug.org
Date: Tue, 26 Nov 2013 16:00:48 -0600
Subject: Re: [U2] UvRestore error
Thanks Bob,
I like the idea of using an I-descriptor to DCOUNT on the @ID
appreciate the help, this was an issue that was lingering for some time, nice
to have an answer and clean it up
so we can rebuild the indices faster.
Chris
From: bernard.lu...@pentanasolutions.com
To: u2-users@listserver.u2ug.org
Date: Wed, 27 Nov 2013 09:50:02 +1100
Subject: Re: [U2
many cons of having this package on your server..
curl is about as 'light' of an application as it gets.
Chris
Date: Thu, 31 Oct 2013 13:46:25 -0700
From: harold.o...@clark.wa.gov
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Ref: Web Services at Universe 11.n
Hi Rudy:
We're
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: u2-users
WRITEWRITEWRITE
Bottom at line 2.
---
My question is how do I edit the UV.BACKUP item in the UV.ACCESS file to
achieve this?
Thanks,
Chris
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http
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: u2-users
you gain anything by reducing overflow?
Chris
To: u2-users@listserver.u2ug.org
From: wjhon...@aol.com
Date: Thu, 5 Jul 2012 20:12:21 -0400
Subject: Re: [U2] RESIZE - dynamic files
A BASIC SELECT cannot use criteria at all.
It is going to walk through every record in the file, in order
, I think
this is all starting to make sense.
Chris
From: ro...@stamina.com.au
To: u2-users@listserver.u2ug.org
Date: Wed, 4 Jul 2012 01:36:26 +
Subject: Re: [U2] RESIZE - dynamic files
I would suggest that then actual goal is to achieve maximum performance for
your system, so knowing
% (split), 50% (merge) and 63% (actual)
Total size . 546869248 bytes
Total size of record data .. 287789178 bytes
Total size of record IDs ... 21539538 bytes
Unused space ... 237532340 bytes
Total space for records 546861056 bytes
Chris
From: keith.john
the performance I need to write a ton of records and then capture the
output and compare the output using timestamps.
Chris
From: r...@lynden.com
To: u2-users@listserver.u2ug.org
Date: Thu, 5 Jul 2012 09:22:02 -0700
Subject: Re: [U2] RESIZE - dynamic files
Chis,
I still am wondering what
.
Chris
To: u2-users@listserver.u2ug.org
From: wjhon...@aol.com
Date: Thu, 5 Jul 2012 20:12:21 -0400
Subject: Re: [U2] RESIZE - dynamic files
A BASIC SELECT cannot use criteria at all.
It is going to walk through every record in the file, in order.
And that's the sticky wicket. That whole
above I'm just trying to get an idea of what these should be
set at.
Thanks,
Chris
From: cjausti...@hotmail.com
To: u2-users@listserver.u2ug.org
Date: Tue, 3 Jul 2012 10:28:17 -0500
Subject: Re: [U2] RESIZE - dynamic files
Doug,
When I do the math I come up with a different # (see
to be bigger than the number of groups (92,776
in this case)?
Chris
Date: Tue, 3 Jul 2012 11:04:53 -0600
From: dave...@gmail.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] RESIZE - dynamic files
Yep, I added an extra 2 in the key value. Oh, the perils of cut and
paste
So for this example what would be a good SPLIT level and what would be a good
MERGE level to use? It was my understanding that I wanted to lower my merge to
something below 50% and
increase the split to reduce splitting.
Chris
From: r...@lynden.com
To: u2-users@listserver.u2ug.org
Date
need to double your modulo, roughly. If you keep it the same you need
to increase your modulo because 31% of your file is in overflow.
Chris
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http
records.
Chris
From: r...@lynden.com
To: u2-users@listserver.u2ug.org
Date: Tue, 3 Jul 2012 10:21:16 -0700
Subject: Re: [U2] RESIZE - dynamic files
(record + id / 4096 or 2048)
You need to factor in overhead the split factor: (records + ids) * 1.1 *
1.25 / 4096(for 80
tinkering with it to reach a lower
overflow %?
Correct me if I'm wrong but it seems the goal here is to REDUCE the overflow %
while not creating too many modulus (groups).
Chris
File name .. GENACCTRN_POSTED
Pathname ... GENACCTRN_POSTED
File type
... 21508521 bytes
Unused space ... 527323832 bytes
Total space for records 836227072 bytes
My overflow is now @ 2%
My Load is @ 37% (actual)
granted my empty groups are now up to almost 3% but I hope that won't be a big
factor. How does this look?
Chris
From: dangf
This is why I'm confused.. Is the goal here to reduce 'overflow' or to
keep the 'Total size' of the disk down? If the goal is to keep the total
disk size down then it would appear
you would want your actual load % a lot higher than 37%.. and then ignore
'some' of the overflow..
Chris
the split.load? What should my SPLIT.LOAD be around,
and how do you come up with that %?
Chris
From: r...@lynden.com
To: u2-users@listserver.u2ug.org
Date: Tue, 3 Jul 2012 14:45:28 -0700
Subject: Re: [U2] RESIZE - dynamic files
37% is a very low load. Reading disk records takes much longer than
)
Total size . 450613248 bytes
How do you calculate what the modulus and separation should be? I can't use
HASH.HELP on a type 30 file to see the recommended settings
so I was wondering how best you figure out the file RESIZE.
Thanks,
Chris
)
Total size . 450613248 bytes
How
do you calculate what the modulus and separation should be? I can't use
HASH.HELP on a type 30 file to see the recommended settings
so I was wondering how best you figure out the file RESIZE.
Thanks,
Chris
of record IDs ... 19283300 bytes
Unused space ... 171626404 bytes
Total space for records 449597440 bytes
Thanks,
Chris
From: cjausti...@hotmail.com
To: u2-users@listserver.u2ug.org
Date: Mon, 2 Jul 2012 14:55:21 -0500
Subject: [U2] RESIZE - dynamic files
I
tuning a dynamic file?
Chris
From: martinphill...@ladybridge.com
To: u2-users@listserver.u2ug.org
Date: Mon, 2 Jul 2012 20:56:40 +0100
Subject: Re: [U2] RESIZE - dynamic files
Hi Chris,
The whole point of dynamic files is that you don't do RESIZE. The file will
look after itself
as needed.
Chris
To: u2-users@listserver.u2ug.org
From: wjhon...@aol.com
Date: Thu, 17 May 2012 16:13:31 -0400
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
You have two issues.
One is to create a list from an exploded multi-value
The other issue, is to dedupe that list.
Without using
[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
That works beautifully George, thanks for the tip! I've never used the
MERGE.LIST command before, I assume the line you have
0005: MERGE.LIST 1 UNION 1
basically take the list #1 and shakes out the unique values?
Chris
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
wouldn't list 3 look like the following?
list 3 = 1,1,2,2,3,4,5,6,8
How does it DEDUPE list 1? The description says it 'contains all elements from
list1' but there could be duplicates in list 1 so how do those get shaken out?
Chris
From: ggal...@wyanokegroup.com
To: u2-users
was excellent.
Chris
From: r...@lynden.com
To: u2-users@listserver.u2ug.org
Date: Thu, 17 May 2012 14:07:24 -0700
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
UNION would definely be an alternative, but doing it against a needlessly
long second list offends my Scotch genes
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
/gmane.comp.db.u2.general/65456
Chris
Date: Tue, 6 Mar 2012 11:34:31 -0800
From: harold.o...@clark.wa.gov
To: u2-users@listserver.u2ug.org
Subject: [U2] Universe 10.2 to 11.1
All:
Who has upgraded Universe 10.2 to 11.1? Difficult or not? Costs? Time?
More generally, I'm addressing anyone using
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
a uvrestore I get:
A fatal error has occurred in uniVerse
Unable to create or attach the Printer Segment
Any idea what would be causing this? Anything to do with connection pooling?
(our new install has connection pooling set at 0)
Chris
a uvrestore I get:
A fatal error has occurred in uniVerse
Unable to create or attach the Printer Segment
Any idea what would be causing this? Anything to do with connection pooling?
(our new install has connection pooling set at 0)
Chris
or attach the Printer Segment
Any idea what would be causing this? Anything to do with connection pooling?
(our new install has connection pooling set at 0)
Chris
___
U2-Users mailing list
U2-Users
does that command do? I
didn't see it in the command reference guide.
Chris
Date: Tue, 28 Feb 2012 17:51:39 +0100
From: aalo...@quiter.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] uvrestore - Unable to create or attach the Printer Segment
Hi.
You said you just upgraded.
Have
my VOC, I select yes. Then if I execute
UV it shows that I'm still on version '10.1' so maybe I need to run UVREGEN?
Chris
From: br...@brianleach.co.uk
To: u2-users@listserver.u2ug.org
Date: Tue, 28 Feb 2012 17:24:31 +
Subject: Re: [U2] uvrestore - Unable to create or attach the Printer
prompt it won't work,
however the CMD prompt does..
Chris
From: br...@brianleach.co.uk
To: u2-users@listserver.u2ug.org
Date: Tue, 28 Feb 2012 17:24:31 +
Subject: Re: [U2] uvrestore - Unable to create or attach the Printer Segment
Just a thought - you've changed the uv directory, has your
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
system and I do have a .uvconfig file in C:\U2\UV\bin.
Am I running this correctly?
Date: Tue, 28 Feb 2012 19:08:40 +0100
From: aalo...@quiter.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] uvrestore - Unable to create or attach the Printer Segment
Hi Chris
You should run bin
ran successfully. However I still get that
error when I try to run UV from telnet..
Chris
From: cjausti...@hotmail.com
To: u2-users@listserver.u2ug.org
Date: Tue, 28 Feb 2012 12:44:27 -0600
Subject: Re: [U2] uvrestore - Unable to create or attach the Printer Segment
I'm not sure if I'm
it correctly shows C:\U2\UV.
Thanks for the help everyone!
Chris
Date: Tue, 28 Feb 2012 10:36:40 -0800
From: bob_woodw...@k2sports.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] uvrestore - Unable to create or attach the Printer Segment
Since you're able to get to the DOS prompt using telnet
and then install 11.1.1?
I'll be using the old VOC's for the regions when I get it setup.
Thanks,
Chris
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Doug,
What do you mean by use the 'modify option'? Is that an option when you upgrade
during the install?
Thanks,
Chris
Date: Mon, 27 Feb 2012 12:46:46 -0700
From: dave...@gmail.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UPGRADING - 10.1.18 to 11.1.1
Hi Chris
Is it safe to clear out the ..UV/UVTEMP folder? What does the UVTEMP folder
contain? I see I have thousands of files in there
and some are giving me permissions problems. It would be nice to clear this
folder out if I can.
Does anyone know if this is safe to do?
Chris
From: 3xk547
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
the ODBC driver up.
Hope this helps.
Chris
Date: Tue, 13 Sep 2011 19:44:25 -0400
From: jthompson...@gmail.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] 64-bit ODBC driver for win 7
If you are running Universe 10, I doubt the version 11 driver will
work. Let me know as I am
Cool, If you have any issues let me know. It's really straight-forward though,
the big thing was using the 11.x client
from Rocket!
Chris
Date: Wed, 14 Sep 2011 15:41:00 -0400
From: jthompson...@gmail.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] 64-bit ODBC driver for win 7
. Check your computers system information to see
whether you need a 32-bit or 64-bit version of the program'
Where can I download the 64-bit version of the UniVerse ODBC drivers?
Thanks,
Chris
___
U2-Users
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-bit ODBC driver for win 7
Hi Chris,
I suggest you download the latest client software package from
Yes,
That is correct DIM X(25) to initialize X, how do we then get the size of X?
Thanks,
Chris
From: gglorfi...@vertisinc.com
To: u2-users@listserver.u2ug.org
Date: Thu, 18 Aug 2011 13:41:17 -0400
Subject: Re: [U2] easy way to get count of a DIM()?
First off, I've never seen
We're trying to create the dimensioned array at run time with a size based on a
variable, which works in UniVerse
when using the -STATIC.DIM option. We need to know (in another program), what
the size of that dimensioned array is.
Chris
From: ggal...@wyanokegroup.com
To: u2-users
on
a variable, which works in UniVerse
when using the -STATIC.DIM option. We need to know (in another program), what
the size of that dimensioned array is.
Chris
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Thu, 18 Aug 2011 12:48:53 -0500
Subject: Re: [U2] easy way
of rewriting a file,
or does it really not matter a great deal ?
Thanks,
Chris
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
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: jthompson
lol, you're right I did John.. it must be a long day.
Chris
Date: Tue, 9 Aug 2011 16:08:57 -0400
From: jthompson...@gmail.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UV 11.1 64-bit on Cisco UCS with NetApp Filer?
I think you might have replied to the wrong post :)
On Tue
indexed the
field name it doesn't
seem that we can use CONV MCU, is there a work around to this?
Thanks,
Chris
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2
I'm not exactly following you. Would this dict item called NAME.UPCASE, would
that be a new field to test this or woudl that be a specific field
used to do the conversion? What would the dictionary look like.
Chris
From: bl...@shaklee.com
To: u2-users@listserver.u2ug.org
Date: Tue, 26 Jul
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 in regards to the case-sensitive.
Chris
From: bl...@shaklee.com
To: u2-users
Basically what I tried was editing the existing DICT entry for the field NAME,
by placing the value MCU in line #3. I don't think this is what
John referred to though. Should I keep the field NAME like it is now (without
the MCU) and create another DICT entry?
Chris
From: bl...@shaklee.com
:
NAME
0001 D
0002 5
0003
0004 Name
0005 25L
0006 S
0007
0008 CHARACTER,25
So I would be creating another DICT entry called NAME.UPCASE, the part I don't
understand is
#1) what that DICT would look like
#2) how that DICT entry would be used
Sorry for the numerous questions.
Chris
into the
same issue. It's almost like you can't index a field and use MCU on it at the
same time..
Chris
From: u...@edclark.net
Date: Tue, 26 Jul 2011 14:09:13 -0400
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] CONV MCU on indexed field?
universe or unidata? what flavor?
I don't see
to rebuilding the index using upper case I assume you mean
putting the MCU in the DICT on CLIENT and then doing the
CREATE.INDEX/BUILD.INDEX?
Chris
Date: Tue, 26 Jul 2011 13:27:14 -0500
From: cstew...@tri-sysconsulting.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] CONV MCU
with wildcards just on the back.
If anyone has a reason why this is like this, I would be very interested to
know why.
Chris
From: u...@edclark.net
Date: Tue, 26 Jul 2011 14:44:00 -0400
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] CONV MCU on indexed field?
universe is doing
and then having that apply the MCU or upper case command.
Thanks for the help today everyone!
Chris
Date: Tue, 26 Jul 2011 14:58:57 -0400
From: jthompson...@gmail.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] CONV MCU on indexed field?
Probably a bug. Should be reported to rocket
that
will eventually be paginated.
Chris
Date: Tue, 26 Jul 2011 14:11:33 -0500
From: ropor...@ochsner.org
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] CONV MCU on indexed field?
Just curious and maybe I missed it...
Has anyone tried LIKE and ... instead?
I wouldn't think
for performance.
Chris
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Tue, 26 Jul 2011 14:27:58 -0500
Subject: Re: [U2] CONV MCU on indexed field?
I think your running in PICK mode, and I know that LIKE works in PICK flavor
as well.
LIKE is the equivilent
clients? Is there a way to do this?
For example if I wanted to return the next 10 CLIENTS, without including any of
the first 10.
Chris
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http
] '
Date: Wed, 20 Jul 2011 11:38:50 -0600
From: dave...@gmail.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SELECT question, paginated select.
Hi Chris:
This is a problem we first tried to figure out when we went to the Web. The
easiest way for us was to save off the client
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
WITH INDEX_1 = 00CAPGE]
how would you limit that to the first 10 entries? And then how would you get
the next 10 after that?
We're on UniVerse so I assume the UniData commands below won't work for our
application.
Chris
Date: Wed, 20 Jul 2011 11:39:42 -0700
From: wphask...@advantos.net
this, Bill says that you have to do a
dance in UniVerse. I guess I'm curious what this dance is that I need to do?
If it's not handled in the SELECT then what technique are you using in UniVerse?
Chris
Date: Wed, 20 Jul 2011 13:59:48 -0500
From: cstew...@tri-sysconsulting.com
To: u2-users
I have no idea what the BSCAN directive is? Is that a UniVerse command? It
seems that there's not really a straightforward consensus on
the solution to this problem.
Chris
From: lar...@wcs-corp.com
To: u2-users@listserver.u2ug.org
Date: Wed, 20 Jul 2011 12:42:10 -0700
Subject: Re: [U2
Interesting, I wonder if anyone still has an example of this?
Chris
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Wed, 20 Jul 2011 15:15:58 -0500
Subject: Re: [U2] SELECT question, paginated select.
I thought we discussed this about a year ago, with the solution
George,
Is the dictionary change below used for the SQL solution you mentioned? In
other words, do I have to add this to use the SQL queries
to paginate it based on row? Or is this a trick to use a UniVerse SELECT?
Chris
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date
#'s.
To paginate in order using the 2 selects are you suggesting I do something like
SELECT CLIENT WITH NAME = A] and then save that to a LIST where I use
it in the 2nd SELECT with PAGE = 4?
Thanks for the help so far, I believe I have the PAGE I-descriptor setup
properly.
Chris
From: ggal
Thank you! We don't do a lot of double select statements in our programs, I
assume you do the 1st SELECT and then do some sort of CAPTURED or PASSLIST
command
to pass the first selected values into the 2nd SELECT.
Chris
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
CLIENT WITH PAGE = A
Without setting up a VOC entry is there an easy way to execute 2 selects in a
program (just like in telnet)?
Chris
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Wed, 20 Jul 2011 16:50:08 -0500
Subject: Re: [U2] SELECT question, paginated select
George,
The first example worked beautifully, thanks for all help! :)
Chris
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Wed, 20 Jul 2011 16:58:38 -0500
Subject: Re: [U2] SELECT question, paginated select.
If your doing the selects from a Basic program
OK cool, thanks. Just out of curiosity how would you do 2 selects using a
PASSLIST?
Chris
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Wed, 20 Jul 2011 17:06:50 -0500
Subject: Re: [U2] SELECT question, paginated select.
SORRY, My mistake.
that should have
it, or is it a system level
command when you stack select's that the system processes 1 first, then the 2nd
with the first's results.
Chris
From: cjausti...@hotmail.com
To: u2-users@listserver.u2ug.org
Date: Wed, 20 Jul 2011 17:14:53 -0500
Subject: Re: [U2] SELECT question, paginated
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
corresponding field
So based on what it's saying, the dictionary doesn't contain the corresponding
field. Any help is appreciate, thanks.
Chris
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http
I am out of the office until 26/04/2011.
The Milton Keynes office is closed on Friday and Monday for Easter public
holidays.
For 8.5 migration and concierge queries issues requiring attention before
Tuesday, please email lha...@us.ibm.com and pkl...@us.ibm.com. For urgent
problems please raise
Sorry about this - I will try to work out a way to block these.
Regards
- Chris Thornton
From: Chris Thornton1/UK/IBM@IBMGB
To: U2 Users List u2-users@listserver.u2ug.org
Date: 21/04/2011 16:40
Subject:[U2] AUTO: Milton Keynes office closed for English public
holidays
1 - 100 of 180 matches
Mail list logo