Not sure, but is it treating "x""y"  as 'x"y'? I know in some parsers, if you 
want to embed a double quote inside of double quotes you just put two side by 
side.  Most PICK systems don't do that, but within a paragraph the rules may be 
different.  Try putting spaces between the values.

-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt
Sent: July-11-12 4: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
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to