Re: [U2] General guidelines on indexing

Ok I am very jealous now of all these quick times, when my one crashed out Can someone remind me (its been years since i did any udt config stuff) what should i be looking at to fix this error Thanks PS - i like this thread i think this can be of benefit to people to fine tune both code

Re: [U2] General guidelines on indexing

Well, if it makes you feel better, my test crashed out with a similar error message as well. The size shown was about half of what you had, otherwise the same message. UD 5.2 on Solaris 5.2 (I think). I know it's old, but that's all they give me. Symeon Breen wrote: Ok I am very jealous now of

Re: [U2] General guidelines on indexing

It sounds to me like you guys are hitting a limit on the size of the memory segment. If that's true its tuned as a kernel parameter. I'd check there first and then try other ideas. - Josh -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] Calculation on multi-valued elements

Remember that when dealing with Multi-values in an I-Descriptor you must use MV logic throughout. So yes the -, +, *, / all have MV support but the IF, THEN, ELSE does not. Use the SUBRs that are provided like -EQS and -IFS. Thanks, David A. Green www.dagconsulting.com (480) 813-1725

Re: [U2] General guidelines on indexing

Me too. Blew up immediately. IBM P570 AIX 5.3 UV 10.2.4 Mecki Foerthmann wrote: Well, if it makes you feel better, my test crashed out with a similar error message as well. The size shown was about half of what you had, otherwise the same message. UD 5.2 on Solaris 5.2 (I think). I know it's

[U2] UV and triggers

I need to setup a trigger on a Universe file to track changes to one item. The book is quite confusing on setting up triggers... I understand how to compile the program (and read in the appropriate data). I just can't figure out how to get the trigger on the file to work I tried CREATE TRIGGER

Re: [U2] General guidelines on indexing

I have 2 RH Linux AS3 64bit servers one on a Dell 6800 with 4 processors and 16GB memory with UV 10.1.12 and 117 users. The other is a Dell 2500 with 2 processors and 16GB memory with UV 10.2.4 and 6 users. The first takes 0.1876 seconds and the second is 0.1106 seconds. The time varies with the

Re: [U2] UV and triggers

I use 'fake' triggers. Create an Index on the file to an I_Descriptor which calls a subroutine. Charles Trigger Happy Barouch George Gallen wrote: I need to setup a trigger on a Universe file to track changes to one item. ___ U2-Users mailing

Re: [U2] UV and triggers

I meant to say, one attribute. I'll have to play with the indexing, sounds like it could work also. Thanks George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Results Sent: Friday, July 10, 2009 3:48 PM

Re: [U2] UV and triggers

It seems okay to me. What file type is the file you're trying to add the trigger to? - Josh -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, July 10, 2009 3:20 PM To: U2 Users List

Re: [U2] UV and triggers

I think the problem is I don't have a schema defined to store the trigger in. I've never worked with SQL related extensions. Is this a lot of work to setup the schema? Will if affect the file I'm setting the trigger on in any way? Thanks George -Original Message- From:

Re: [U2] UV and triggers

The subroutine needs to be globally cataloged and therefore its name will begin with an asterisk. CATALOG filename *BTPEMAILTRIGGER CREATE TRIGGER EMAILUPDT AFTER INSERT OR UPDATE OR DELETE ON NABTP FOR EACH ROW CALLING '*BTPEMAILTRIGGER' ; If you are running in a PICK flavour account then

Re: [U2] UV and triggers

The file doesn't have to be part of a schema and doesn't have to be a SQL table: Universe will add a SICA to the file as part of the trigger definition. But it does need to be a file and not a directory i.e. not type 1 or 19. Also the trigger routine should be globally cataloged. Brian

Re: [U2] UV global catalog in Pick flavour

I wanted to catalog a subroutine globally so that it could be accessed by IBM .Net data provider for U2. But the catalog routine does not allow this in the PICK flavour of UniVerse. Has anyone found a way round this. Regards David Jordan ___

Re: [U2] UV and triggers

I keep getting 'Statement triggers are not supported.' The file is type 30 What is the syntax for a basic trigger statement, maybe I have something wrong. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of

Re: [U2] UV and triggers

OK. One problem down, the filename contained an which seemed to be giving problems. I setup a Q pointed from NABTP to NABTP. now I get: CREATE TRIGGER TRIG1 AFTER INSERT OR UPDATE OR DELETE ON NABTP FOR EACH ROW CALLILNG *TRIGGER_TEST; UniVerse/SQL: Invalid file type specified. Warning: SICA

Re: [U2] UV global catalog in Pick flavour

Thanks Josh ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users