I am creating a hold file in one fex. Later on I try to call that hold file within another fex and I get a fildef error. I have done this in 8.0.9 many times, but it seems it is not allowing me to do it THIS WAY in 8.1.5. What am i doing wrong? I have checked and there is a FTM and a MAS file created for the hold file.


This is the code to create the hold file.

APP HOLDMETA COMMON
APP HOLDDATA COMMON

TABLE FILE TBL_ESM_ALL
BY CATALOG_NAME
ON TABLE HOLD AS HOLD_ESM_CATALOG_NAME
END


This is the code I use to retrieve the file

TABLE FILE HOLD_ESM_CATALOG_NAME
BY CATALOG_NAME
ON TABLE PCHOLD FORMAT XML
END


This is the error.

0 ERROR AT OR NEAR LINE 17 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC226) FILEDEF OR ALLOC MISSING FOR EXTERNAL FILE: HOLD_ESM_CATALOG_NAME

This message has been edited. Last edited by: Jay Potter,

Try with the following :

FILEDEF HOLD_ESM_CATALOG_NAME DISK common/hold_esm_catalog_name.ftm

TABLE FILE HOLD_ESM_CATALOG_NAME
BY CATALOG_NAME
ON TABLE PCHOLD FORMAT XML
END

quote:

Originally posted by Jay Potter:
TABLE FILE TBL_ESM_ALL
BY CATALOG_NAME
ON TABLE HOLD AS COMMON/HOLD_ESM_CATALOG_NAME
END


This is the code I use to retrieve the file

TABLE FILE COMMON/HOLD_ESM_CATALOG_NAME
BY CATALOG_NAME
ON TABLE PCHOLD FORMAT XML
END

Do an explicit hold (application/holdname) to the application and you will not have to do a filedef. The dataset attribute will be stored in the master file.

I ended up doing it MartinY's way. It works, but I will try and find out why it works different in 8.1.5. It is probably a setting somewhere in the configuration.

Thank you both for your suggestions.