RE: D3 Automatic Faxing

2004-03-16 Thread Ross Ferris
If you would consider a commercial product, and have a Windows PRO (or better) machine in the environment, you might consider our WordLynx/ FaxLynx combo. Invoices, statements, orders etc produced via WORD templates (easy for client to change, include new graphics etc) and can then be faxed

RE: Help Needed regarding performance improvement of delete query

2004-03-16 Thread Grant.Boice
I personally like this approach... LOOP READNEXT ID ELSE EXIT READV DTE FROM F.MASTER, ID, 5 ELSE CONTINUE IF DTE LE DEL.DATE ELSE CONTINUE DELETE F.MASTER, ID DELETE F.REFERENCE, ID REPEAT That's my $0.02 worth. (If that!) Grant -Original Message- F

RE: Looking for associated multi-value algorithm...

2004-03-16 Thread Susan Lynch
Group: My apologies for top-posting this - but for those who have already read 6 other variations on this code, it would be a pain to page down below the original request, and for those who have not seen the original request, it would be a pain to have to go find it. There are as many good way

Re: Help Needed regarding performance improvement of delete query

2004-03-16 Thread Mark Johnson
I'm honored. Can you convince my clients to allow me to replace their thousands of GOTO'd programs with this structure. If you think my example was error prone, you should see the crap I have to support. mark (uses GOTO's sparingly) johnson - Original Message - From: <[EMAIL PROTECTED]> T

Re: Looking for associated multi-value algorithm...

2004-03-16 Thread Mark Johnson
Perhaps the most glaring problem here is the level of the LOCATE. Since SPECIAL.PARTS is a value and thus possibly multi-valued, the ,STARTPOS indicator suggests to the LOCATE to look at the first subvalue of the value'd. Somehow, especially since STARTPOS isn't previously defined, it become zero a

RE: Looking for associated multi-value algorithm...

2004-03-16 Thread Jeff Fitzgerald
All Righty, then! Just for grins, here's an alternative: SPECIAL.PARTS = SPECIAL.REC<12> POS = 0 SPECIAL.FROM.QTY.TEMP = 0 REMOVE SPECIAL.PART.NBR FROM SPECIAL.PARTS SETTING MORE.PARTS POS += 1 IF SPECIAL.PART.NBR = PART.NBR THEN SPECIAL.FROM.QTY = SPECIAL.REC<14, POS> IF SPECIA

Re: Looking for associated multi-value algorithm...

2004-03-16 Thread FFT2001
It looks like you are using SPECIAL and STARTPOS as paired dummy buffers to walk across the SPECIAL.PARTS, each iteration only searching the "remainder" from where you left off. That's a little counter-intuitive :) Maybe better nomenclature would make that more apparent. Like Startpos and

Re: Help Needed regarding performance improvement of delete query

2004-03-16 Thread FFT2001
Gives Mark the "most improved player" award. Will In a message dated 3/16/2004 5:07:09 PM Eastern Standard Time, [EMAIL PROTECTED] writes: > LOOP WHILE READNEXT ID DO >READV DTE FROM F.MASTER, ID, 5 THEN > IF DTE LE DEL.DATE THEN > DELETE F.MASTER, ID > DELE

RE: Looking for associated multi-value algorithm...

2004-03-16 Thread jasonp
There can, and usually are, multiple instances of the same part number. What makes a "row" unique is part number + from qty. Thanks for pointing out the doubling up of the SPECIAL.FROM.QTY assignment though. -Original Message- From: Jeff Fitzgerald [mailto:[EMAIL PROTECTED] Sent: Tuesd

RE: Looking for associated multi-value algorithm...

2004-03-16 Thread Jeff Fitzgerald
Well, the first thing I notice is that your for/next counter, SPECIALPART, isn't used anywhere... Using LOCATE will search for the PART.NBR in the whole SPECIAL.PARTS field, so the for/next isn't needed. Next, I notice that this assignment: SPECIAL.FROM.QTY=SPECIAL.REC<14,SPECIAL> is duplicated,

RE: Installing universe as uvadm

2004-03-16 Thread John Jenkins
Evgenios Universe 9.5 is *not* qualified on AIX 5 - you should be on 10.0.19 or 10.1.1 It may work - but if you hit issues... I would recommend that you get an upgrade from your supplier to avoid possible problems downstream The matrix is on U2TechConnect at http://www.ibm.com.software/data/u

Looking for associated multi-value algorithm...

2004-03-16 Thread jasonp
I'm looking for an algorithm for searching through a group of associated multi-value fields. The fields are F12 (PartsList), F14 (From Qty) and F16 (Unit Price). I can't depend on these being in any certain order, just that the associated fields will be in identical order. What I want to retu

Re: Help Needed regarding performance improvement of delete query

2004-03-16 Thread Mark Johnson
For those who cannot read GOTO's, here's the code expressed goto-less. LOOP WHILE READNEXT ID DO READV DTE FROM F.MASTER, ID, 5 THEN IF DTE LE DEL.DATE THEN DELETE F.MASTER, ID DELETE F.REFERENCE, ID END END REPEAT there you go (to). - O

Re: D3 Automatic Faxing

2004-03-16 Thread Karl L Pearson
I don't know if it runs on D3 or not. Ask Esker Software (U.S. 800-556-4874). We use this product over 2 faxes. We routinely send between 150 to 300 faxes a day and over 600 at Month-End. I monitor it with a 'roll-my-own' package I wrote and it seems quite okay so far. There are NT-based (NTFS req

Re: Help Needed regarding performance improvement of delete query

2004-03-16 Thread FFT2001
In a message dated 3/15/2004 9:54:01 AM Eastern Standard Time, [EMAIL PROTECTED] writes: > 10 READNEXT ID ELSE STOP >READV DTE FROM F.MASTER, ID, 5 ELSE GOTO 10 >IF DTE GT DEL.DATE THEN GOTO 10 >DELETE F.MASTER, ID >DELETE F.REFERENCE, ID >GOTO 10 I count three goto's So thre

Re: Unable to read LOGS.DIR entry from D_UV_LOGS.

2004-03-16 Thread Ray Wurlod
If you're not using transaction logging (TXMODE=0) you can safely ignore this message. It is the UniVerse transaction logging daemon trying to determine where it should keep its log files. If you ARE using transaction logging (TXMODE=1) make sure that you have configured the logs directory. --

Re: Setting up SQL step 1

2004-03-16 Thread FFT2001
In a message dated 3/14/2004 6:48:42 PM Eastern Standard Time, [EMAIL PROTECTED] writes: > You have to HAVE DBA privilege before you can grant DBA privilege. To grant DBA > privilege to Will.Johnson, you'll need to be logged in as OSP\Administrator (or any > equivalent > mapped in UV.LOGIN).

RE: UNCLASSIFIED RE: D3 Automatic Faxing

2004-03-16 Thread Steven Frost
Yes , it is Hydrafax, now superceded by UnimessagePro from www.wordcraft.com We set up template Word documents, ran it through the fax software to create 'overlay' files. The files from Unidata had embedded lines such as '[[OVERLAY=PURCHASE]]' and '[[PHONE=5550456789]]' to tell the fax softwar

Re: D3 Automatic Faxing

2004-03-16 Thread Robert Porter
We autofax reports from a HP-UX, UV9.5 box. We print PCL output to an file, merge a form with it, convert it to G3 TIF, and use sendfax (part of mgetty+sendfax) to do the sending. mgetty + sendfax - http://www.leo.org/~doering/mgetty/ (GPL licensed) We use hp2pbm to convert (hp2hifax is part of

RE: D3 Automatic Faxing

2004-03-16 Thread George Gallen
since it's runing unix, chances are you can setup hylafax which will do what is needed., works off the same principle as faxaway you send an email (locally) and hylafax goes from there. It's quite configurable. It's not off the shelf. On Redhat, there is an RPM, then a config file has be setup. G

UNCLASSIFIED RE: D3 Automatic Faxing

2004-03-16 Thread HENDERSON MICHAEL MR
Mark, The last time I did this (it was quite a few years ago) we used an old PC running some free (or very cheap) software that acted as a fax gateway. The software may even have been called 'faxgate'. We created a text file in a directory the gateway could see, it found the file, set up the fax

RE: D3 Automatic Faxing

2004-03-16 Thread George Gallen
What about creating a file with the data, and outsourcing it to be done by a blast fax provider? At 100 faxes/day One provider (not as cheap as bulk faxers...but). www.faxaway.com Where you email them in the form of [EMAIL PROTECTED] and the body/document in the email is faxed to the fax#tofaxt

D3 Automatic Faxing

2004-03-16 Thread Mark Johnson
Dear All: One of my clients, D3, unix Terian Whitebox Pick server (?) would like to have his system generate roughly 100 faxes per day for invoices and purchase orders. I would be interested what the off-the-shelf approach would be. He has a US Robotics Modem connected to a serial port and all

Re: CLEANUP problem

2004-03-16 Thread tvankirk
Marco, Also, you say you are on sb+ 5.4 and sbclient 5.3, we were told to always have sb+ equal or below sbclient, not at a higher level. This would not cause your current issue, but could cause you to have unpredictable results in other applications. Just an FYI. Thanks! "Marco Antonio Roj

Re: CLEANUP problem

2004-03-16 Thread tvankirk
Marco, We just had this happen on Monday on Unidata 6.0.8 on AIX 5.1, we were told to run "udtdiag" to colloect data about the state of Unidata and stop and restart Unidata. There is no other way. Here is what Unidata support told us: "This is very difficult to chase down. Usually associated wi

CLEANUP problem

2004-03-16 Thread Marco Antonio Rojas Castro
I have a problem with CLEANUP daemon We are using UNIDATA 5.2.9 (100 users license) on Windows 2000 our aplication is made with SB+ 5.4, and SBCLIENT 5.3 When the server is restarted, aprox. 25 users can log on then, when other users try to log on, this message appear in then screen : The CLEANUP

RE: Terminology

2004-03-16 Thread Pingilley, Ron
Our help desk group has an SLA with the business as a whole which describes the hours of coverage (when they will man the phones), the relative manpower for given times of the day/week, and some "guarantees" about how quickly they will process an issue once it's been entered into their computer. "

RE: Terminology

2004-03-16 Thread Anthony Youngman
Not really. MTBF means "it'll run for 10 minutes without falling over". SLA can mean anything. If I was an office manager, I might well say (indeed, it's pretty much our internal SLA) that our systems will be guaranteed available between 8am and 6pm. So I can have 14 hours downtime a day, and stil

Re: Terminology

2004-03-16 Thread Mark Johnson
So what does "Service Level Agreement Metrics" or "Operational Level Agreement Metrics" mean. Is this the new MTBF, ie Mean Time Between Failures. thanks. - Original Message - From: "Ross Ferris" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Monday, March 15

Unable to read LOGS.DIR entry from D_UV_LOGS.

2004-03-16 Thread Evgenios Charalambus
After installing universe 9.5.1 and run the command: bin/uv -admin -stop I got the following errors: Unable to read LOGS.DIR entry from D_UV_LOGS. Unable to open uvdrlogd Daemon info file. Unable to locate UVDR log directory. I tried again start and stop but the error remains. Do

RE: Suppressing detail in UniObjects command

2004-03-16 Thread Anthony Youngman
But doesn't DEP.SUP have two Ps in it? :-) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Southwell Sent: 16 March 2004 10:40 To: U2 Users Discussion List Subject: RE: Suppressing detail in UniObjects command Thanks go to Tony and Stua

RE: Suppressing detail in UniObjects command

2004-03-16 Thread Nick Southwell
Thanks go to Tony and Stuart who both figured it out. DEP.SUP with one P did the trick, ID.SUPP with the two P's seems to work fine too. Many thanks to everyone who pointed me in the right direction. Until next time Cheers Nick -Original Message- From: Tony Wood [mailto:[EMAIL PROTE

RE: Help Needed regarding performance improvement of delete query

2004-03-16 Thread Anthony Youngman
And replying to Scott's post to say "thanks for the compliment", but I've just had another idea ... How many fields are you using for your select on the master file? ESPECIALLY if it's just the date, trans that across to your secondary file, and index it! If it's more than one field, try and work