[U2] In search of

2011-07-19 Thread Bruce Conway
I have been a member of this group for a long time and have learned a lot. I
am an independent consultant in search of another Pick/Unidata/SB contract.
I have been independent since 1996 and my current long term contract is
about to end. Short term or long term. I have been doing telecommute and
have been trusted and respected. Expert in the Avante manufacturing and
Primac printing software. If anyone knows of such an opportunity please pass
my name on or let me know.

Bruce A. Conway
BAMAC, Ltd
(Business And Manufacturing Analysis Consulting, Ltd)

5137 Oak Brook Drive
Cincinnati, Ohio 45244

Office: 513-248-9551
Cell:   513-417-1029

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
 

__ Information from ESET NOD32 Antivirus, version of virus signature
database 6306 (20110719) __

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com
 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] UV SEARCH Bug?

2008-01-17 Thread Ken Hall

Kevin -
Did you move the file to this system from another one? If so, it may 
have been created with LONGNAMES on or off and your current setting 
for LONGNAMES is the other choice. I had this same problem on another 
system where I restored the account with uvrestore and had to remove 
the .Type1 record from the directory to get things working again, 
ie. a directory without the .Type 1 item is a Type 19 file.  Also, 
if you did a restore, did you run UPDATE.ACCOUNT in the account; it 
fixes lots of problems that occur with moved accounts.


Ken

At 03:41 PM 1/16/2008, you wrote:

I am working on a UV 10.2 system and the BP file is a Type 1.  SEARCH
BP and then entering a string that is known to be in the records
returns erroneous results.  For example:

 SEARCH BP
STRING: KK
STRING: cr

5 record(s) selected to SELECT list #0.

CLEARSELECT
SELECT list number 0 cleared.

SELECT BP

935 record(s) selected to SELECT list #0.
 SEARCH BP
STRING: KK
STRING: cr

48 record(s) selected to SELECT list #0.


Why would the SEARCH with no active list return 5 but the SEARCH with
the active list returned 48 items?  Copying the records to a type 19
file, the SEARCH works fine on the type 19 file.  It only seems to be
with the type 1.  Any clues?

-Kevin
http://www.PrecisOnline.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UV SEARCH Bug?

2008-01-17 Thread Jerry Banker
My guess would be that when a search is performed on a type 1 file,
without a select list, it reads the file names and some may have been
split by the name truncation used with type 1 files. With an active
select list the search routine probably uses the select list which has
the full concatenated name. A type 19 file wouldn't have the same
problem because it does not split the long names.

Jerry Banker
Senior Programmer Analyst
IBM Certified Solutions Expert
Affiliated Acceptance Corp
Sunrise Beach, MO
1-800-233-8483
www.affiliated.org


 -Original Message-
 From: Kevin King [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, January 16, 2008 5:42 PM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] UV SEARCH Bug?
 
 I am working on a UV 10.2 system and the BP file is a Type 1.  SEARCH
 BP and then entering a string that is known to be in the records
 returns erroneous results.  For example:
 
  SEARCH BP
 STRING: KK
 STRING: cr
 
 5 record(s) selected to SELECT list #0.
 
 CLEARSELECT
 SELECT list number 0 cleared.
 
 SELECT BP
 
 935 record(s) selected to SELECT list #0.
  SEARCH BP
 STRING: KK
 STRING: cr
 
 48 record(s) selected to SELECT list #0.
 
 
 Why would the SEARCH with no active list return 5 but the SEARCH with
 the active list returned 48 items?  Copying the records to a type 19
 file, the SEARCH works fine on the type 19 file.  It only seems to be
 with the type 1.  Any clues?
 
 -Kevin
 http://www.PrecisOnline.com
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] UV SEARCH Bug?

2008-01-16 Thread Kevin King
I am working on a UV 10.2 system and the BP file is a Type 1.  SEARCH
BP and then entering a string that is known to be in the records
returns erroneous results.  For example:

 SEARCH BP
STRING: KK
STRING: cr

5 record(s) selected to SELECT list #0.

CLEARSELECT
SELECT list number 0 cleared.

SELECT BP

935 record(s) selected to SELECT list #0.
 SEARCH BP
STRING: KK
STRING: cr

48 record(s) selected to SELECT list #0.


Why would the SEARCH with no active list return 5 but the SEARCH with
the active list returned 48 items?  Copying the records to a type 19
file, the SEARCH works fine on the type 19 file.  It only seems to be
with the type 1.  Any clues?

-Kevin
http://www.PrecisOnline.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UV SEARCH Bug?

2008-01-16 Thread iggchamp
I ran into this some time ago.  I think it was a permissions issue.  Once 
search runs into a record that you don't have permissions to, it just stops and 
returns what it has found up to that point.  Hope that's it.

-- Original message -- 
From: Kevin King [EMAIL PROTECTED] 

 I am working on a UV 10.2 system and the BP file is a Type 1. SEARCH 
 BP and then entering a string that is known to be in the records 
 returns erroneous results. For example: 
 
  SEARCH BP 
 STRING: KK 
 STRING: 
 
 5 record(s) selected to SELECT list #0. 
 
 CLEARSELECT 
 SELECT list number 0 cleared. 
 
 SELECT BP 
 
 935 record(s) selected to SELECT list #0. 
  SEARCH BP 
 STRING: KK 
 STRING: 
 
 48 record(s) selected to SELECT list #0. 
  
 
 Why would the SEARCH with no active list return 5 but the SEARCH with 
 the active list returned 48 items? Copying the records to a type 19 
 file, the SEARCH works fine on the type 19 file. It only seems to be 
 with the type 1. Any clues? 
 
 -Kevin 
 http://www.PrecisOnline.com 
 --- 
 u2-users mailing list 
 u2-users@listserver.u2ug.org 
 To unsubscribe please visit http://listserver.u2ug.org/ 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Archive Search

2007-04-17 Thread Ray Wurlod
Is the archive search at www.indexinfocus.com still out of action?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Archive Search

2007-04-17 Thread brian
Ray

You can use the search at gmane:

http://news.gmane.org/gmane.comp.db.u2.general

Brian

Is the archive search at www.indexinfocus.com still out of action?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Archive Search

2007-04-17 Thread Clifton Oliver
Appears to be. I've been using Nabble 
http://www.nabble.com/U2---Users-f801.html.


-- 

Regards,

Clif




Ray Wurlod wrote:
 Is the archive search at www.indexinfocus.com still out of action?
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [UV] SEARCH command

2007-03-08 Thread Peter Veenhof
Hi all,

Is anyone familiar with the TCL command SEARCH? I can do a 'SEARCH
filename ALL.MATCH' command at TCL and then it prompts for search
criteria. I am wondering if it is possible to make this command case
insensitive as it is only working case sensitive currently. 

Thanks
Peter
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] SEARCH command

2007-03-08 Thread brian
Peter

Search is case sensitive.
The best case-insensitive equivalent (though slower) is to use a SELECT command:

SELECT yourfile WITH EVAL UPCASE(@RECORD) LIKE ...YOUR_PHRASE...

Brian

Hi all,

Is anyone familiar with the TCL command SEARCH? I can do a 'SEARCH
filename ALL.MATCH' command at TCL and then it prompts for search
criteria. I am wondering if it is possible to make this command case
insensitive as it is only working case sensitive currently. 

Thanks
Peter
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] SEARCH command

2007-03-08 Thread Peter Veenhof
Thanks Brian, that'll do the trick for what I'm after. Since I'm calling
from UONET I may be able to do a 'squawk' to a phantom piped output to a
file to pull record IDs as they are found when running this against any
seriously large tables.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, March 08, 2007 10:18 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] SEARCH command

Peter

Search is case sensitive.
The best case-insensitive equivalent (though slower) is to use a SELECT
command:

SELECT yourfile WITH EVAL UPCASE(@RECORD) LIKE ...YOUR_PHRASE...

Brian
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] SEARCH command

2007-03-08 Thread Stevenson, Charles
I've often wanted the same.  Often.
Is there a [BB] (BetterBetter) Enhancement Request buried here? 

 From: Peter Veenhof
 Is anyone familiar with the TCL command SEARCH? I can do a 
 'SEARCH filename ALL.MATCH' command at TCL and then it 
 prompts for search criteria. I am wondering if it is possible 
 to make this command case insensitive as it is only working 
 case sensitive currently. 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] SEARCH command

2007-03-08 Thread karlp
I have a program I wrote that will find just about any string in any file.
I wrote it case sensitive, however, because we have to search that way 99%
of the time. Since it's a program, you can modify it to be case insenstive
and have the speed of the TCL SEARCH command with control. Don't we like
control?

I've pasted it at the end of this email. It's 117 lines long and uses a
few things specific to our system, such as SET.DIMENSIONS which reads the
COLUMNS and LINES from the terminal and sets the UV environment to match, 
plus $include INC.KLP which has a few variables that should be
self-explanatory as @(-N) commands commonly used.

And, I hope it helps. Maybe it should be put on the WIKI?

Karl

quote who=Peter Veenhof
 Thanks Brian, that'll do the trick for what I'm after. Since I'm calling
 from UONET I may be able to do a 'squawk' to a phantom piped output to a
 file to pull record IDs as they are found when running this against any
 seriously large tables.

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of
 [EMAIL PROTECTED]
 Sent: Thursday, March 08, 2007 10:18 AM
 To: u2-users@listserver.u2ug.org
 Subject: RE: [U2] [UV] SEARCH command

 Peter

 Search is case sensitive.
 The best case-insensitive equivalent (though slower) is to use a SELECT
 command:

 SELECT yourfile WITH EVAL UPCASE(@RECORD) LIKE ...YOUR_PHRASE...

 Brian
 ---


BEGIN FINDALL
0001 !(FINDALL) - Search any file for input string
0002 ! Karl Pearson
0003 ! 02/09/2005
0004 $include INC.KLP
0005
0006   VARS = trim(@sentence)
0007   TLRT = dcount(VARS,' ')
0008   FL = field(VARS,' ',TLRT)
0009   SRCH = field(VARS,' ',2,TLRT-2)
0010   execute 'RUN BP SET.DIMENSIONS'  ;! Set terminal Width  Height
0011   open EMP,'AR.CTL' to AR.CTL else stopm 'No AR.CTL File.'
0012   read REC from AR.CTL,FINDALL then
0013  USRNM = REC1
0014  if USRNM = @LOGNAME then
0015 print You are running FINDALL. If you know you aren't,
then type ATS and press ENTER to continue : :
0016 input DOSLK
0017 if upcase(DOSLK) = 'ATS' then go ARNDIT
0018  end
0019  stopm USRNM: is running FINDALL. Try again.
0020   end else
0021  write @LOGNAME on AR.CTL,FINDALL
0022   end
0023 ARNDIT:
0024   Y = 1 ; KEY = EMP ; CNT = 0 ; PCNT = 0
0025   BTM = @crthigh
0026   SPOT = @(0,BTM-4)
0027   SPTT = @(0,BTM-3)
0028   print @(-1)
0029 SRCH: if TLRT = 1 then
0030  print SPOT:'  Enter Search String or E=End : ':CLSLN:
0031  input SRCH
0032  if SRCH = EMP then
0033 print 'Nothing Entered...'
0034 go SRCH
0035  end
0036  if upcase(SRCH) = 'E' or upcase(SRCH) = 'Q' then go OUTT
0037  print SPOT:'  Enter FILE to Search for ':SRCH:' : ':CLSLN:
0038  input FL
0039  if upcase(FL) = 'E' or upcase(FL) = 'Q' then go OUTT
0040  if FL = EMP or FL = 0 then
0041 print 'No File Entered...'
0042 go SRCH
0043  end
0044   end
0045   open EMP,'FNDLST' TO FNDLST else
0046  gosub CLEANIT
0047  stopm 'No FNDLST File'
0048   end
0049   open EMP,FL to SRCHFL else
0050  gosub CLEANIT
0051  stopm 'No ':FL:' File'
0052   end
0053   read LOCKED from FNDLST,'LOCKED' then
0054  print 'Process being run by ':LOCKED1
0055  print 'If you continue, you will clear FNDLST from them'
0056  print 'Continue ENTER=No/Yes : ':
0057  input CONTI ; CONTI = upcase(CONTI)
0058  if CONTI = EMP or CONTI = 'N' then go OUTT
0059   end
0060   execute 'CLEAR.FILE FNDLST' CAPTURING OUTPUTLN
0061   writev @logname on FNDLST,'LOCKED',1
0062   select SRCHFL
0063   if FL[1,2] = 'BP' or FL[1,4] = 'PROG' or FL[1,3] = 'VOC' then
0064  DCT = 0
0065   end else
0066  DCT = 1
0067   end
0068   if DCT then
0069  open 'DICT',FL to DFL else
0070 gosub CLEANIT
0071 stopm 'No DICT ':FL:' File GET HELP!'
0072  end
0073   end
0074   PCNT = 1
0075 ST:   readnext KEY else go OUTT
0076   inputif DOODLY,1: then go OUTT
0077   read REC from SRCHFL,KEY else
0078  print 'UNABLE TO OPEN ':KEY:''
0079  go ST
0080   end
0081   C = 1
0082   print SPOT:'Itm#: ':PCNT:' ':KEY:CLSLN:
0083   print SPTT:'Finding: ':SRCH:' in ':FL:CLSLN:
0084   PCNT += 1
0085 NXT:  inputif DOODLY,1: then go OUTT
0086   findstr SRCH in REC setting POS else go ST
0087 ! if @logname = 'karl' then debug
0088   C += 1
0089   POS = POS'r%2'
0090   if POS then
0091  if Y  (BTM - 6) then Y = 2
0092  CNT += 1
0093  if DCT then
0094 readv DCTLN from DFL,'F':POS,4 else DCTLN = EMP
0095 print @(0,Y):CNTR#4:'  ':KEY:' on Line ':POS:'
(':DCTLN:')':CLSLN:@(0,Y+1):CLSLN:
0096  end else
0097

RE: [U2] [UV] SEARCH command

2007-03-08 Thread Bill Haskett
Peter:

Look here:

http://www.pickwiki.com/cgi-bin/wiki.pl?BFind

I modified the old version, for UniData, to make it case insensitive by
default.  It should just run in the U2 environment.

Hope this helps.

Bill
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Peter Veenhof
Sent: Thursday, March 08, 2007 6:45 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV] SEARCH command

Hi all,

Is anyone familiar with the TCL command SEARCH? I can do a 'SEARCH filename
ALL.MATCH' command at TCL and then it prompts for search criteria. I am
wondering if it is possible to make this command case insensitive as it is
only working case sensitive currently. 

Thanks
Peter
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/