custom jython script to access DLR in batch

samlambert

I have a batch definition with 2 data load rules as the batch's jobs.

My first DLR maps all source to target values

My second DLR ignores all source to target values

The first DLR successfully completes, the second DLR does not. This is fine, I want this behaviour.

I want to check though that the second DLR is failing for the reasons I want it to fail, and not something else.

I have an after batch script I execute. Is there a way I can get this script to access information in just the second DLR? I don't really want to scan the log files for strings, as I think there might be a more efficient way. I have a little script at the moment (below) that gets the batch LOADID and writes it to a text file. I'd like to be able to access the second DLR though with LOADID, as it will be equal to the LOADID of the batch + 2, but I'm not sure how to do this. Any help would be much appreciated!

test_file = open('file_1.txt', 'w+')

data = str(fdmContext["LOADID"])

test_file.write(data)

test_file.close()

user6692921

This should do what you want:

SELECT MAX(LOADID) FROM AIF_BAL_RULE_LOADS

WHERE RULE_ID = (SELECT RULE_ID FROM AIF_BALANCE_RULES WHERE RULE_NAME = 'DLRName')

DhawaShah

Hi,

Can you try with the below approach and also do let know whether it works for you:

Trigger the backend SQL of FDMEE for accessing TLOGPROCESS

For reference attaching the below link for detailed description on columns:

https://docs.oracle.com/cd/E57185_01/AGFDE/tlogprocess_table_reference.htm#AGFDE-report_tables_2

Regards,

Dhawal Shah

samlambert

where would be best to have the script? Should I create like mappings and then attach a script to those mappings?

user6692921

Create a custom script and attach it to the batch as the After Batch script.

DhawaShah

Adding it in the existing Afterbatch script would work as said by @user6692921