|
Since you are using DSNTIAUL, you cannot use the VARCHAR STRIP TRAILING specification that can be set using the UNLOAD utility. However, you should be able to use DSNTIAUL to unload data from a view. To solve your particular problem, create a view of the table that selects all of the columns, except for the VARCHAR(300) column. Instead, use the STRIP function on that column.
For example, if the VARCHAR(300) column is named VCOL, specify it as follows in the SELECT of the view:
STRIP(VCOL,TRAILING)
This will cause trailing blanks to be stripped off. Then, use DSNTIAUL to unload from the view instead of the table, and that should do the trick.
Good luck!
Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our discussion forums.
|
