I believe that using a lower case "select" forces the syntax to the native UniData mode, not flipping it to the other mode. Thus using "SELECT" or "select" in native UniData mode is the same, but in "P" mode, "select" will expect native UniData syntax.
As stated earlier, paragraphs ONLY use the native syntax. Just change the syntax to: SELECT WIPMTLRQ WITH @ID LIKE "299486...""302667...""318583...""337991...""374396...""376742...""382767...""385661..." I hope this helps. John -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of BobW Sent: Wednesday, July 11, 2012 11:08 PM To: 'U2 Users List' Subject: Re: [U2] Select Statement Invalid 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 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
