This field will be generated as varchar(max) - Forum - OpenEdge Pro2 - Progress Community

This field will be generated as varchar(max)

 Forum

This field will be generated as varchar(max)

This question is answered

Hello,

Pro2Oracle v.4.6.7
OpenEdge 11.6.3 

When I generate "Target Schema" in the error log (SchemaCreateErrs.txt) appears warning for some fields:

Warning, <db-name>.<table-name>.<field-name>
- has a width greater than the max currently allowed.
- This field will be generated as varchar(max).
- Any associated Indices will therefore not be generated.

What problems can be with this when Pro2 work?
What and how I should do to fix this?

Regards,
Valeriy

Verified Answer
  • Hi,

    There is no problem in it, it is just a warning. If the source field of a source table exceeds maximum width then it will show the above error. If the Width is more than 4000, then it will assign the field width as Varchar(4000).

    The above error has been fixed in 5.0 release. In the Oracle, the maximum width for "VARCHAR" datatype allowed  is "4000".

    Thanks.

All Replies
  • Hi,

    There is no problem in it, it is just a warning. If the source field of a source table exceeds maximum width then it will show the above error. If the Width is more than 4000, then it will assign the field width as Varchar(4000).

    The above error has been fixed in 5.0 release. In the Oracle, the maximum width for "VARCHAR" datatype allowed  is "4000".

    Thanks.

  • Thank you!