Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.6K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
SQL statement to get all PROCESS_ID's belonging to a batch's PROCESS_ID

I have an SQL/Jython function in FDMEE that returns the process_id of a batch. The batch has load rules associated with it. I want to execute an SQL statement that get's the PROCESS_ID's of the load rules that are in the batch. I'm executing the script on a server so I can't just say SELECT the PROCESS_ID minus 2 and 1. I'm not sure what tables to query in FDMEE, or what would be the most efficient. Any help would be much appreciated!
Best Answer
-
You need to use a combination of data in the following tables AIF_BATCH_LOAD_AUDIT, AIF_PROCESSES and AIF_BALANCE_RULES
Answers
-
You need to use a combination of data in the following tables AIF_BATCH_LOAD_AUDIT, AIF_PROCESSES and AIF_BALANCE_RULES
-
I think this might do what you want:
SELECT LOADID
FROM AIF_BATCH_LOAD_AUDIT AS ABLA1
WHERE (PARENT_BATCH_LOADID =
(SELECT MAX(BATCH_LOADID) AS Expr1
FROM AIF_BATCH_LOAD_AUDIT AS ABLA2
WHERE (BATCH_ID =
(SELECT BATCH_ID
FROM AIF_BATCHES
WHERE (BATCH_NAME = 'BATCHNAME')))))