Hi, all. I'm new to this forum, but have been programming multivalue database
apps for years. I ran across something here that really has me puzzled. I
wonder if anyone has seen something like this and might be able to shed a
bit of light as to what's happening.
I'm running Unidata 6.0 on hpux.
Instead of using a SELECT statement build an index on TRADE_CODE in the TRADES
file. Use the unibasic index command SETINDEX to tell you if a specified value
has any entries in the TRADES file.
I don't think a trigger subroutine is an appropriate place for a SELECT
statement.
-Original
Just a thought would be to change your select to use the non-default active
select list. For example, instead of:
CMD='SELECT TRADES WITH TRADE_CODE = ':CODE_DEF_ID:''
try
CMD='SELECT TRADES WITH TRADE_CODE = ':CODE_DEF_ID:' TO 2'
If you are running in PICK flavor, change the SELECT to select
I would change the SELECT to an XLATE command.
David A. Green
(480) 813-1725
DAG Consulting
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jonathanm
Sent: Thursday, April 21, 2011 8:03 AM
To:
I think this was a check to prevent deletion of a CODE_DEFS record if in use in
the TRADES file, so XLATE wouldn't help.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green
Sent: Thursday, April 21,
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
You're right of course that would only work if you have access to the key.
If you don't then creating an Index is the best way to go.
David A. Green
(480) 813-1725
DAG Consulting
-Original Message-
From: Dave Davis [mailto:dda...@harriscomputer.com]
Sent: Thursday, April 21, 2011 8:36
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
Do I forsee any upcoming t-shirts?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Chris Thornton1
Sent: Thursday, April 21, 2011 12:19 PM
To: U2 Users List
Subject: Re: [U2] AUTO: Milton Keynes office closed
From: George Gallen ggal...@wyanokegroup.com
Do I forsee any upcoming t-shirts?
Royal Wedding holiday is not till next Thursday; I've so far resisted that
particular temptation.
Regards
- Chris Thornton
Unless stated otherwise above:
IBM United Kingdom Limited - Registered in
I would agree -- if there is an active select list, then you would get some
seriously unexpected behavior doing another select unless you 'pushed' that
new select to a different 'List ID' than the default '0' list -- just ensure
it's a ListID that you KNOW would never be used anywhere else. Back
Not knowing the size of the original files, as long as they are not too big,
adding an index just to get a trigger to work might be serious overkill. You
would need to make that call as only you know the size and performance hits
involved in this.
Just my 2 cents worth (1 cent in this
On 4/21/2011 11:03 AM, jonathanm wrote:
Hi, all. I'm new to this forum, but have been programming multivalue database
snip
I really need to have it perform the intended check before deletion. Any
ideas?
Your execute of the SELECT will potentially result in an active select
list that doesn't
Then there is the possibility of adding another trigger to the update of the
TRADES file that builds a CODES.XRF cross reference file. You avoid the large
nothing index, gives you a straight READ, plus it's an easy rebuild program.
-Original Message-
From:
Come to think of it, you could even use the CODE_DEFS file for its own cross
reference. Since it's such a simple file with probably only a single
attribute, use the second attribute as a MV field of TRADES ID values. But
then you have possible lock issues that might not make this a smart
COUNT would give you the wrong result if a select list was active at the time
you executed it.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Egerton
Sent: Thursday, April 21, 2011 12:57 PM
To: U2 Users List
Thanks, all. A few things I've observed:
1. It doesn't matter what type of command is being EXECUTEd; the problem
persists. I've tried the suggestions here, plus unrelated commands such as
DATE or WHERE. It seems that anything EXECUTEd will cause the ID to be
lost because the process is, I
Do you have any problem when using a UniBasic DELETE instead of an ECL DELETE?
Wally Terhune
U2 Support Architect
Rocket Software
4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA
Tel: +1.720.475.8055
Email: wterh...@rs.com
Web: www.rocketsoftware.com/u2
-Original Message-
Not knowing when the trigger were being called, even the COUNT would be
'dinged' if there is an active SELECT list. That would be a problem!
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Egerton
Sent:
Nice catch, Wally. It appears to work for a UniBasic DELETE, but definitely
not for the ECL DELETE.
I suppose that is because the UniBasic runtime environment does not share
its symbol table with the shelled EXECUTEd environment, so overwriting
system variables (ID, filename) doesn't matter. Is
Uh, don't grant your users ECL access? :-)
Feel free to submit this request via your U2 support provider. Not sure how
easily it could be accomplished, but we will give it consideration when it
percolates up to me. Certainly nothing we would fix at your old release level
(6.0.unknown) - even
We are doing this with a county and zip file - the trigger is on the
county file and a record cannot be deleted if it's referenced in the zip
file:
SUBROUTINE TRIG.COUNTY.DEL (EXECSTAT, DICTFLAG, FILENAME, COUNTY_ID)
EQU DELETE_DENIED TO 0
EQU DELETE_ALLOWED TO 1
EXECSTAT = DELETE_DENIED
IF
The one risk I see here is if you are at TCL and have a bunch of keys in an
active select that you are going to delete. If THAT select list is not loaded
into one of the higher active select buffers (i.e. 1-9), you will have some
nightmares when the SELECT in the trigger clobbers the SELECT
Wally Terhune-2 wrote:
Uh, don't grant your users ECL access? :-)
I've often said the computer system would work fine if we could keep people
off of it.
Wally Terhune-2 wrote:
Feel free to submit this request via your U2 support provider. Not sure
how easily it could be accomplished,
Wow! This is really similar to what I'm trying to do. What is your: OS,
Unidata version, BASICTYPE?
Also, are you having success with both ECL DELETEs and UniBasic DELETEs?
Thanks!
Jonathan
Shaun.Ferguson wrote:
We are doing this with a county and zip file - the trigger is on the
county
Good word of caution, John. Thanks.
Israel, John R. wrote:
The one risk I see here is if you are at TCL and have a bunch of keys in
an active select that you are going to delete. If THAT select list is not
loaded into one of the higher active select buffers (i.e. 1-9), you will
have some
Know the feeling.
There is only so much rejection one can take.
Martin Scholl
18910 New Hampshire Ave
Brinklow, MD 20862
301-924-5537
301-613-9572 (Cell)
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Karl Pearson
Adiós mi amigo. Te veré en el lado oscuro de la luna.
I myself am studying Thinking in Java
Quite frankly I enjoy PICK so much more. OOP is just too close to Ops!
But when I search for pick jobs in a 50 mile radius of my house there's just
nada.
When I search for Java within 10 miles of
Karl, I never knew thee, but I wish you the absolute best. Whatever your
career takes you, own your future!
-Kevin
http://www.PrecisOnline.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
29 matches
Mail list logo
