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?
May 7, 2012 10:19 AM
June 13, 2013 5:14 PM