Hi Everyone,
I would like to Loop through mulitple ID column for sql table via Insert query.
Curious - What will be design of Job for looping Inset SQL
Here is the Insert statement that I want to loop for Columns req_id , driver_id
driver id is 36 ,37, 38.39 always fixed for Paticular action called X .
for Particular action X driver ID is fixed four number.
similarly,
we have Y action for driver_id 33 ,34,35,36 is fixed number
INSERT INTO audit_tbl
req_id,
col2,
col3,
col4,
col5,
col6,
col7,
driver_id,
col8,
col9
)
VALUES
(
1294887,
'2020-10-05 00:00:00',
'',
'2020-10-05 00:00:00',
'2020-10-05 00:00:00',
-1,
'N',
36,
0,
0
);
We tried
I am trying to think in this direction
Job design - Are this design feasible in this situation
tmsinnput >>tflowtoiterate >> tjava >>tforeach / tloop (for min, max driver_id) >>tmssqlrow
or
receive request table select input >> iterate for request id >> process condition if action O >> loop for min max driver ID records >> execute insert query in audit table
