It is true that the sample is the first execution before the sorting
takes place. Oracle DB dose the same thing.
I was unsuccessfully trying to use sub-query in this case.
Kathy
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward
Sent:
What about SSELECT FILE FIRST 2?
Thanks,
Nick Cipollina
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, May 25, 2006 9:03 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] OK...Is there a wayUV
ED DICT
Adrian,
So what would it take to post the solution (with code) for those of us who
do not want to re-invent the wheel?
Cheers,
Angelo
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Adrian Merrall
Sent: Thursday, May 25, 2006 6:01 PM
To:
FIRST is a synonym for SAMPLE. And that example won't return the first
two of the sorted file.
The reccount item is a better way to go.
Rog.
Nick Cipollina wrote:
What about SSELECT FILE FIRST 2?
Thanks,
Nick Cipollina
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
NOPE. Same thing.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Nick Cipollina
Sent: Friday, May 26, 2006 8:25 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] OK...Is there a wayUV
What about SSELECT FILE FIRST 2?
Thanks,
Nick
Not sure how spaces enter into it, although I see that it yields the
same in the following with or without spaces.
j
0001 EXECUTE 'CT JMRBP TEST.FOLD'
0002 A = A B C D E F G H I
0003 CRT LEN(A)
0004 CRT 'A:':A
0005 B=FOLD(A,1)
0006 CRT 'LEN B:':LEN(B)
0007
Two selects can be faster than one...so, there's no need to worry about
the number of selects. The Unidata optimization routines for multiple
indexes are not always as fast a manually tuned, multiple selects...
-Original Message-
From: Vance, Kathy [mailto:[EMAIL PROTECTED]
Sent:
George
Hmmm, how are your IDs ordered?
Just wondering whether something along these lines might work...
SELECT ID TO SLIST 0 FROM YourFile WHERE ID = (SELECT MIN(ID)+1 FROM
YourFile) ORDER BY ID;
Brian
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
hmm. there's a new one.
Yes, that did work.
Thanks
George
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, May 25, 2006 9:03 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] OK...Is there a wayUV
ED
I wondered when SQL would come into this:)
Only problem is that the filename has -'s in it, but
I suppose I could always make a Q pointer.
I'll have to try that later. Thanks
George
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Brian Leach
HMM. No. Now it's not working, It returns all ID's.
I must have done something wrong. Seems it doesn't
like to be used in the selecting stage, but will be
happy to be used in the display stage.
SSELECT file WITH RCNT 3
RCNT is setup as below except I didn't call it REC.COUNT
-Original
The easy answer is that it probably does a TRIM prior to the fold.
Thus the all-spaces field becomes null, and the fold cannot work on a
zero length field. And its not a problem, only a curiousity. I
discovered it while looking for garbage in production records, making
use of LES in order to
Hi Everyone -
First, thanks for the kind words about Informer. Always great to hear
customer experiences.
A couple points: Informer is engineered to integrate with any(!) security
model. We offer the ability to use a packaged native system or the ability
to integrate in one click with an LDAP
Also the same bad results when I tried either old Pick style methods
NI.CNTR9998.CNTR
001 A A
002 0 9998
008 ANI+'0'
009 R R
010 8 8
Rog
George Gallen wrote:
HMM. No. Now it's not
I'm getting this error and I don't know how to fix it. A full reboot
hasn't helped:
Program UPDATE.OI.GL.FROM.ORDER:
Line 97, FATAL: The locks necessary for database operations at the current
isolation level (0) are not held by this process.
The program
is a basic subroutine which is called by
Hello,
I have universe 10.1.18, I need read XML with a unknown format and load into
universe file.
Anyone has experience using XDOM in universe basic.
Thaks for all
Salvador Rigau
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
If your Trigger Subroutine is going to Write, it must be first READU the
item.
Mark
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Charles Barouch
Sent: Friday, May 26, 2006 8:47 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Locking Error (Maybe
Not too familiar with sb, but if it is re-opening the file, then any
record locks are lost. A workaround MIGHT be to issue a RECORDLOCKU in
the subroutine prior to the write.
j
On 5/26/06, Charles Barouch [EMAIL PROTECTED] wrote:
I'm getting this error and I don't know how to fix it. A full
Mark,
That appears to work. I'm really not
sure why, though. I appreciate the help.
--
Charles Barouch
[EMAIL PROTECTED] - Consulting
[EMAIL PROTECTED] -
ETL/Migration/Integration
(718) 762-3884x1
Mark Eastwood
wrote:
| If your Trigger Subroutine is going to Write, it must be
first READU
The security I was talking about was at the application level - as I
said you guys 'supposedly' have that in now, but not at the time we were
looking at it - I'm talking about row by row security based on data
selects. That's a finer level grain than login security. We liked your
login security.
Hello List,
I have a problem with the bci inserting into sql server. I'm running UV
10.1.10, W2K Sp2.
I've already ran it thru IBM and they tell me it is a problem on the sql
server side.
Here is my problem:
I have a uv program that inserts into a table in sql server via a stored
Hello list,
I solved my problem. It was my own fault. I'm almost to embarrassed
to say, but maybe someone will learn from it.
I added 2 new fields to my sproc and sqlbindparameter, I FORGOT to
update my parameter markers !
I know, I know it was really dumb, geez.
Rudy
From:
What is the proper way to use the USING keyword in a list? It doesn't
seem to work as stated in the manual unless I am using (no pun intended)
wrong. According to the manual this is how the command is used.
LIST [DICT | USING [DICT] dictname] filename [records | FROM n]
[selection]
I'm not really sure why this is our standard, but we always put it at the end
of the statement:
LIST CUSTOMER.FILE CUST.NAME USING DICT TEMP.DICT
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jerry Banker
Sent: Friday, May 26, 2006 1:59 PM
To:
I got an email today announcing U2 Web Development Environment 4.3. Beyond
a new name, does anyone have any specifics on what's new in there? There
seems to be mention of a new IDE and scheduler enhancements.
Thanks,
Mike
---
u2-users mailing list
u2-users@listserver.u2ug.org
To
Tried that, did not work. UV 10.1.12 flavor Reality
LIST BLP.TEMP CONT.MOS USING DICT CUST.MSTR.TEMP
RetrieVe: syntax error. Unexpected symbol. Token was DICT.
Scanned command was LIST BLP.TEMP CONT.MOS USING DICT
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
Using the demo files that come with universe (MAKE.DEMO.FILES creates
them) I can
LIST USING DICT INVENTORY.F CUSTOMER.F
And
LIST USING DICT CUSTOMER.F INVENTORY.F
And
LIST CUSTOMER.F USING DICT INVENTORY.F
Not that any of those commands make any sense ;-) but they all work.
So maybe there's
Make sure you don't have a Dict item named DICT in either file.
Mark
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price
Sent: Friday, May 26, 2006 2:57 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UV - USING keyword
Tried that, did
Angelo,
So what would it take to post the solution (with code) for those of us who
do not want to re-invent the wheel?
As I worked on it in company time I will have to check with the boss
but all the required libs (poi, digester and log4j) are oss so sharing
it would be in the community
29 matches
Mail list logo