If he changed "SELECT" to "select", would that get him the results he wants?
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Wally Terhune Sent: Wednesday, July 11, 2012 5:10 PM To: U2 Users List Subject: Re: [U2] Select Statement Invalid Paragraphs run in U mode. Change it to a proc or change the syntax Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: [email protected] **w: rocketsoftware.com/u2 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Al DeWitt Sent: Wednesday, July 11, 2012 5:19 PM To: [email protected] 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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ----- No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1392 / Virus Database: 1520/3887 - Release Date: 09/09/11 Internal Virus Database is out of date. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
