Report (REP) location

[Ken Yong]

Hi,

I am writing a Post Process script in my SQL job. The purpose of this script is to read the Report (REP) and look for certain keywords.

I understand that I can use "PREP_PROCESS_FILE" function to read the file, however, I do not know how to pass in the file and its location as a parameter.

Refer to the below image is what I see from "View Report" after the job completed.

Q: I am looking for the Report (REP) Location and its file name. Will you please help on this? Thank you. :)

------------------------------
Ken
TX, Houston
------------------------------

[Joel Wiesmann]

Hi Ken

Try PREP_PROCESS_REPORT. No need to access files.

Regards
Joel

------------------------------
Swisscom Automation Engineer & PE Membership Creator

Entfessle mehr Automic Wissen mehr Automic Tools
https://membership.philippelmer.com/
------------------------------

[Carsten Schmitz]

​Hi @Joel Wiesmann,

You sure? This has the little caveat that when your report some day becomes too large for MAX_REPORT_SIZE, PREP_PROCESS_REPORT breaks down. At least as far as I can tell.

https://community.broadcom.com/participate/ideation-home/viewidea?IdeationKey=f3b7076e-6beb-450f-b947-7ba6b0e4e7ca​

Regards,
Carsten

[MuckMoses]

Hi Ken

What Joel Wiesmann says.

Alternativley you could create a FILTER object & use the Output Scan Tab.

[Ken Yong]

Thank you ​@Legacy User @Muck​​​Moses! This work for me. :)

------------------------------
Ken
TX, Houston
------------------------------