Bruce: I think it's UD specifically (even D3 works with a number of the suggestions). UD is very finicky with AQL and drives almost ALL PICK people crazy, and many who work both UD and something else concurrently.
Bill >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of Bruce Ordway >Sent: Wednesday, August 13, 2008 8:26 AM >To: [email protected] >Subject: RE: [U2] RE: TCL literal select > >Hi, > >I ended up using this from Martin C. (of Epicor fame). >I don't know why none of the TCL examples would work for me. >Something to do with Unidata 5.2 and my particular flavor I guess. > >Thanks to you all > >> a Virtual Field type dictionary using the INDEX function... >>i.e. >>001: V >>002: INDEX(F1,'"',1) >>003: >>004: >>005: 6L >>006: S > >-----Original Message----- >From: Anthony Youngman [mailto:[EMAIL PROTECTED] >Sent: Wednesday, August 13, 2008 7:08 AM >To: '[email protected]' >Subject: [U2] RE: TCL literal select > >Ooops ... > >COUNT, not DCOUNT > >Cheers, >Wol > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Anthony >Youngman >Sent: 13 August 2008 12:01 >To: '[email protected]' >Subject: [U2] RE: TCL literal select > >Rather than writing a simple program ... > >SELECT PARTS WITH EVAL "DCOUNT(F1, '"') GT 0" > >Cheers, >Wol > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R. >Sent: 12 August 2008 21:59 >To: '[email protected]' >Subject: [U2] RE: TCL literal select > >I tried using the lower case "SELECT/LIST" to use native UniData syntax, >and that did not work. > >Try writing a simple program to convert the double quotes to something >else (like a tilda) then search the I-desc for that. > >ED BP TILDA >SUBROUTINE TILDA(RTN.VAL, ORIG.VAL) >RTN.VAL = CONVERT(ORIG.VAL, '"', '~') >RETURN > > >ED DICT PARTS F1.TILDA >I >SUBR("TILDA", F1) >... > > >SELECT PARTS WITH F1.TILDA = "[~]" > > > >John Israel >Sr. Programmer/Analyst >Dayton Superior Corporation >721 Richard St. >Dayton, OH 45342 >937-866-0711 x44380 > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway >Sent: Tuesday, August 12, 2008 4:00 PM >To: [email protected] >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 reports and exports. > >I have tried quite a few select statements with no success. > >LIST PARTS WITH F1 = "[/"/]" >LIST PARTS WITH F1 = "/"/" >LIST PARTS WITH F1 = "/'"'/" >LIST PARTS WITH F1 = "['"']" >LIST PARTS WITH F1 = "'"'" >LIST PARTS WITH F1 = "/'"'/" >LIST PARTS WITH F1 = \["]\ >LIST PARTS WITH F1 = "[\"\]" >LIST PARTS WITH F1 = '"' > >Wildcards on my system are brackets, [ leading and ] following > >Any ideas on what would work? >Somebody showed me once, so I know it can be done. >I lost my notes though. > >Thanks, > >Bruce Ordway > > >Viking Engineering & Development Inc. >5750 Main St. N.E. >Fridley, MN 55432 > >Visit us at www.Vikingeng.com > >This message contains confidential information and is intended only for >the individual named. If you are not the named addressee you should not >disseminate, distribute or copy this e-mail. Please notify the sender >immediately by e-mail if you have received this e-mail by mistake and >delete this e-mail from your system. E-mail transmission cannot be >guaranteed to be secure or error-free as information could be >intercepted, corrupted, lost, destroyed, arrive late or incomplete, or >contain viruses. The sender therefore does not accept liability for any >errors or omissions in the contents of this message, which arise as a >result of e-mail transmission. If verification is required please >request a hard-copy version. >------- >u2-users mailing list >[email protected] >To unsubscribe please visit http://listserver.u2ug.org/ >------- >u2-users mailing list >[email protected] >To unsubscribe please visit http://listserver.u2ug.org/ >------- >u2-users mailing list >[email protected] >To unsubscribe please visit http://listserver.u2ug.org/ >------- >u2-users mailing list >[email protected] >To unsubscribe please visit http://listserver.u2ug.org/ > > >Viking Engineering & Development Inc. >5750 Main St. N.E. >Fridley, MN 55432 > >Visit us at www.Vikingeng.com > >This message contains confidential information and is intended only for the >individual named. If you are not the named addressee you should not >disseminate, >distribute or copy this e-mail. Please notify the sender immediately by e-mail >if you have received this e-mail by mistake and delete this e-mail from your >system. E-mail transmission cannot be guaranteed to be secure or error-free as >information could be intercepted, corrupted, lost, destroyed, arrive late or >incomplete, or contain viruses. The sender therefore does not accept liability >for any errors or omissions in the contents of this message, which arise as a >result of e-mail transmission. If verification is required please request a >hard-copy version. >------- >u2-users mailing list >[email protected] >To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
