RE: [U2] Arev commands

2005-12-13 Thread David Jordan
Note there was, although I have not checked recently an Arev conversion utility on the UniVerse installation disks. Regards David Jordan Managing Consultant DACONO Holdings Pty Ltd www.dacono.com.au --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://l

RE: [U2] Arev commands

2005-12-13 Thread Keith W. Roberts
How interesting. And sed-like. -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard A. Wilson Sent: Tuesday, December 13, 2005 1:09 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Arev commands > I've never used this syntax but according t

RE: [U2] Arev commands

2005-12-13 Thread Tom Dodds
Jerry, you should be able to use the F1 key for help. I learned the entire Arev system through the F1 key. They have wonderful online, contextual help. They also have a web site at http://www.revtechnologies.com/Default.aspx And a support list available at that address. hth Tom Dodds [EMAIL PR

RE: [U2] Arev commands - Where's the original message?

2005-12-13 Thread Tom Dodds
Yes, it happens often, and I respond the same, by not looking if I already delete it. Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: Tuesday, December 13, 2005 3:36 PM

RE: [U2] records with unprintable characters

2005-12-13 Thread andi_mayer
I have a conversion list from German to UV, which I use in my VB- Programms. Idon't think this list will help you, because the German letter | (an u with double-point on top) is ASCII 252 and the VM-mark is 178 on my German VB system. The easiest way to find such a list is to write a file with

RE: [U2] Calling a subroutine on an MV field from an I-Descriptor

2005-12-13 Thread Bill_H
Thanks Rex. I didn't quite give the entire BASIC program. It is a particular business rule that, in a D3 system, was shared by a variety of BASIC programs and dictionaries. Unlike U2, D3 uses one passed variable in the subroutine argument list where the contents of the dictionary stack is automa

RE: [U2] Secondary Index Problem

2005-12-13 Thread John Jenkins
Building an Index while the file is in use can cause a similar problem. Usually the index is either "disabled" or "Out of step" (missing updates). Resolution: Don't create or build an index while a file could be open. A useful tool (Unix) is: fuser -u <> This command lists the Unix PIDs of all p

RE: [U2] Arev commands - Where's the original message?

2005-12-13 Thread Brenda Price
Ok, did anyone else get the replies but not the original message? I notice I don't always get the original message, usually I think, I've just deleted it and don't remember doing it and I'm too busy to check the deleted folder. However, this time for sure I did not get the original message and

RE: [U2] Arev commands

2005-12-13 Thread Bob Woodward
For the most part, R/Basic commands are very similar to the Universe Basic commands. There are very subtle differences but nothing really major. If you can work in Universe, you'll do just find in AREV. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf

RE: [U2] records with unprintable characters

2005-12-13 Thread Scott Ballinger
Sorry Mats, I should read deeper into the stack before jumping in... Didn't notice that you had already suggested the same "convert bad.chars to null" solution. /Scott --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Arev commands

2005-12-13 Thread Richard A. Wilson
I've never used this syntax but according to the manual if the send expression begins with F then return all characters from the starting position until the 2nd character of the F expression is found example REC = 'ABCDEF,HIJK' A=TRIM(REC[1,'F,']) A would equal ABCDEF (i.e. until the comma)

RE: [U2] records with unprintable characters

2005-12-13 Thread Scott Ballinger
Here is the fastest way I have found to eliminate "bad chars" in "string" bad.chars = "" for n = 1 to 31 bad.chars := char(n) next n for n = 128 to 250 bad.chars := char(n) next n convert bad.chars to "" in string /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -

Re: [U2] Arev commands

2005-12-13 Thread Jerry Banker
Well there was this one command that looked something like this: start = 1 a = trim(rec[start,"F,"]) and I was wondering if it was using some kind of correlative to get the length or if the brackets are used differently in Arev. Also, I would just like to have a command reference for all of th

RE: [U2] records with unprintable characters

2005-12-13 Thread George Gallen
The majority of the "garbage" characters I get are from files from clients in other countries where they have entered an upper ASCII code from an accented letter. In these cases, changing the character to null will make a misspelled name, which is why I have my routine change the character to it's

Re: [U2] Secondary Index Problem

2005-12-13 Thread Gordon J Glorfield
Oh! Oh! I know this one. The 13 records in your index indicate the number of records that had something in attribute 67 when the index was originally built. Because it is an I descriptor and not an actual attribute nothing changed when the record was written with the change to attribute 67 th

RE: [U2] records with unprintable characters

2005-12-13 Thread Rex Gozar
Carl, I would also expected that in addition to cleaning up the data that you have taken steps to prevent garbage from getting into your files in the first place (you do use an input subroutine, right?). A simple test like: IF RESPONSE NE OCONV(RESPONSE, "MCP") THEN ... can test for the pres

[U2] Determine performance of secondary index

2005-12-13 Thread Rod Hills
Hi all, Can the "FILE.USAGE" command be used with secondary indexes? I'm trying to determine how much total disk i/o is reduced when a secondary index is added. I can't find any tools to show activity on the index file like "FILE.USAGE" does for the primary file. I am running UV10.0.16 on HPUX 1

Re: [U2] Arev commands

2005-12-13 Thread Richard A. Wilson
I dont believe there really is one. Also it really depends on which revision level of arev you are running. is there any syntax/statement/function in particular you need Rich Jerry Banker wrote: Anybody know where I could get an on-line copy of the Advanced Revelations R/Basic commands? We d

RE: [U2] Calling a subroutine on an MV field from an I-Descriptor

2005-12-13 Thread Rex Gozar
Bill, If all you are trying to do is return a multi-valued "1" or "0" string for a multi-valued list of id's, you can use this in field 2 of your I-descriptor: 0002: CATS(REUSE(@ID:"*"), @RECORD<35>) ; TRANS("ARTLEDGER", @1, 0, "X") ; NES(@2, REUSE("")) Note that @RECORD<35> can be replaced with

Re: [U2] records with unprintable characters

2005-12-13 Thread gcanedy
One thing to be careful of that we ran into is control characters in the Key (@ID). If your application wrote out a record with say an ESC in the key, and it also wrote that key as a field value in another record in a different file, fixing just the data portion will put your records out of sync.

Re: [U2] Secondary Index Problem

2005-12-13 Thread john reid
I recall occasions where I had to issue the ENABLE.INDEX command in order to kick start the automatic indexing process. Sometimes I had to issue it more than once. I know not what caused the problem or what I was doing wrong. j On 12/13/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi All,

RE: [U2] Secondary Index Problem

2005-12-13 Thread rbl000
I'm guessing you want quotes around the '1' in your I-descriptor expression. Try instead of this: IF @RECORD<67> # '' THEN 1 ELSE '' try this: IF @RECORD<67> # '' THEN '1' ELSE '' Richard Lewis --- On Tue 12/13, [EMAIL PROTECTED] < [EMAIL PROTECTED] > wrote: From: [EMAIL PROTECTED] [mailto:

RE: [U2] records with unprintable characters

2005-12-13 Thread Jeff Fitzgerald
Assuming that the control characters are in the body of the record and not in the key, the following may be helpful. When users attempt to use the arrow keys on their PCs during data entry it can put control chars in unless the app screens the input EQU ASCII.CHARS LIT "'ABCDEFGHIJKLMNOPQRST

Re: [U2] records with unprintable characters

2005-12-13 Thread john reid
To spot the bad guys, build an idesc named GARBAGE, then SELECT FILE WITH GARBAGE NE "" You might need a subvalue count as well. GARBAGE: I COUNT(@RECORD,@FM);COUNT(@RECORD,@VM);COUNT(OCONV(@RECORD,"MCP"),".");COUNT(@RECORD,".");IF @[EMAIL PROTECTED]@4 = @3 THEN "" ELSE @1:"-":@2:"-":@3:"-":@4

RE: [U2] records with unprintable characters

2005-12-13 Thread Anthony Dzikiewicz
Carl, Something like the following is an idea. This might filter a bit more than what you want, but it is simple enough to modify. FUNCTION CLEAN.TEXT(TEXT) TEXT.OUT = '' FOR Y = 1 TO LEN(TEXT) TEST=SEQ(TEXT[Y,1]) IF TEST<32 OR TEST>126 THEN

[U2] Arev commands

2005-12-13 Thread Jerry Banker
Anybody know where I could get an on-line copy of the Advanced Revelations R/Basic commands? We don't have ARev but I was looking at a program and would like to see what some of the command syntax is compared to UV. Jerry Banker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubsc

RE: [U2] OT: Unix Version of PR1MOS EDitor

2005-12-13 Thread Keith W. Roberts
Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony W. Youngman Sent: Saturday, December 10, 2005 2:59 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] OT: Unix Version of PR1MOS EDitor > It's all very well saying vi beats the stuffing out of a line

Re: [U2] records with unprintable characters

2005-12-13 Thread BNeylon
Converting the control characters like that can be dangerous. I run a program to create a list of those with control characters and then use the editor. The control characters are generally part of control strings, "^027W" or "^027K". That sort of thing. Leaving an extraneous "W" or "K" or

[U2] Secondary Index Problem

2005-12-13 Thread iggchamp
Hi All, UV9.6.1.16 HPUX 11 I have an index that is no longer working and am not sure why. The whole purpose of this index is to allow me to use the SELECTINDEX to get a list of items that have something in field 67 of the record. The index has 13 records but there are actually 876 records wi

Re: [U2] records with unprintable characters

2005-12-13 Thread Dave Taylor
Carl, I suggest that you contact Dave Weaver at weaver-consulting.com: 530-676-6052. Purchase a copy of his CLEAN program for a very reasonable price. It works great. Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275)

RE: [U2] Re: OT: Unix Version of PR1MOS EDitor

2005-12-13 Thread Keith W. Roberts
Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David A Barrett Sent: Monday, December 12, 2005 9:18 AM To: u2-users@listserver.u2ug.org Subject: [U2] Re: OT: Unix Version of PR1MOS EDitor > < with either>> > > No, the problem with vi is that it is case sen

Re: [U2] records with unprintable characters

2005-12-13 Thread Mats Carlid
ED in up arrow mode will do it for a few records. If there are quite a few records but only a few possible characters I'd explore the stored commands feature of ED. Else I'd program: listOfChars = char(128):char(129)CHAR(251) loop read record ... convert listOfChars to '' in

RE: [U2] records with unprintable characters

2005-12-13 Thread Baker Hughes
Carl, We faced this recently with data coming from our E-commerce portal, here's a function we put in our Standard.Variables Include, so we can do this from any program: FUNCTION CLEAN.STRING(STRING.IN) RESULT = '' LEN.STR = LEN(STRING.IN) FOR STR.POS = 1 TO LEN.STR

RE: [U2] Calling a subroutine on an MV field from an I-Descriptor

2005-12-13 Thread Bill_H
Bruce & Ray: Thanks. I was frightened of this prospect. Maybe U2 needs a 'SUBRS' function. It's amazing how much illogic creeps into an environment to overcome development issues, and never gets straightened out. But then it could just be me. I'd have never thought I would want to manipulat

RE: [U2] Calling a subroutine on an MV field from an I-Descriptor

2005-12-13 Thread Stevenson, Charles
> From: Stevenson, Charles > Try using OCONVS (with an S) instead of OCONV. After seeing Ray W's response, I think I misread your purpose. What I said was true, but irrelevant. The formatting got screwed up on the email. Be gracious & let me blame it on that. I'll second Ray's answer instead.

RE: [U2] records with unprintable characters

2005-12-13 Thread George Gallen
This works sometimes... 0031:CONVERT CHAR(252) TO "U" IN LIN 0032:CONVERT CHAR(253) TO "Y" IN LIN 0033:CONVERT CHAR(231) TO "C" IN LIN 0034:CONVERT CHAR(229) TO "A" IN LIN 0035:CONVERT CHAR(228) TO "A" IN LIN 0036:CONVERT CHAR(240) TO "O" IN LIN 0037:CONVERT CHAR(221) T

RE: [U2] Calling a subroutine on an MV field from an I-Descriptor

2005-12-13 Thread Stevenson, Charles
Try using OCONVS (with an S) instead of OCONV. The problem has nothing to do with I-descriptors. OCONV treats the 1st argument as a string. OCONVS will process each delimited substring individually. Notice the "FD" (hex value mark) in the middle of the 1st output line below, but the "}", which is

[U2] records with unprintable characters

2005-12-13 Thread Carl Sadlier
Does anyone have a program or suggestions on how to clean up a file that has control characters and unprintable characters that are not Subvalue,Value or Field markers? Thanks, Carl --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] seeking info about Mark Information Systems & their applications

2005-12-13 Thread Bill_H
Scott: I know they were working on moving their application to the web, but don't know if they got it done. I believe they were down to just a few developers and needed to keep expenses down. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf O