Header Ads

  • Recent Posts

    What are all the Various SQCs available ?

    What are all the various SQCs available for use? Some of the times I end up writing my own procedures(absolute waste of time) due to lack of knowledge on various SQCs. Here is the list of some of the SQCs available. 
    1. Askftd.sqc - This asks from/thru date for reporting of heading
    2. Askaod.sqc - Procedure to call is Ask-As-of-Date
    3. CurDtTim.sqc - Gets the Current Date Time from System
    4. DateTime.sqc - Convert date from system format calling InitDate-Time procedure to set format.
    5. DateMath.sqc - Converts Native Date format to YYYY-MM-DD.
    6. Eoj.sqc - determines End of job for an SQR report.
    7. FSHdg01.sqc, FSHdg04.sqc - for Standard Headers for PS Financials.
    8. HRHdg01.sqc, HRHdg04.sqc - for Standard Headers for PS HCM.
    9. Number.sqc     - Provides Number related Functions
    10. Opsys.sqc - Operating system settings.
    11. PrcsApi.Sqc - Used in Process Scheduler SQR Programs, to get Run control parameters 
    12. RDBMS.sqc - Database Settings. These files uses #DEFINE command to set the variables.
    13. ReadXlat.sqc - Read the Translate Table for the desired values (Very Important)
    14. Reset.sqc - Used for Footing Section that prints ‘End-of-Report’.
    15. SetEnv.sqc - Sets Environment for Country, Printer-Paper, Language, Date,  Platform specific parameters, It also contains Opsys.sqc, RDBMS.sqc
    16. Setup01.sqc - This is generally called from Begin-Setup section for Portrait Size 
    17. Setup02.sqc - This is generally called from Begin-Setup section for Landscape Size
    18. STDHDGTR.sqc  - Performs Language Conversion
    19. STDHDG01.sqc - Provides Standard heading for language conversion
    20. StdApi.sqc - Gets Std API calls 
    21. Trancntrl.sqc - Purpose is to COMMIT, ROLLBACK etc. across DB platforms
    22. Convertcurrency.sqc - To convert currencies
    23. AllMaxes.max - It is used for dynamic memory allocations before the execution of SQR.

    No comments

    Please refrain for marketing messages and unnecessary back links.

    Post Top Ad

    Post Bottom Ad