It's a feature! For old legacy apps that use the marker (and other
control/non-printable) characters as part of the key and are too hard to change.
UV lets you turn that feature off, maybe UD does too now.
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
Morning All
I wonder if somebody can please assist me here.
What I need to do is SELECT the 1st Record saved from a file (AUDIT.HIST) for
a specific RECORD_ID.
The RECORD_ID Field is an indexed field on AUDIT_HIST.
I am trying to do this via a I-Descriptor calling a BP and it is returning an
Hi Bjorn,
Why are you using the BY RECORD_ID clause when you are selecting on
RECORD_ID = '1537044' ?
Should this be @ID for the first record on the AUDIT_HIST file?
Regards,
Kishor
Quoting Bjorn Behr be...@frstia.co.za:
Morning All
I wonder if somebody can please assist me here.
What I
Kishor
Sorry, should not be BY RECORD_ID, should be BY @ID
The key is RECORD_ID:DATE:TIME, RECORD_ID is in Field 1 in the record and
refers the the @ID of another file
There can be many RECORDS in the AUDIT.HIST File with the same RECORD_ID, but
there DATE and/or TIME will differ.
Regards
Bjorn,
If the Key is RECORD_ID:DATE:TIME then can't you just do a SELECT with
key like '1537044...' BY Key ?
Some people do index the key when they have compound keys.
Regards,
Kishor
Quoting Bjorn Behr be...@frstia.co.za:
Kishor
Sorry, should not be BY RECORD_ID, should be BY @ID
The
Bjorn,
This is the error you get when the I-Descriptor calls a subroutine that does a
SELECT. See this reply from Glenn Herbert to the same problem in March 2004.
Yeah. It's actually a bug in the program/itype unloading code that won't allow
you to do this. I ran upon this in May 2003 and,
Thanks Andy
I will look @ the SELECTINDEX then and see what I can work out.
Bjorn
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Andy Baum
Sent: 29 April 2009 10:57 AM
To: u2-users@listserver.u2ug.org
Subject: RE:
Thanks all for your assistance.
I managed to get it to work using Andy's suggestion of a Unibasic
SELECTINDEX Statement
-: SELECTINDEX RECORD_ID, @ID FROM AUDIT.HIST :-
And then just looping through to find the earliest record.
Your assistance was much appreciated
Bjorn
PS: David. IF you know
Bjorn,
Glad this worked a better way would probably be to use BSCAN :-
BSCAN IND.ID, IND.REC FROM FIRST.TEST,REC.ID USING 'RECORD_ID' RESET ELSE
FIRST.ID = IND.REC1
END
If your key is exactly as you have described then you may also hit some
problems with sorting as any
Hi All,
UV10.2.7 Pick
HPUX 11.11
Someone (ok me) decided to resize a file today from dynamic to static.B
ShortlyB a fter that, the system came to a halt because the type 30 semaphore
flag was stuck.B Can anyone tell me how/why this happened? The file I resized
is fine.B I've been using
Unfortunately that method wouldn't work. Also, I don't believe we have
ALLOWMARKS in UD.
I viewed the VOC file itself outside of Unidata to see what was actually
stored as the record ID, that way I could use a program to delete the
record.
Funnily, it contained Char(0)...
I can read and delete
11 matches
Mail list logo