Lower case select forces U mode when ECLTYPE is set to P.
In PROC you can also force U mode parsing with PU instead of P

But what the customer needs is P mode, not U mode parsing.

Wally Terhune
Technical Support Engineer
Rocket Software
4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA
t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2




-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of BobW
Sent: Wednesday, July 11, 2012 9: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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] 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: wterh...@rocketsoftware.com **w:
rocketsoftware.com/u2




-----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 5: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
-----
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
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