I am currently working with two MySQL environments. In the past, on other types of databases, I used to be able to create a FORMAT ALPHA HOLD file on one environment, copy the ftm and mas to the second environment and then read the file without problem.

With MySQL tables, when I try this, I get format errors when reading the HOLD file in the second environment.

Does this have something to do with code pages being different on the two environments?

Thanks,

This message has been edited. Last edited by: Francis Mariani,

What OS are the two environments, and is the data source unicode ?

They're both Windows 7. The source environment is set to ANSI and it appears that the target MYSQL environment (and WebFOCUS I assume) is set to UTF8. I managed by creating a COMT file, which might be a better format to transfer from one environment to another.

Cheers,

The hold files should be fine.

How do you alloc file file on the other system ?

FILEDEF ....

Do you use LRECL and RECFM ?

Are you using an APP HOLD or an APP HOLDMETA to create your master? Have you tried using the file in a separate fex on the same server on which it was created? Does a previous master exist on either server in a different folder?

I use the master created by the ON TABLE HOLD command and which was saved because of the APP HOLD command. I am not issuing any FILEDEF - the master has the DATASET parameter, which has the file location and RECFM.

I'm intrigued now.

Do you have an example, I'd love to check it out.