I can't seem to get the create table as function to work with a group by
Way to get STRSQL SELECT to run in batch?
this works just fine
CREATE TABLE TST/TESTJJ AS (SELECT AHAPDL, AHAPNO, AHBSNO, A
HBSDT, AHBQTY FROM CAT/AH WHERE (AHAPDL IN ('106','425','
426')) AND (AHPNO LIKE 'LABOR%') AND (AHXCTYPE = '1')) WITH
this gives me an sqlstt of 42908
CREATE TABLE TST/TESTJJ AS (SELECT ahaPDL, AHAPNO, AHBSNO, aHBSDT, AHBQTY,
cat/ah WHERE (ahapdl in ('106','425','426')) and (ahpno LIKE
'LABOR%') and (ahxctype = '1') GROUP BY ahaPDL, AHAPNO, AHBSNO,
aHBSDT, AHBQTY ORDER BY ahaPDL, AHAPNO, AHBSNO, aHBSDT, AHBQTY ) WITH
This email is intended only for the person or entity
to which it is addressed and may contain information
that is privileged, confidential or otherwise protected
from disclosure. If you are not the named addressee
or an employee or agent responsible for delivering
this message to the named addressee, you are not
authorized to read, print, retain copy, and disseminate
this message or any part of it. If you have received this
message in error please notify us immediately by email,
discard any paper copies and delete all electronic files
of this message.