RE: [U2] TCL literal select

2008-08-14 Thread David A. Green
Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a in the description field (F1). People have been using instead of INCH. This causes problems for me during processing some

RE: [U2] TCL literal select

2008-08-14 Thread Kebbon Irwin
Subject: RE: [U2] TCL literal select Date: Thu, 14 Aug 2008 05:55:46 -0700 Try: LIST PARTS F1 WITH EVAL COUNT(F1, CHAR(034)) NE 0 Thanks, David A. Green www.dagconsulting.com (480) 813-1725 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent

RE: [U2] TCL literal select

2008-08-14 Thread Israel, John R.
PROTECTED] On Behalf Of Kebbon Irwin Sent: Thursday, August 14, 2008 10:48 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] TCL literal select I think Bruce must in ECLTYPE P if he is using the [] wild cards, so he will have to convert to ECLTYPE U to use the EVAL keyword (i.e. lIST or list

RE: [U2] TCL literal select

2008-08-14 Thread Bill Haskett
@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a in the description field (F1). People have been using instead of INCH. This causes problems for me during

RE: [U2] TCL literal select

2008-08-13 Thread Nick Gettino
22-25, 2008 | Mainsail Suites Hotel Conference Center | Tampa, Florida -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton Sent: Tuesday, August 12, 2008 9:56 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] TCL literal select Bruce Ordway

RE: [U2] TCL literal select

2008-08-13 Thread Bill Haskett
- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Allen Egerton Sent: Tuesday, August 12, 2008 6:56 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] TCL literal select Bruce Ordway wrote: Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting

RE: [U2] TCL literal select

2008-08-13 Thread Cordes, Tom (contractor)
: Bill Haskett [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2008 12:48 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] TCL literal select Allen: I use UD in PICK mode and the query processor has the same problem as the OP noted. UD doesn't like single quotes in PICK mode. In fact

Re: [U2] TCL literal select

2008-08-13 Thread Allen Egerton
Bill Haskett wrote: Allen: I use UD in PICK mode and the query processor has the same problem as the OP noted. UD doesn't like single quotes in PICK mode. In fact, numerous things don't work in AQL when in PICK mode. I wasn't able to get any of the suggestions to work in UD. Bill I just

[U2] TCL literal select

2008-08-12 Thread Bruce Ordway
Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a in the description field (F1). People have been using instead of INCH. This causes problems for me during processing some reports and exports. I

RE: [U2] TCL literal select

2008-08-12 Thread Symeon Breen
LIST PARTS WITH F1 = /[]/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: 12 August 2008 21:00 To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble

RE: [U2] TCL literal select

2008-08-12 Thread Brutzman, Bill
Consider trying... LIST PARTS WITH F1 LIKE '..' --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bruce Ordway Sent: Tuesday, August 12, 2008 4:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata

Re: [U2] TCL literal select

2008-08-12 Thread Louie Bergsagel
or LIST PARTS WITH F1 LIKE \..\ I find dots easier to type then left and right brackets. -- Louie in Seattle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] TCL literal select

2008-08-12 Thread Allen Egerton
Bruce Ordway wrote: Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a in the description field (F1). People have been using instead of INCH. This causes problems for me during processing some