Re: [U2] Time Travel

2007-11-26 Thread Clifton Oliver
For the group's edification, at sending out 60,000+ e-mails on some days (more than that when people had nothing better to do at work than flame each other about coding styles), this was one of the problems I had when I hosted the lists. Larry is also being polite and not mentioning that he

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

2007-11-26 Thread Clifton Oliver
Be sure to make that one parameter "*some.subroutine". The subroutine needs to be UV globally cataloged, even if you are running in a Pick flavor account. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678

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

2007-11-26 Thread Raul_Dominguez
Try this: CREATE TRIGGER filename.trigger BEFORE INSERT OR UPDATE OR DELETE ON filename FOR EACH ROW CALLING "some.subroutine"; Note the semi-colon at the end (;). It is very important. Regards, Raul. "

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

2007-11-26 Thread Hona, David S
Keith SQL requires a ";" (semi-colon) character along with a 'carriage return' character to signify the end of the command input. There is no other way of creating or managing SQL triggers. Triggers require care in their design, so as not to impair your system performance. Forgetting to setting a

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

2007-11-26 Thread Clifton Oliver
Yes. See Chapter 5 of the UV 10.2 SQL Reference. That's the documentation that works. Unfortunately, the triggers documentation in the non-SQL portions of the manuals is incorrect, and had been for some time. [AD] Watch for the next issue of International Spectrum magazine. Brian Leach ha

RE: [U2] Time Travel

2007-11-26 Thread Larry Hiscock
No config changes necessary. Here's the skinny: The list is hosted on a shared server with other client websites. In order to ensure that everyone gets fair access to the SMTP server (and our clients' email delivery doesn't suffer), majordomo is throttled back to only allow a certain number of c

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

2007-11-26 Thread Keith Johnson (DSLWN)
Hi, 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] But when I try that I get an SQL prompt. W

RE: [U2] URGENT: BCI driver configuration / column binding issues

2007-11-26 Thread Hona, David S
HP have a white page on migration... From PA-RISC to Itanium-based architectures http://h21007.www2.hp.com/portal/download/files/unprot/hpux/5981-7108en. pdf It basically says PA-RISC complied applications should work on Itanium-based platforms (but not necessarily always so). -Original Me

Re: [U2] Time Travel

2007-11-26 Thread Charles Barouch
Karl, Maybe you and Larry should talk. Perhaps we need some sort of config correction? - Chuck [EMAIL PROTECTED] wrote: My point? none really, other than to show that Charles' nice numerically explained _time travel_ doesn't match my real-life experience with my own majordomo server...

RE: [U2] Good Practice?

2007-11-26 Thread Keith Johnson (DSLWN)
Craig Bennett pointerd out that TEST = '\AF1\CK1\CK2\H\LHC\MP\NU1\NU2\TK1\TK2\' IF INDEX(TEST,'\':F200.SCHEME.CODE:'\',1) THEN THAT = @FALSE *can* generate a false positive if F200.SCHEME.CODE contains an embedded slash. In this case it can't, because the F200.SCHEME.CODE is validated on ent

RE: [U2] Time Travel

2007-11-26 Thread Bill Haskett
Scott: I'm not sure what you mean. I usually get an email I post in about 10 minutes. Bill >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Scott >Ballinger >Sent: Monday, November 26, 2007 1:24 PM >To: u2-users@listserver.u2ug.org >Subject: Re: [U

RE: [U2] Good Practice?

2007-11-26 Thread Womack, Adrian
Keith said: >> Then, to avoid the long setup string, one has to use CONVERT (or SWAP or CHANGE). You can always hard-code value-marks: TEST = "AF1}CK1}CK2}H}LHC}MP}NU1}NU2}TK1}TK2" Adrian DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipi

Re: [U2] Good Practice?

2007-11-26 Thread Craig Bennett
First, the value of F200.SCHEME.CODE of CK *cannot* trigger a false positive. TEST = '\AF1\CK1\CK2\H\LHC\MP\NU1\NU2\TK1\TK2\' IF INDEX(TEST,'\':F200.SCHEME.CODE:'\',1) THEN THAT = @FALSE If can if F200.SCHEME.CODE contains an embedded slash eg: F200.SCHEME.CODE = "AF1\CK1" --- u2-use

RE: [U2] Good Practice?

2007-11-26 Thread Keith Johnson (DSLWN)
Hi Mark, Just a couple of points. First, the value of F200.SCHEME.CODE of CK *cannot* trigger a false positive. TEST = '\AF1\CK1\CK2\H\LHC\MP\NU1\NU2\TK1\TK2\' IF INDEX(TEST,'\':F200.SCHEME.CODE:'\',1) THEN THAT = @FALSE is fairly bulletproof because of the backslashes around both the strin

RE: [U2] Time Travel

2007-11-26 Thread Don Verhagen
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 thingie too. Donald Verhagen ([EMAIL PROTECTED]) Chief Information Officer - Tandem Voice: 561.226.8261 -Original Message--

RE: [U2] Time Travel

2007-11-26 Thread Don Verhagen
I own the domain. It's not hosted by myself here in the frigid 82F degree winter. Donald Verhagen ([EMAIL PROTECTED]) Chief Information Officer - Tandem Voice: 561.226.8261 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Monday, Nove

RE: [U2] Wintegrate scripts

2007-11-26 Thread Brutzman, Bill
There is at least one (rather large) wIntegrate tech manual at the IBM U2 Family website. Consider printing the manual. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Larson, Eydie Sent: Monday, November 26, 2007 7:10 PM To: u2-users@listserver.u2ug

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

2007-11-26 Thread Boydell, Stuart
"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 >-Original Message- >> Yeah - I remember thinki

Re: [U2] Time Travel

2007-11-26 Thread Mark Ballinger
On Nov 26, 2007 3:29 PM, Ron White <[EMAIL PROTECTED]> wrote: > The header for this message from Ross shows it was received by the > listserver at 14:11:15 Pacific Standard Time (usa) and then received by > my mailserver at 17:03:25 Central Standard Time (usa). So subtract 2 > hours and it took ab

[U2] Wintegrate scripts

2007-11-26 Thread Larson, Eydie
Hello! I am trying to find out if something is possible, and if it is, how to write the script. I want to have an end user press a function key and have that function key run a Wintegrate script that prompts the user for 3 different options. I think this needs to be done using a dialogue box

Re: [U2] Time Travel

2007-11-26 Thread Ron White
The header for this message from Ross shows it was received by the listserver at 14:11:15 Pacific Standard Time (usa) and then received by my mailserver at 17:03:25 Central Standard Time (usa). So subtract 2 hours and it took about 52 minutes. It was virus scanned by AngelicHost and my internal

Re: [U2] Good Practice?

2007-11-26 Thread MAJ Programming
Again, your response is out of sequence as so is mine. I see the back slashes today but replied yesterday. Maybe the forum is a better idea. Mark Johnson - Original Message - From: "Jerry Banker" <[EMAIL PROTECTED]> To: Sent: Monday, November 26, 2007 8:40 AM Subject: RE: [U2] Good Practic

RE: [U2] Time Travel

2007-11-26 Thread Ross Ferris
C'mmon Jerry ... what have you got against Australians and besides, if it WAS located on this side of the Pacific Ditch, based on current performance, you would see DAYS between posts, because it typically takes an hour or two before I see posts too Ross Ferris Stamina Software Visage > Bette

Re: [U2] Time Travel

2007-11-26 Thread Thomas Derwin
I thought it depended on whether you were near the beginning or the end of the recipient list. Under my former e-mail address (imported from Clif's server), the turnaround was about 30 minutes. When the company changed our addresses, turnaround became an hour or so, which I presumed was because t

Re: [U2] Time Travel

2007-11-26 Thread Scott Ballinger
I have always presumed that *everyone* was subject to typically-at-least-one-hour delay. Is there anyone out there that gets emails from this list in near real time ? If so, what are you doing differently from the rest of us? /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 On Nov

Re: [U2] Cool stuff for a Friday [not-secure]

2007-11-26 Thread Clifton Oliver
Who, me? ;-) On Nov 26, 2007, at 5:43 AM, Hennessey, Mark F. wrote: Cliff - I'm willing to bet you do it because you CAN. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Time Travel

2007-11-26 Thread Perry Taylor
I also experience the "hour or so" response time getting emails from this list. I would love to see this situation remedied. Perry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, November 26, 2007 11:56 AM To: u2-users@li

RE: [U2] Time Travel

2007-11-26 Thread Jerry Banker
I thought that the list server was located in Australia but when I looked it up in whois it shows up in Florida and administered by Donald Verhagen!? > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, November 26, 2007 10:56 AM > To: u2-users@listserve

RE: [U2] Time Travel

2007-11-26 Thread karlp
I have to add my two bits. Okay, I don't 'have' to... I use the exact same email group software (majordomo 1.94.5) on my 'home' system with over 7000 subscribers to over 180 different email groups. Our groups never see the delays the members of this group see, so with all due respect, there's some

RE: [U2] UniData and separate email server

2007-11-26 Thread Glen Batchelor
> -Original Message- > From: [EMAIL PROTECTED] [mailto:owner-u2- > [EMAIL PROTECTED] On Behalf Of Ron Sharcott > Sent: Friday, November 23, 2007 1:36 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] UniData and separate email server > > Here's the problem. We are expanding our communi

Re: [U2] U2 Silliness from a vendor

2007-11-26 Thread Wally Terhune
correct. If you don't have Recoverable File System (RFS) enabled, there are no archive/undo/redo logs for UniData. Of course - virtually all UniData data file i/o is essentially random i/o. You should tune your disk subsystem to accomodate this.

RE: [U2] U2 Silliness from a vendor

2007-11-26 Thread bpaige
We have a similar scenario on UV/AIX. Our unix tech was actually a bit more detailed. They're talking about the unix filesystem logs - in our case, JFS/JFS2 logs. If they're isolated to a different logical partition, the system is a little more efficient. I'm not sure if that applies to your sy

RE: [U2] U2 Silliness from a vendor

2007-11-26 Thread Jerry Banker
Unless you are running RFS, no, there are not any. However if you are they should be on a separate mount. Some may think you need them but from my experience the database is so robust it has never been necessary. Of course I've never run the database on MS. Jerry > -Original Message- > Fro

SV: [U2] U2 Silliness from a vendor

2007-11-26 Thread bjorn.eklund
Never heard of any other logs than RFS. (The Sun tech lives in the new millenium.) Bad thing that RFS isn't mandatory when installing Unidata. Bjvrn Eklund -Ursprungligt meddelande- Fren: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Jeffrey Butera Skickat: den 26 november 2007 15:02 Til

[U2] U2 Silliness from a vendor

2007-11-26 Thread Jeffrey Butera
We've been having performance problems as of late which have been tracked down to disk IO. When I was talking with our hardware vendor, he had one of his Sun techs with him where we had the following exchange: Sun tech: Because of the inherent difference of random and sequential you want to en

Re: [U2] Good Practice?

2007-11-26 Thread Jeff Schasny
I agree with the LOCATE and would also make the string of codes to be checked an item in a control file. That way the codes can change without modifying the program. Keith Johnson (DSLWN) wrote: > Neil suggested using LOCATE rather than INDEX in my example. > > [SNIP] > > TEST = > 'AF1':@AM:'CK1

RE: [U2] Cool stuff for a Friday [not-secure]

2007-11-26 Thread Hennessey, Mark F.
Being a Unix dude, I open a local terminal and use command line at times--not that I have to. I just prefer a Road Less Pixeled for some things. All in all, I'm a fan. I'd be hard-pressed to switch back to Windows as a full-time system. Cliff - I'm willing to bet you do it because you CAN

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

2007-11-26 Thread Symeon Breen
Surely getting the manual out to look up an obscure oconv is reasonable, and putting it in their not bad coding, it takes 20 seconds to look it up !! - I presume you guys donbt program in .net or java etc where looking up the help of some object you have never used before happens quite a lot -

RE: [U2] Good Practice?

2007-11-26 Thread Jerry Banker
In the case he used it will not show a false positive because he enclosed the F200.SCHEME.CODE in "\". > -Original Message- > From: MAJ Programming [mailto:[EMAIL PROTECTED] > Sent: Sunday, November 25, 2007 10:03 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Good Practice? >

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

2007-11-26 Thread Colin Jennings
Yeah - I remember thinking on some of those conversion questions that I did not really know what they did - when it comes to strange or complex conversions like that I just get the manual out. It is certainly not something one does every day. Symeon. Exactly the point I was making - if som

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

2007-11-26 Thread Symeon Breen
Yeah - I remember thinking on some of those conversion questions that I did not really know what they did - when it comes to strange or complex conversions like that I just get the manual out. It is certainly not something one does every day. Symeon. -Original Message- From: [EMAIL PR

RE: [U2] Time Travel

2007-11-26 Thread Symeon Breen
Or upgrade to a forum based group - just my standard gripe about email lists ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Moderator Sent: 26 November 2007 06:03 To: u2-users@listserver.u2ug.org Subject: [U2] Time Travel To fix this problem, you'd