Hi,

We are getting FOC198 error due to FOCSORT limitation issue. We are trying to capture that error to show some error message to user to limit their records. But when I add the code
-IF &FOCERRNUM NE 0 THEN GOTO PGM_ERR;

It is not getting passed to the routine. How can I capture the fatal error if FOCERRNUM is not working?

Thanks

This message has been edited. Last edited by: <Kathryn Henning>,

It's strange that &FOCERRNUM is not capturing the last FOCERR being triggered. Did you add -RUN right before testing the variable?

In any case, you can also check the &IORETURN variable which has a value <> 0 when the last IO operation failed.

TABLE FILE ..
...
END
-RUN
-TYPE IORETURN  = &IORETURN
-TYPE FOCERRNUM = &FOCERRNUM

You can then control the error condition when either of those variables has a non-zero value.

It is not getting in to that line at all. It breaks input the FOCSORT once it reaches the 2GB limit.

Are you using SQL Pass Thru or Master File retrieval? Looks like you bring large volume of data to WebFOCUS and perform sort operation.

If SQL Pass thru, then after SQLOUT hold file creation, you should get &IORETURN or &LINES.

If you are having this issue with Master File, then check view source to see if the Aggregation Done in the SQL created by WebFOCUS. Try TABLE FILE hold without any BY fields.

Hope this helps.

Thanks,
Ram