Extents of the field

Posted by Valeriy Bashkatov on 26-Aug-2016 07:51

Hello,

Pro2v4.6.6

In documentation says:

Extent Fields – Array fields from the Progress source database are created as individual fields in the target database schema.

But how to map extents of the field in the Pro2SQL Administration Utility?

Regards,
Valeriy

Posted by Bryan Petersen on 26-Aug-2016 09:26

Look on the properties tab and find the property called EXTENT_DELIMITER.  The default is ##.  It looks like delimiter was removed on the target side?  When you map the source column it looks for target column names that match the source and then maps everything on the target with the same name, defined delimiters and extent numbers .

All Replies

Posted by Bryan Petersen on 26-Aug-2016 09:26

Look on the properties tab and find the property called EXTENT_DELIMITER.  The default is ##.  It looks like delimiter was removed on the target side?  When you map the source column it looks for target column names that match the source and then maps everything on the target with the same name, defined delimiters and extent numbers .

Posted by Valeriy Bashkatov on 29-Aug-2016 02:19

Hi Bryan,

My mistake was that I generated SQL-schema before loading Pro2 properties.

As a result, Target fields were created without a delimiter.

I re-create the table in the Target and then mapped the field successfully.

Thank you for the clarifications!

Regards,

Valeriy

This thread is closed