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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:firstname.lastname@example.org
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: