VisuaLizeFOCUS . Posted September 21, 2022 Share Posted September 21, 2022 I want to LOG all FOC Errors with description in a SQL table.I know we have &FOCERRNUM variable for ERROR number.Any other Variable that I can use for LOGS. Link to comment Share on other sites More sharing options...
Martin Yergeau Posted September 21, 2022 Share Posted September 21, 2022 &FOCFEXNAME&IBIMR_folder&IBIMR_fullpath&IBIMR_domain&IBIMR_user-* To figure from which server-SET &WF_SERVER = UPPER(TRIM_(BOTH, ' ', FGETENV(30,'COMPUTERNAME', 30,'A30')));&WF_SERVERAnd certainly many others depending on what you want to keep Link to comment Share on other sites More sharing options...
VisuaLizeFOCUS . Posted September 21, 2022 Author Share Posted September 21, 2022 But what about Error description any variable available ? Link to comment Share on other sites More sharing options...
David Beagan Posted September 21, 2022 Share Posted September 21, 2022 You can use the following to get the error message description into a variable: -SET &FOCMSG = IF &FOCERRNUM EQ 0 THEN ' ' ELSE FEXERR(&FOCERRNUM,'A72');The FEXERR function is documented in TIB_wfwf_9.0.0_functions.pdf Link to comment Share on other sites More sharing options...
VisuaLizeFOCUS . Posted September 21, 2022 Author Share Posted September 21, 2022 The question is will this work on OLD WebFOCUS Version. I'll check and see. Link to comment Share on other sites More sharing options...
Martin Yergeau Posted September 21, 2022 Share Posted September 21, 2022 It works with v8At worst, you can code the description extraction using SYSERR table fileTABLE FILE CARPRINT *WHERE BLABLABLA;END-RUN TABLE FILE SYSERR-*PRINT *PRINT FNAME LOWERRNUM HIGHERRNUM ERRNUM ERRTEXT ERRLINE1 ERRLINE2 ERRLINE3 ERRLINE4 ISWARNING ISINFO SHOWLOCWHERE ERRNUM EQ &FOCERRNUM;END-RUN Link to comment Share on other sites More sharing options...
VisuaLizeFOCUS . Posted September 21, 2022 Author Share Posted September 21, 2022 Thanks will check this one out. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now