[Synapse Analytics][DB2][AS400] - Linked service settings and code page conversion
Dear all,
I have defined a DB2 linked service in Azure Synapse Analytics. Final purpose is to copy data from AS400 system to an Azure data lake storage.
I added some optional connection properties (please see print screens). Test connection is OK but data is not correctly converted, in both preview data and sink parquet file (copied to ADLS).
I am not sure of the additional connection properties and defined values. Unfortunately I did not find an example of DB2 linked service with additional connection properties to ensure settings is correct.
It is a blocking point. I would appreciate any help, thank you!
Christophe