Hello Amanda,
Yes, you are correct, you can use the vBatch_id returned by the SUBMIT_LOAD function to query the STATUS from the MTA_INTEG_BATCH, it will give you the correct output as expected, let us know if you face any issues or query further.
Thank you and have a nice day.
Amanda Brine
I am doing ETL for multiple entities. Entity A needs to move from SA to GD before I can begin entity b. Can I use my batch ID that I get returned from the command
vBatch_id := SEMARCHY_REPOSITORY.INTEGRATION_LOAD.SUBMIT_LOAD(vLoad_id, 'Step1_Load_Country', 'PA’);
To query the table SELECT STATUS FROM SEMARCHY_REPOSITORY.MTA_INTEG_BATCH WHERE BATCHID = vBatch_ID;