I tried to create a table using a CTE in SQLRPGLE program. Is this allowed?
I received error:
Token FGDISPO was not valid. Valid tokens: , FROM INTO.
The statement pulled from a debug session starts as:
create table QTemp/BOM as ( with FGDispo as ( select nCdSto,
nRecTy, nCdKe1, nCdKe2, nCdKe3, nCdKe4, nCdKe5, nCdQua, nCd...
I have verified the statement works outside of RPG using StrSQL and System i Navigator.
Currently at V5R4.
This topic has been locked.
1 reply Latest Post - 2010-11-23T22:01:54Z by PWConner
Pinned topic Create Table with a CTE in a SQLRPGLE program
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2010-11-23T22:01:54Z at 2010-11-23T22:01:54Z by PWConner