LOG WebFOCUS Errors in to SQL Table.

[VisuaLizeFOCUS .]

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.

[Martin Yergeau]

&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_SERVER

And certainly many others depending on what you want to keep

[VisuaLizeFOCUS .]

But what about Error description any variable available ?

[David Beagan]

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

[VisuaLizeFOCUS .]

The question is will this work on OLD WebFOCUS Version. I'll check and see.

[Martin Yergeau]

It works with v8

At worst, you can code the description extraction using SYSERR table file

TABLE 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

[VisuaLizeFOCUS .]

Thanks will check this one out.