How to show the used length of a varchar column when browsing data in RC/Update
search cancel

How to show the used length of a varchar column when browsing data in RC/Update

book

Article ID: 226872

calendar_today

Updated On:

Products

RC/Update for DB2 for z/OS

Issue/Introduction

How to show the used length of a varchar column when browsing data within RC/Update for Db2 for z/OS (RCU).
It can be difficult to see how much space of a varchar column has actually been used as opposed to the maximum length of the column.

Resolution

When browsing a table using RC/Update, there is an EXPLODE command which can show the used length of the data in a column.