PJMFINOV0 script: X3 connection properties
PJMFINFRE: Financial overview with specific parameters in SQL queries
Use this entry point to take control on the SQL queries used for extracting the financial overview and assign specific parameters to them.
Context and operating mode
Transaction
There is one transaction in progress.
Log file
There is no open log file.
Call context
This entry point is called from the financial overview to specify additional free parameters on the technical calculation class (TECFINOVE).
For this purpose, free fields have been introduced and linked to the (%x%) query:
- 4 free fields for dates: FREDAT1 (%3%), FREDAT2 (%4%), FREDAT3 (%5%), FREDAT4 (%6%)
- 4 free fields for character strings (50 characters): FRECHA1 (%7%), FRECHA2, (%8%) FRECHA3 (%9%), FRECHA4 (%10%)
- 4 free fields for numbers: FRENUM1 (%11%), FRENUM2 (%13%), FRENUM3 (%12%), FRENUM4 (%13%)
The GESPJQ function has been enhanced to support the definition of specific queries. 3 fields have been added:
To the PJMPJQ1 screen:
- SQLQRYFRE
- SQLQRYFREDES
- SQLQRYFRETEX
They are delivered as "Hidden" by default.
To use them, the SQLQRYFRE field must be set to "Entered".
The other two fields must be set to "Displayed".
The SQLQRYFRE field is used to enter the specific query to be used when a value has been entered in the free fields.
If no free value has been entered in the technical class, the standard query is used (SQLQRY).
If at least one free value has been entered, the query defined for the SQLQRYFRE field is used. If no value is assigned to this query, the SQLQRY query is used.
Reminder: If the PJMLOGFIL parameter is set to "Yes", a log file is generated after the financial overview calculation.
This parameter can be useful as the log file will provide the name of each query that has been run, including the selected query and associated free values.