Posted: Thu Nov 11, 2021 11:58 pm Post subject: SELECT field scalar only to LIST@ROW
Novice
Joined: 29 Sep 2020 Posts: 21
Using IBM Integration 9.0
Read through the SELECT documentation but unclear if SELECT can grab field scalars into a LIST:
Code:
DECLARE Activities ROW;
SET Activities.[] = SELECT ITEM M.JSON.Data.SpanId
FROM InputRoot.Collection.message[] AS M;
Above Activities has a LIST of ROW fields where each ROW has the Field name "SpanId" and scalar value from the JSON data.
What I would like is just the scalars in the LIST just like when using the LIST constructor with scalars:
Code:
SET Activities.[] = List{'gary', 'hank', 'big jim'}
Using FIELDVALUE before ITEM is a no helper.
Have combed this forum but not seeing anything similar. If a LIST can be constructed with scalar then SELECT ought to be able to mimic the LIST constructor. Or?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum