Extents of the field - Forum - OpenEdge Pro2 - Progress Community

Extents of the field

 Forum

Extents of the field

This question is answered

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

Verified Answer
  • 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
  • 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 .

  • 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