In message
,
Edward Brown writes
After indexing, we made a lot more use of the SETINDEX and READFWD
logic
in our programs.
I find this curious / disappointing - is it really the case that unidata
can't take the mix of indexed / unindexed dictionary items and do just
as efficient a job as the
UniData has a 2 gig limit on hashed files. What is the exact limit? Is it
really 2,147,483,648 (2**32)or is "2 gig" a loose term. What is the true
"threat" level? Is it truly 2**31, or is it something else?
We will need to do something soon, but how soon is what I am trying to
determine.
> UniData has a 2 gig limit on hashed files. What is the exact limit?
> Is it really 2,147,483,648 (2**32)or is "2 gig" a loose term. What
> is the true "threat" level? Is it truly 2**31, or is it something else?
>
> We will need to do something soon, but how soon is what I am trying
> to det
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Brian Leach
> Sent: Saturday, July 11, 2009 6:06 AM
> To: 'U2 Users List'
> Subject: Re: [U2] UV and triggers
>
> George
>
>
> - Instead of a Q pointer, what happe
At least the trigger firesDo I need to set a flag so the write
goes through?
George
ED NABTP NEWONE
0001: TEST
0002: TEST
:FI
TRIG1 NEWONE
Program "ED": pc = 726C, Trigger program "*TRIGGER_EMAIL" did not complete.
Program "ED": pc = 726C, Error performing trigger for "N&A
Since it's a subroutine, shouldn't you RETURN to get out, not STOP?
Also, once you get this running, be sure to CLOSE any files that it OPENs or
you will have problems.
Here is another tip: triggers need to be cataloged globally. However, they can
call other subroutines that are cataloged loca
0. I could not get it to work here.
1. How does DC get set to SB+ mode? When I go to
Setup/Terminal/Extensions it indicates...
SB
Arrow keys required by some users of SB+
Version 6.0.1
SB Keys
SB+ extension to VT100 V6.0.1
Set SB to WINTEG or VT10
I can't believe it was that!
Yes, putting in the RETURN cleared up the error.
Thanks
George
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
> Sent: Monday, July 13, 2009 11:04 AM
> To: 'U2 User
It has been my experience that you can RETURN out any program or subroutine.
If it is the top-level code, it simply stops. If it was called, it simply
returns back to the calling routine.
John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH 45342
937-866-
I have a "UniData Troubleshooting Guide 2004.pdf" I got from Wally at an
IBM conference several years ago. I think it is dated Aug 2004. It was
part of a "Survival Guide" session and is an indispensable piece of
documentation for UniData memory (and other) issues.
I couldn't find it on the i
Per the "UniData Troubleshooting Guide 2004.pdr"...
What should one look at when experiencing shared-memory problems?
Record the exact error message that appears.
Review the contents of ipclogs created. They will appear at the
directory level in the account
where the udt session died. An ex
Do I need to always add a READU before the WRITE, just to establish a lock?
(which is what fixed my problem)
Program "ED": pc = 726C, Program "*UPDATE.EMAIL.QUEUE": Line 21, FATAL: The lock
s necessary for database operations at the current isolation level (0) are not h
eld by this process.
Prog
To be safe, yes.
John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH 45342
937-866-0711 x44380
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Monday, July
Yes. Explicit READU or RECORDLOCKU before WRITE is always a good idea,
but if I recall, a necessity for triggers. Said necessity for triggers
may depend on how uvconfig ISOMODE is set, too. That I don't recall.
If you do recordlocku, you should only hit the lock table in memory
rather than th
Is there a way to list which tables have active triggers?
I know about LIST.SICA tablename, but if I make a change to the trigger program,
and I need to DROP the trigger from all the TABLES usings it, how would I
find
out all the TABLES that are using that trigger?
Is there an easier way t
In message <4a53ea56.5050...@gmail.com>, Charles Stevenson
writes
The semi-colon way of writing is more readable, but UV does not let you
reference such an I-descriptor (as reusable code) from some future one.
For example, next year you want to know how fast/slow certain programs
run during cer
Hi George
I wrote about this in one of the back issues of Spectrum (you can download
these from www.intl-spectrum.com).
I use a master trigger that reads a list of sub-triggers based on the file
name. Okay it's an extra read, but it's worth it: the list of sub-triggers
(which have the same calli
I'm in the process of rebuilding indexes on our new server (changed
platforms, ran convidx, but rebuilding just to be sure).
During a BUILD.INDEX FILENAME ALL on one of the files, I kept on getting
disconnected from my telnet session. So I started building the indexes
individually. I isolated the
Not sure if this was available in 6.1 but here is the help for GUIDE_NDX.
Generally, if I have an error in an index and decide to delete it I will delete
ALL which also deletes the X_ at the OS level and then completely rebuild it.
guide_ndx
Syntax
guide_ndx{-x |-X}{1|2 |3},{index_names, .
Thank you Colin. Good idea - that worked. And thanks for the info on
guide_ndx.
Have a nice day,
Amy
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke
Sent: Monday, July 13, 2009 1:03 PM
To: u2-users@lists
Thanks, I found the article. That would make tracking triggers easier.
One thing however, in the routine, you have
notriggers = dcount(triggers,@fm)
for trigno = 1 to notriggers
trigger = triggers(trigno)
call @trigger(...,newid,newrec,oldid,oldrec,...)
next trigno
Just curious, since with
All this talk about triggers and I just received the following from IBM.
7. UniVerse: Flashes
Using fixtool to repair UniVerse dynamic file header corruption may result
in data loss at 10.3.0
http://www.ibm.com/support/docview.wss?uid=swg21376672&myns=swgimgmt&mynp=OC
SSCRY4&mync=E
At UniVerse
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug
> Sent: Monday, July 13, 2009 5:34 PM
> To: 'U2 Users List'
> Subject: Re: [U2] which files have triggers
>
> All this talk about triggers and I just re
Bill,
It gets "set" by clicking, highlighting and saving the setup in DC. In
SB+ I have a modified TERM.DEFN setup similar to TERMITE.
My DC setup:
DC 6.0.1
Setup,Terminal,Emulation: VT220, Extensions: sb & sb_keys
Setup,Communications,Telnet: Terminal type: vt220, HostEcho: on,
BinaryMode: on
Th
Triggers are fired from within a transaction invoked by U2 and follow
normal transaction semantics. You *always* need to lock records (readu
or recordlocku) for write and it's best practice to use a readL (at
least) for reads.
Another thing which catches newbs out is that you will not be able to
u
25 matches
Mail list logo