Re: [U2] Relative Path for SET.INDEX in Universe

2013-05-16 Thread Tom Whitmore
Hi Jeff, Are there problems when writing from a different account? Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Fitzgerald Sent: Wednesday, May 15, 2013 11:56 PM To:

[U2] Selecting a special character in a SELECT (UV)

2013-05-16 Thread George Gallen
Ok. I'm trying to find all the ID's in a file that contain the character ^160 I tried : SELECT filename WITH @ID LIKE ...^160... But that didn't work. Aside from writing a program to scan the file, is there a way from TCL? George ___ U2-Users mailing

Re: [U2] Selecting a special character in a SELECT (UV)

2013-05-16 Thread Colin Alfke
With UniData you can use GUIDE to find a character but I'm not sure of an easy way to find it with a select. Maybe by creating the select in basic (so you can put the actual character in the string) and executing it??? Hth Colin -Original Message- From: George Gallen Sent: Thursday, May

Re: [U2] Selecting a special character in a SELECT (UV)

2013-05-16 Thread George Gallen
Actually, that did help. Instead of a basic program, I used the editor to create a VOC of the SELECT, which allowed me to enter the special character. Worked great. Thanks George -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] Selecting a special character in a SELECT (UV)

2013-05-16 Thread David A. Green
Try: ALT-160 Example: SELECT MY.FILE WITH @ID LIKE ...á... (By holding down the alt key and pressing 160 on the numeric keypad. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On

Re: [U2] Selecting a special character in a SELECT (UV)

2013-05-16 Thread George Gallen
That didn't work, my telnet program seems to convert most special characters to ^? I tried that first. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green Sent: Thursday, May 16, 2013 10:28 AM

Re: [U2] Selecting a special character in a SELECT (UV)

2013-05-16 Thread Daniel McGrath
Create an I-type dictionary item to do an INDEX on CHAR(160) and select on that. Dan McGrath Managing Director, U2 Servers Lab Rocket Software 4600 South Ulster Street  ·  Suite 1100  ·   Denver, CO 80237 ·  USA T: +1 720 475 8098 · E: dmcgr...@rocketsoftware.com · W: u2.rocketsoftware.com

Re: [U2] Selecting a special character in a SELECT (UV)

2013-05-16 Thread Charles Stevenson
SELECT filename WITH EVAL INDEX( @ID, CHAR(160), 1) 0 On 5/16/2013 8:41 AM, George Gallen wrote: Ok. I'm trying to find all the ID's in a file that contain the character ^160 I tried : SELECT filename WITH @ID LIKE ...^160... But that didn't work.

Re: [U2] Selecting a special character in a SELECT (UV)

2013-05-16 Thread George Gallen
OK. I was trying to figure out how to stick an EVAL into it, but didn't get the formatting correct. That works as well. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Thursday, May

Re: [U2] Selecting a special character in a SELECT (UV)

2013-05-16 Thread George Gallen
Rather than an I desc, I chose to create a Paragraph...same difference. Except instead Of using INDEX(), I used the like...^160... (and the editor converted the 160 to the right code). -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] Selecting a special character in a SELECT (UV)

2013-05-16 Thread Wjhonson
What telnet program do you use -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, May 16, 2013 8:09 am Subject: Re: [U2] Selecting a special character in a SELECT (UV) OK. I was trying to figure out how to

Re: [U2] Selecting a special character in a SELECT (UV)

2013-05-16 Thread Denise and Mike Daniel
How about... SELECT MY.FILE WITH EVAL INDEX(@ID,CHAR(160),1) 1 Mike. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, May 16, 2013 8:32 AM To: U2 Users List Subject: Re: [U2] Selecting

Re: [U2] Selecting a special character in a SELECT (UV)

2013-05-16 Thread George Gallen
Whatever came with windows 98. Different from the one that came with XP. I'm guessing it's in how it does the VT100 emulation. It doesn't have any ability To tweek the mapping either. For 99.9% of the time, this is absolutely all we need, and it's easy to use for Everyone. Don't really need to

Re: [U2] Selecting a special character in a SELECT (UV)

2013-05-16 Thread McGowan, Ian
If you're still using telnet in 2013, that's a security problem - you must not be in a regulated industry ;-) Putty[1], is a free ssh client (ok, it does telnet too), that seems to be the defacto standard on windows. My ROI is infinite, since I use it constantly and it's free. [1]

Re: [U2] Selecting a special character in a SELECT (UV)

2013-05-16 Thread George Gallen
It's a fairly closed network, and security is a low priority (at least for access software). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of McGowan, Ian Sent: Thursday, May 16, 2013 1:20 PM To: U2 Users List