Well, I agree that a document should be created. But not necessarily for
the users. The users need a decent view.
Let's say you have a table like this:
CREATE TABLE QTEMP/PAULIE (BIGCHARCOL CHAR (50 ) NOT NULL)
Now create a view like this:
create view qtemp/paulieV as (select
cast(substring(bigcharcol,1,3) as char (3)) as slsname,
cast(substring(bigcharcol,4,2) as decimal (2,0)) as mynbr
Now if a spew a row into this table like
insert into qtemp/paulie values('ROB42')
I can do this
select * from qtemp/paulieV
Why should the users have to do all that darn substringing on each and
every query? Have them query the view instead.