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
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.
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,
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
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-
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
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
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]
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