Hello,

I am debuggin some focexe files and I am having issues narrowing down the issue. The methods I've used are:

(1.)
WHERE RECORDLIMIT EQ 100
WHERE READLIMIT EQ 100
END
-EXIT

--------
(2.)

-TYPE works here &STATUS

---------
(3.)

-SET &ECHO=ALL;

---------

Does anyone have any further suggestions as to debugging code besides the three stated above?

Thanks

This message has been edited. Last edited by: Kerry,

What are the symptoms?

In the first file, I first got a error message saying that &KEY1 is missing:

so, I put a:

I tried here a:
-********************
-SET &KEY=' ';
-*********************

Then I got:

(FOC731) THE DEFINE-BASED JOIN IS IMPROPERLY DEFINED: FILENAME=KEY1

so, I dont think I need the set key, but not surehow to fix the issue here.


-******************************

The next file result output:

0 ERROR AT OR NEAR LINE 145 IN PROCEDURE queryFOCEXEC *
(FOC030) ALL VERB OBJECTS MUST BE IN THE SAME PATH AS THEIR SORT FIELDS


-***********************

The third file just took a long time to get running....I could limit that with a recordlimit

-************************


The last file I got several different error messages in the result output:

0 ERROR AT OR NEAR LINE 358 IN PROCEDURE helpFOCEXEC * (FOC731) THE DEFINE-BASED JOIN IS IMPROPERLY DEFINED: FILENAME= 125
FIELDNAME= BY_KEY
0 ERROR AT OR NEAR LINE 358 IN PROCEDURE helpFOCEXEC *(FOC731) THE DEFINE-BASED JOIN IS IMPROPERLY DEFINED: FILENAME= 125
FIELDNAME= SITE
0 ERROR AT OR NEAR LINE 388 IN PROCEDURE helpFOCEXEC *(FOC003) THE FIELDNAME IS NOT RECOGNIZED: BY_CD
BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT
-*******

(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: HOLD1
BYPASSING TO END OF COMMAND
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: HOLD1
BYPASSING TO END OF COMMAND
-*********

0 ERROR AT OR NEAR LINE 454 IN PROCEDURE helpFOCEXEC *
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: HOLD1
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: HOLD1
BYPASSING TO END OF COMMAND
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: HOLD1
BYPASSING TO END OF COMMAND

Mayor - Did you try

SET XRETRIEVAL=OFF

? This will cause the execution to check for most syntax, DM & flow-logic errors without actually reading the files. It will however not catch errors like 'JOIN file records out of sequence', etc. that are encountered only after reading the actual data files.

Saves a lot of time if the error is towards the end of a long running fex. One would typically insert that line at the top of the pgm, but can be used anywhere you want to check for errors.
Sandeep Mamidenna

Mayor, Step one should be always work on the first error message.

I would also suggest that you put a -RUN after each and every TABLE FILE, with a -SET &ECHO=ALL;. This will help tp pinpoint which block of code the erroris in.

Step two, understand the error message, do some searches on the error number FOCnnnnn.


For you first two errors, seems that you have coded a defined based join and it is wrong. check the syntax. You also seem to be selecting information from a multipath table or join, the fields should be in a single path to stop this.

the second error can be the result of the first error. A hold file is not created and therefor a field or join does not exist.

quote:

Step one should be always work on the first error message

Agreed, as I posted, First Error First, the most important rule.

Waz is spot on - only deal with the first error and then once that is cleared you will have better understanding of actual errors in the code and not cascaded errors.

The normal reason for the "Error in Define based Join" is missing out the WITH real_field syntax.

T

quote:

In the first file, I first got a error message saying that &KEY1 is missing:

so, I put a:

I tried here a:
-********************
-SET &KEY=' ';

error points to &KEY1, you -SET &KEY without the '1'.
I would try SET XRETRIEVAL=OFF
as suggested by Blue Zone.
I'd try a -EXIT after the first table request with a recordlimit of 1. Does it work? Make it a 100. Does it still work? Take off the recordlimit and does it still work? Ok then you now need to move to your -exit down to the next logical breakpoint etc...

Post your code, a define-based join doesn't have anything to do with an & variable.