RE: [U2] [UV] Can I get some advice on triggers?

2007-11-27 Thread Steve Long
Keith - Not sure if its the same on Universe, but on Unidata, you can type HELP CREATE.TRIGGER at the TCL prompt. The command is: CREATE.TRIGGER filename program name (has to be globally cataloged) UPDATE or DELETE. To create a trigger calling the program CUST.UPD on updates of the CUSTOMER

Re: RE: [U2] OCONV Extraction Question - Good Practice

2007-11-27 Thread Colin Jennings
Good code. What (TF) is that and how does that relate to a statements inclusion in a manual or not? Explain yourself and - the rules for you are - don't peek in a dictionary or use an electronic grammar or spell checker. ;-) Stuart Boydell Hi Stuart. Ignoring all dictionary and thesaurus

Re: [U2] [UV] Can I get some advice on triggers?

2007-11-27 Thread Jeff Butera
I'm hoping someone can give me some help on triggers. I want to put a trigger on a file to datestamp address changes. The system manual (25119270.pdf) says that triggers aer set up by the command CREATE TRIGGER trigger.name [BEFORE|AFTER|UPDATE] On Unidata it's CREATE.TRIGGER FILENAME

RE: [U2] Time Travel

2007-11-27 Thread Jerry Banker
I've got absolutely nothing against Australians as a matter of fact I admire them. If the way they are presented to us back here is correct, they remind me of the way people were in this country fifth years ago but with some added technology. People that believe in life, liberty, and the pursuit

RE: [U2] Good Practice?

2007-11-27 Thread Jerry Banker
Maybe your email Nazi isn't releasing your email until he's read it all? :-) -Original Message- From: MAJ Programming [mailto:[EMAIL PROTECTED] Sent: Monday, November 26, 2007 5:21 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Good Practice? Again, your response is out of

RE: [U2] Time Travel

2007-11-27 Thread Thomas Derwin
Thanks for the donation, Don. It's easy to forget that these things cost $$$. Tom Derwin [EMAIL PROTECTED] 11/26/07 7:55 PM Let me rephrase that. I donated the funds for the domain name and registered it. U2UG owns the domain in whole. I love whois..I should have paid for that privacy

RE: [U2] Wintegrate scripts

2007-11-27 Thread John Bullard
If (like me) you learn much better from looking at already written code: after you go and get the wIntegrate Client Scripting Reference from IBM's website (as Bill suggested), look at C:\Program_Files\wIntegrate\Example\Script\ProdM2.wis (or any of several others in that directory). There are

[U2] Badly overflowed Dynamic files

2007-11-27 Thread kevinsmith
I have yet to find someone who can give me a straight answer to this. I have a file that is badly overflowed (actually, I have a few files this way). It is affecting our batch processing with ridiculous complete times. What would be the best way to increase performance with this file. Do I

RE: [U2] Good Practice?

2007-11-27 Thread Thomas Derwin
I got an Editing Denied screen from Keith's link. This link works: http://www.pickwiki.com/cgi-bin/wiki.pl?GetKey Looks like a nice piece of code. Thanks, Keith. Enjoy, Tom Derwin [EMAIL PROTECTED] 11/26/07 11:19 PM However, this brings up a good practice thing to note. The seperator must

RE: [U2] Time Travel

2007-11-27 Thread Thomas Derwin
Looks like Majordomo sorts the list by domain, then by user. That would put advantos at the beginning of the list with correspondingly fast turnaround. My former domain started with d; now it's l and takes about 30 minutes longer. Regards, Tom [EMAIL PROTECTED] 11/26/07 10:35 PM Scott: I'm

RE: [U2] Time Travel

2007-11-27 Thread Lettau, Jeff
Maybe the US government isn't allowing the messages to process faster because they need to make sure they are safe for us to read. Because violating our freedoms is necessary to protect our freedom. I won't say anything else for fear of this ending up in my government file. 10:33am EST go!

Re: [U2] [UV] Can I get some advice on triggers?

2007-11-27 Thread David A Barrett
Keith, For some reason, they implemented Triggers only with SQL commands. I imagine that lots of people that might ordinarly think about using them have been put off by this. Anyways, the documentation is actually fairly reasonable with regards to this feature. It's in the SQL manual, however.

RE: [U2] Good Practice?

2007-11-27 Thread Burwell, Ed
2 questions: 1. What does nap 5 do? (sleep for 5 milliseconds?) 2. Is KEYIN() on Universe the same IN() on UniData? This is a very nice looking, easy to read and understand routine. Thanks. Ed Burwell Consultant Data Processing CASIO AMERICA, INC. 570 Mt. Pleasant Avenue Dover, NJ 07801

RE: [U2] Badly overflowed Dynamic files

2007-11-27 Thread Anthony Youngman
Overflowed groups take longer to read, so you want to reduce the number of such groups. Is the size of this file roughly constant, or does it just slowly grow? If it's roughly constant, try setting a MINIMUM.MODULO at around 900,000. It'll hopefully break up a lot of your badly overflowed

RE: [U2] Time Travel

2007-11-27 Thread Perry Taylor
Hrm... That makes me sad (zirmed.com) Perry Taylor Office (877) 494-7633 ext. 4392 Direct (502) 779-4392 Zirmed, Inc. 626 West Main St., 6th Floor Louisville, KY 40202 www.zirmed.com -Original Message- From: Thomas Derwin [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 27, 2007

RE: [U2] Time Travel [not-secure]

2007-11-27 Thread Hennessey, Mark F.
snip I won't say anything else for fear of this ending up in my government file. /snip Too late ;) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

[U2] How to create NFS mount points in UV

2007-11-27 Thread Sunny Matharoo
Hi Does anyone have a quick note on now to do this? R Sunny Sunny Matharoo Applications and Database Administrator Tristar Worldwide Chauffeur Services Tel: +44 (0) 1895 432072 Fax: +44 (0) 1895 432098 Mobile: +44 (0) 7793 184144 Email: [EMAIL PROTECTED] www.tristarworldwide.com

RE: [U2] Good Practice?

2007-11-27 Thread Keith Johnson (DSLWN)
Thanks for putting up the right link, Thomas. (dammit, I must measure BEFORE cutting... measure BEFORE cutting... hit self) To answer Ed's questions, 1. nap 5 sleeps for 5 milliseconds. It may not be necessary, so you could comment it out and see how that goes. If you do get comm. delay that

Re: [U2] How to create NFS mount points in UV

2007-11-27 Thread karlp
There is a setting in uvconfig called ALLOWNFS which when set to 1, allows the NFS filesystems setup at Unix to be seen and used. Remember one thing, however: No Locks Are Set On The NFS (remote) System! so if there is a uniVerse environment on the remote system, the rule: Last One Out Wins can

{Blocked Content} RE: [U2] Wintegrate scripts

2007-11-27 Thread Larson, Eydie
on the AngelicHost MailScanner in /home/virtual/site2/fst/var/spool/mail.quarantine/20071127 (message lAS0FRpF007158). -- Postmaster --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Standards [was:OCONV Extraction Question - Good Practice]

2007-11-27 Thread Boydell, Stuart
Colin, excuse my top-posting - I'm using Outlook. Lol. Well it was supposed to be rhetorical and I wasn't expecting a response but since you have; may I cast an opinion that boiling down a definition of good code to being efficient and maintainable and calling it a standard is an

Re: [U2] Good Practice?

2007-11-27 Thread MAJ Programming
Again, the email timing issue. I was responding to the simple index with F200 not bounded. I've used bounding earlier and detected what you were doing. Regarding the extra variable/effort by the SETTING and SET'd variable. I don't care for the argument of counting cycles. Granted, not wasting

Re: [U2] Time Travel

2007-11-27 Thread MAJ Programming
If a donation could be made with Pay-Pal, I've got some extra $. If it makes a difference. Thanks Mark Johnson - Original Message - From: Clifton Oliver [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, November 27, 2007 2:34 AM Subject: Re: [U2] Time Travel For the

Re: [U2] Standards [was:OCONV Extraction Question - Good Practice]

2007-11-27 Thread MAJ Programming
Standards vs Styles. I think Standards are top-down delivered entities in the language from the database providers, ie IBM, Raining Data etc. It's the syntax of commands. Styles are the localized adaptations of the commands, combined for a consistency. They should not extend beyond the horizon