Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
Our customer had Unix System
There are some log files and we need all
Unfortunately, generated unknown file name.
Everybody known as follwing ...How to load all files with ftp
Anybody a suggestion?
// example 1 - list all log related files on disk
EXT = 'log'
sub DoDir (Root)
for each File in filelist (Root&'\*.'&EXT)
LOAD @1, @2, @3 FROM '$(File)'
(txt, codepage is 949, no labels, delimiter is ',', msq);
next File
end sub
call DoDir ('C:\T')
// example 2 - load log with ftp
set filename=2010-02-08_1123.log;
LOAD @1, @2, @3 FROM [ftp://$$$:$$$@11.6.11.2/$(filename)]
(txt, codepage is 949, no labels, delimiter is ',', msq);
I think this way...but It's be unsuccessful
for each File in filelist ('ftp://***:***@211.236.4.1/*.log')
LOAD @1, @2, @3 FROM 'ftp://***:***@211.236.4.1/$(File)'
(txt, codepage is 949, no labels, delimiter is ',', msq);
next File