No more LCT's points at either configuration or possibly a process that is
attempting to take over the world.
Because of what you say re the Java, is there a possibility that more memory
is being consumed?
If you can see no major reasons for why the application should be using more
resources,
One of my clients has roughly 75,000 records in their customer database. Oddly
enough, until now there has not been that great of a need for a lookup
function. Now they would like a lookup function that may go beyond the usual
elements of regular lookups.
First, there is a lot of mis-spelling or
Sounds to me like a need to have strict standards for naming convetions
implemented within the user community, as well as programatically verified
at data entry point, or search point, and the bad data
consolidated/purged.
All kinds of alternate index points come up: Zip Code, Phone Number, City,
We are doing a conversion from PI/Open v3.5.r3 on a Prime EXL (mips) to
universe 10.1.4 on AIX 5.3, All the occurrences of the TRANS function return
the wrong answer, and appear to be lowered. Simple testing indicates that
using the RAISE function in front of the TRANS expression returns the
I've just installed a copy of UV 10.1 on a virtual Win2K3 server. That's
working fine.
I've also installed a copy of the matching UVAdmin program on my pc. That seems
to be working fine, in as much as when I try to talk to our UV 9.5 box, it
rejects my login with you must be an administrator.
Of course one way to do this is to extract the names to a flat file and then
get a service involved to 'scrub' the names and send back a cleaned up
database. When I worked at Knapp Shoes I believe they used to do this for
mail order mailing lists.
Anthony
-Original Message-
From:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of George Gallen
Sent: Wednesday, January 19, 2005 9:36 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Customer Name Lookup
First by eliminating all spaces, special characters, and UPCASEing
a lot of the
Sorry, no I mean that I'm prompting from the 3rd party client.
(i.e. in MSAccess, the selection criteria is [Please enter the fiscal
year] ...or something to that effect... which would bring up the dialog
box for the person running the query.
In that example, if I enter 2004 in the dialog box,
First, there is a lot of mis-spelling or alternate spelling of
similar names.
For example, K-mart is spelled K-Mart, K Mart and KMART. This is not a
situation of simple word lookups. There needs to be some
intuition as well.
Sometimes there's THE INDUSTRIAL DISTRIBUTION COMPANY (example)
Been there, done that. Here are a few potential suggestions:
1. Keep a library of throwaway words, and omit them from any cross
reference. Perhaps Industrial should not be one of them.
2. Use soundex on each non-throwaway word, and index them.
3. Index each non-throwaway word, as entered.
4.
Mark, One way is to create a file that uses the incorrect spelling of the
name as the record id and have the first line of the record contain the
correct spelling of the company name. When the user enters the company
name check against a file/table to see if this is the correct spelling. If
I know there are companies out there that offer data scrubbing
service...
You give them your customer master, they scrub it and give it back.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Scott
Richardson
Sent: Wednesday, January 19, 2005 9:37 AM
To:
Andrea,
This is a known conversion issue.
I don't think there is a workaround other than to write your own TRANS
function replacement. (If you do, be sure to mimic some of the
efficient caching of already-read records that TRANS does.) If IBM
wanted to, a new UVCONFIG option could be a way
Don't know if this will help, but we have a customer who had issues with the
RPC service when they initially went to W2K3 and UV 10.1. It was causing
RPC failed errors when trying to access UniAdmin.
Apparently if W2K3 is running RRAS it can invoke the firewall on its own and
shut down the RPC
There are even individual consultants who will gladly provide
such a service, and several others, on short term, or long term
basis, for a fair and reasonable rate.
Contact me via email.
;^)
- Original Message -
From: Marc Harbeson [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
That will work as long as the fields are multi-valued. Charles noted that
in his response and through further testing, I believe that is accurate. I
am investigating whether this application uses TRANS in any single-valued
expressions.
-Original Message-
From: Mats Carlid
To:
From: Mats Carlid
What's wrong with
FUNCTION ATRANS( F,K,P,X )
RETURN (RAISE(TRANS(F,K,P,X))
END
?
--
looks good, except how about something like:
FUNCTION ATRANS( F,K,P,X )
REMOVE DUM FROM K SETTING MORE ; check for any delimiters
K = K ; * reset rmv ptr in case
Do you need the K = K ?
--
looks good, except how about something like:
FUNCTION ATRANS( F,K,P,X )
REMOVE DUM FROM K SETTING MORE ; check for any delimiters
K = K ; * reset rmv ptr in case calling pgm cares.
T = TRANS(F,K,P,X)
RETURN (IF MORE THEN T ELSE RAISE(T) )
Perhaps farfetched, but could someone have been trying to rebuild an
index? This happened to us earlier this week. We got up to over 200 udcs
sessions; I couldn't kill them and stopping unirpc didn't help. As soon
as we realized what was going on, the user terminated her BUILD.INDEX
and everything
I frequently see this type of line K = K in the code I work on and never
understood why.
Anyone care to share why this is ever needed? I only part way followed the
comment in this program sample.
Thanks,
Marilyn A. Hilb
Value Part, Inc
Direct: 847-918-6099
Fax: 847-367-1892
[EMAIL
SSELECT the file
SAVE-LIST MYLIST
EDIT-LIST MYLIST
You will probably see the offending item at the top or bottom of the list.
To see what is actually in the key try using 'up-arrow' mode in the line
editor; Type '^' an redisplay the record.
To remove delete from the list all the records you
I don't know of any configuration setting for this. This is actually a
'feature' of the TRANS function in UV. You could pass in a multi-valued
list of keys to translate and get a multi-value list of the entire record
back, hence the need to lower the record.
Rich Taylor | Senior
YES! You do need the K=K.
Well, either that or
SETREM 0 ON K
That's better. More explicit.
OK, I admit it: I do K=K cuz of 10 yr old PI habits that won't die. PI
didn't have SETREM.
It is important to reset the remove pointer just in case some future
calling program, over which the
When using REMOVE to extract the values in a multi-valued variable in a
sequential manner, an internal pointer is used to tell the system what
value was last REMOVEd. Using K=K resets the pointer to the first value
in the variable.
HTH,
Gordon
Gordon J. Glorfield
Sr. Applications Developer
Date: Wed, 19 Jan 2005 13:29:15 -0600
Marilyn Hilb [EMAIL PROTECTED] wrote:
I frequently see this type of line K = K in the code
I work on and never understood why.
-Original Message-
From: Andrea Charles [mailto:[EMAIL PROTECTED]
Do you need the K = K ?
--
-Original Message-
From:MACK ANDREW, F/S
Sent:Thursday, 20 January 2005 10:41
To: HENDERSON MIKE, MR
Subject: What uses Printer Memory Segments?
HI all,
We are running UV 10.0.15 on Win 2003. Currently we have an increasing
number of calls to our DB from external Web
Ideally you would use one of:
1. RedBack
2. SOAP/XML
3. UniObjects with connection pooling (e.g. .NET)
Each of these has their benefits depending on the weighting of your client
workload.
Loading programs into the shared memory segment (SHM.TO.LOAD) has a benefit
for frequently invoked programs
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.302 / Virus Database: 265.7.1 - Release Date: 19/01/05
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.302 / Virus Database: 265.7.1 - Release Date: 19/01/05
---
u2-users mailing
I have in Universe a field for the Period as
99-01,00-02,02-01,03-05,04-04. Using ODBC/Access, I want to convert
the period to ,mm,dd format. What would be the syntax for such conversion?
Thanks
Krish
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
Is connection pooling a feature of UniObjects.net
TIA,
Stewart
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of John Jenkins
Sent: Thursday, 20 January 2005 9:31
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Unclassified Performance, Shared Memory
Mark, you may want to look for a subroutine that uses the principles that were
used by mailing houses to correct such problems, the USPS had some guide lines
for doing this. It has been done for years and in the past it was all batched
processed.
D Raven
cell (949)2282224
e Fax (815)4259364
INDUSTRIAL and DISTRIBUTION were examples. I can't remember but there were a
few that disappeared when I used a standard KEYWORD exclusion list.
Basically I'm looking for any help in the mis-spellings. MV traditionally
doesn't have a spell checker and it probably wouldn't help with all the
proper
Now that I think about this, K is the array being traversed? We simply
remove the next attribute/value/subvalue in array K and assigning this
value to DUM. For example:
K = I^AM^HAPPY]TO]READ^THIS^LIST
REMOVE DUM FROM K SETTING MORE
would result in:
DUM = I
K= the above array
MORE = 2
When the only thing consistent is inconsistency, use everything you
have - iteratively - to get the answer. The specification from the
USPS, while not the most entertaining read, is a great first place to
start. This should help with application of standard abbreviations
for common words. As to
Consider getting a zip code file so you can prompt for zip code before
city/state and then having the user choose from the available town names
and defaulting to state. Bound to prevent a bunch of misspellings.
Mark Johnson wrote:
INDUSTRIAL and DISTRIBUTION were examples. I can't remember but
Mark Johnson wrote:
I may use the purge method to scrub the data and assign
some consistency. That's fine as a manual job for me, but
on-going I think it's going to get out of hand as time
goes on. Plus their user base is from another land so
that enters in some mis-spellings.
Kevin King
Note that you also want to raise when the
position is -1 ( retreiving the entire record lowered ).
And when we're at it we can remove the restriction
that TRANS only handles positions not attribute names:
FUNCTION ATRANS( F,K,P,X )
L = ( IF NOT(NUM(P) THEN L = TRANS(DICT :F,P,2,X) ELSE P)
K =
37 matches
Mail list logo