Is it possible you need the library/file specified with a'/' instead of '.'
in the source member? E.g., DCMTLIBD/VRSISRCF
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Gad
Miron
Sent: Monday, August 26, 2024 7:06 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Create table as and RUNSQLSTMS
Hello guys
I need some help sleuthing the following:
the following SQl statement runs fine in RUNSQL or STRSQL
create table DCMTLIBD.VRSISRCF as (
select LNGCDE,WRKNBR, VRSION, ISRC, A.USER AS CHGUSER
from QTEMP.GPLREFF A) with no data
However, when the same statement is included in a source member and trying
RUNSQLSTMT , like RUNSQLSTM SRCFILE(IN0003/QDDSSRC) SRCMBR(VRSISRCF_)
COMMIT(*NONE)
NAMING(*SQL)
it fails with several CPD0044 Positional value cannot follow keyword
parameter.
Could not wrap my head around it.
Any idea will be received thankfully.
Gad
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
midrange.com
