How can I provide field editing for DB2 WebQuery?
phone number(length 10, decimals 0)
as (123)456-7890 and
Customer Id# (length 6, decimals 0)
as 1234-56 .
DB2 WebQuery doesn't seem to pay attention to the edit words/edit codes of the PF DDS, so I am trying to do my own "editing".
I want to create an SQL View of the file using Iseries Navigator. During creation of the SQL View, I want to substring parentheses and hyphens into 2 NEW SQL created alphameric Phone Number & Customer Id# fields.
Then I want tell DB2 WebQuery to use the SQL view file instead of the original Physical file.
PS. I am new to SQL and to DB2 WebQuery.