[U2] Select Statement Invalid

2012-07-11 Thread Al DeWitt
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

Re: [U2] Select Statement Invalid

2012-07-11 Thread Robert Houben
Not sure, but is it treating xy as 'xy'? 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.

Re: [U2] Select Statement Invalid

2012-07-11 Thread Wjhonson
I would try putting this select into a BASIC EXECUTE and see if the same thing happens -Original Message- From: Robert Houben robert.hou...@fwic.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Jul 11, 2012 4:51 pm Subject: Re: [U2] Select Statement Invalid Not sure,

[U2] trimming a list (a test of your ability)

2012-07-11 Thread Wjhonson
1295 FOR DISPLAY.LOOP = 1 TO KEY.COUNT 1296 UTILITY.ID = KEY.LIST1,DISPLAY.LOOP 1297 GOSUB GET.UTILITY.RECORD 1298 IF INDEX(UTILITY.NAME,LAST.NAME,1) = 0 THEN 1299KEY.LIST = DELETE(KEY.LIST,1,DISPLAY.LOOP,0) 1300

Re: [U2] Select Statement Invalid

2012-07-11 Thread Wally Terhune
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-

Re: [U2] Select Statement Invalid

2012-07-11 Thread David Jordan
Have you tried putting spaces between the IDs you are selecting. David ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Select Statement Invalid

2012-07-11 Thread Steve Long
Just curious, have you tried the select statement at TCL? Sent from my iPhone On Jul 11, 2012, at 2:16 PM, David Jordan da...@dacono.com.au wrote: Have you tried putting spaces between the IDs you are selecting. David ___ U2-Users mailing

Re: [U2] Select Statement Invalid

2012-07-11 Thread Eric Neu
This works 001: PQ 002: HSELECT WIPMTLRQ WITH @ID = 003: H 240573] 004: H 292508] 005: H 235115] 006: H 203346] 007: H 219843] 008: H 170808] 009: H 203304]

Re: [U2] trimming a list (a test of your ability)

2012-07-11 Thread Kate Stanton
I am getting sucked in! NLST =;* For new list MAXI = DCOUNT(KEY.LIST1,@vM) ;* Count items FOR INO =1 TO MAXI ;* Each key in list KEY.ID = KEY.LIST1,INO;* A key ID