You need a state record, a Do Select and a PeopleCode action. Use Do Select to read data from inbound tables, assign values to the state record and then pass the values to CI using the PeopleCode action right after your Do Select action.

Thanks Lepa ...This indeed was what I was looking for...I'm a newbee on the Tech Side (come from a functional background) & was not 100% sure which approach I shd take..thanks again !

Hey Lepa,

Did have one question on this...Obviously we have a run control from where the program would be initiated...so should I plan to have 2 AET records, i.e one for storing the run control parameters & the other for storing the data which needs to be inserted?

Also, like SQR's, can we store the data in variables & use it across multiple actions in an AE?

Thanks for all your help !

You can if you want you but it is not necessary. You can use the same state record for both.

Yes, look up %BIND in Application Engine PeopleBook. You use %BIND when you want to reference a variables stored in the state record and if you are referencing the value in PeopleCode you just use my_state_record.my_field