AW: getting error on create table.

With STRSQL you can only execute on SQL statement at time.
In your example you try to execute multiple (2 CREATE TABLE) statements at
time.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von
Hoteltravelfundotcom
Gesendet: Monday, 04.1 2016 15:43
An: Midrange Systems Technical Discussion
Betreff: Re: getting error on create table.

I removed all the semi colons. But now there is a different error. on the
second create, the cursor sits.

Keyword CREATE not expected. Valid tokens: <END-OF-STATEMENT>.
CREATE TABLE mylib.POSITION1
(
FIRSTPOSITION VARCHAR(10),
FIRSTFLAG INT
)

CREATE TABLE mylib.POSITION2
(

On Mon, Jan 4, 2016 at 9:41 AM, Hoteltravelfundotcom <
hoteltravelfun@xxxxxxxxx> wrote:

strsql.

On Mon, Jan 4, 2016 at 9:36 AM, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:

How are you doing this? If through STRSQL (interactive), don't add
the semicolon. If it's through RUNSQLSTM, you need the semicolon.

On Mon, Jan 4, 2016 at 9:33 AM, Hoteltravelfundotcom <
hoteltravelfun@xxxxxxxxx> wrote:

HI THis is putting the cursor at the last line (there are many more

lines

here on ');' any ideas why ?

Token ; was not valid. Valid tokens: <END-OF-STATEMENT>.
CREATE TABLE Mylib.POSITION1
(
FIRSTPOSITION VARCHAR(10),
FIRSTFLAG INT
);
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please
take a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.