I need to create an SQL view & do FTP of this view.
CREATE VIEW palib/reshgjw AS SELECT WJWID as WJWID,char(WPEROD) as WPEROD,char(WCMPNY) as WCMPNY from libname/filename.
In my text file, I need a tab b/w each fields. But in the text i got there are no field separators b/w field 1 & field 2.
Is there any solution for this?
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!