Allow Dataserver Tool To Generate Sql Statement To Change Field Width.

  • Thread starter Thread starter qadzzh
  • Start date Start date
Status
Not open for further replies.
Q

qadzzh

Guest
I would like to just change the WIDTH for a field. I ran "Generate Delta.sql OpenEdge to ORACLE...". It does not generate SQL command to alter field width. To duplicate it, add the following lines to a Progress delta.df file (Note: repace {field-name} and {table-name} with real field and table name). UPDATE FIELD {field-name} OF {table-name} MAX-WIDTH 50 Use "Generate Delta.sql OpenEdge to ORACLE..." to generate Delta.sql file. You will not see any sql command to alter field width.

Continue reading...
 
Status
Not open for further replies.
Back
Top