Problem:
The customer is using a product on mainframe, which allows to explicitely set the VARCHAR length. In MFE, SQL Wizard is the tool to execute UPDATE commands. You can run a query to update a VARCHAR field, and the VARCHAR length will be adjusted. But you can also put zeros into the VARCHAR length field.
Resolution:
An UPDATE query in SQLWizard may achieve this duty. The SET variable must be supplied by a host variable. In the value prompt, an empty string can be entered. Please check the Quotes box, if necessary.
Old KB# 2462
#MFDS
#EnterpriseDeveloper
