Re: [U2] Select Statement Invalid

2012-07-18 Thread Gail Tyburski
Al DeWitt stylmark.com> writes: > > 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]""45

Re: [U2] Select Statement Invalid

2012-07-12 Thread Wally Terhune
istserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt > Sent: Wednesday, July 11, 2012 7:19 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] Select Statement Invalid > > Unidata 7.1.20, pick flavor > > > > I have this

Re: [U2] Select Statement Invalid

2012-07-12 Thread Ed Clark
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt > Sent: Wednesday, July 11, 2012 7: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 sel

Re: [U2] Select Statement Invalid

2012-07-12 Thread Dave Davis
Maybe your statement is too long. -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 7:19 PM To: u2-users@listserver.u2ug.org Subject: [U2] Select Statement Invalid Unidata

Re: [U2] Select Statement Invalid

2012-07-12 Thread Al DeWitt
Subject: Re: [U2] Select Statement Invalid This works 001: PQ 002: HSELECT WIPMTLRQ WITH @ID = 003: H "240573]" 004: H "292508]" 005: H "235115]" 006: H "203346]" 007: H

Re: [U2] Select Statement Invalid

2012-07-12 Thread Wally Terhune
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: w

Re: [U2] Select Statement Invalid

2012-07-12 Thread Israel, John R.
" I hope this helps. John -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 11:08 PM To: 'U2 Users List' Subject: Re: [U2] Select Statement Invalid If he changed &quo

Re: [U2] Select Statement Invalid

2012-07-11 Thread BobW
ocketsoftware.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

Re: [U2] Select Statement Invalid

2012-07-11 Thread Eric Neu
: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 Uls

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" wrote: > Have you tried putting spaces between the IDs you are selecting. > > David > > > ___ > U2-Users mailing list > U2-Us

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 Wally Terhune
- 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

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 To: U2 Users List Sent: Wed, Jul 11, 2012 4:51 pm Subject: Re: [U2] Select Statement Invalid Not sure, but is it treating "x""y" as &

Re: [U2] Select Statement Invalid

2012-07-11 Thread Robert Houben
. 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

[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]" Botto