so is this summary correct? Unidata only accepts the '[]' wildcards in ecltype "P". In ecotype "U" you need to use the LIKE/MATCH "…" syntax. However, in ecltype "P", paragraphs always run their commands as ecltype "U". So in ecltype "P", the "[]" wildcards will work when typed at TCL, but not in a paragraph. However, a proc P command will perform its commands using the current ecltype You can make a proc use ecltype "U" by using the PU command instead of the P command. You can also force ecotype "U" by issuing the verb in lower or mixed case--List instead of LIST.
Is the proc PU usage documented anywhere? On Jul 12, 2012, at 9:17 AM, Dave Davis wrote: > Maybe your statement is too long. > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt > Sent: Wednesday, July 11, 2012 7:19 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] Select Statement Invalid > > Unidata 7.1.20, pick flavor > > > > I have this quick paragraph to select records based on partial keys: > > 001: PA > > > 002: SELECT WIPMTLRQ WITH @ID = > "299486]""302667]""318583]""337991]""374396]""376742]""382767]""385661]" > "398932]""415256]""445409]""453821]" > > "454353]""478175]""478845]""502457]" > > > Bottom. > > > However, this is what I get when I run it: No data retrieved from > current (S)SELECT statement. > > Yet if I run SELECT WIPMTLRQ WITH @ID = "299486]" > > > > I get records returned. > > > > What am I missing? > > > > Thanks. > > > > Albert DeWitt, CPIM > > > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ________________________________ > > > Dave Davis > Team Lead, R&D > > P: 614-875-4910 x108 > F: 614-875-4088 > E: dda...@harriscomputer.com > [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] > > [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]<http://www.harriscomputer.com/> > 6110 Enterprise Parkway > Grove City, OH > 43123 > www.harris-schoolsolutions.com<http://www.harris-schoolsolutions.com> > > This message is intended exclusively for the individual or entity to which it > is addressed. This communication may contain information that is proprietary, > privileged or confidential or otherwise legally exempt from disclosure. If > you are not the named addressee, you are not authorized to read, print, > retain, copy or disseminate this message or any part of it. If you have > received this message in error, please notify the sender immediately by > e-mail and delete all copies of the message. > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users