Hi,

I'm trying to dynamically change the file name (or the file path) for a foc file in data migrator. I believe I have to use the "USE" function but I can't get it to run, here's the code that I'm doing:

&DIR = C:\DATA\TEMP.FOC
FILEDEF SASS_VE_STG DISK &DIR

However, when I run it datamigrator, it kept using the original dataset path in the synonym. I got it working for a flat file, but I need this to be a foc file.

Can anyone help please?

Thanks

  
USE
C:\DATA\TEMP.FOC AS SASS_VE_STG 
END

I tried that before too but I got the following message:

(FOC082) INCOMPLETE OR INCORRECT FOCUS FILE NAME IN 'USE' COMMAND: END

Thanks