@eph, sorry i'm on Datastage Server 8.5 and not PX
@ArndW, thanks for your response, Can u please explain step by step how to use this routine in my requirement.
Thanks for your answer, for example : My entry file : NAME|SURNAME|ID_SESSION|... PAUL|BOB|TEST PIT|BRAD|TEST BILLY|JOHN|TEST2 At final, I want 2 files with the first : PAUL|BOB|TEST PIT|BRAD|TEST And the second : BILLY|JOHN|TEST2 I don't how to do with the Transformer, i think i do make a routine t...
I try with one "Execute Command" : cd MYDIRECTORY ; or && for /F "delims=" %A in ('dir /b *.csv') do if %~zA LSS 250 del "%~dpnxA" It doesn't work. This command /F "delims=" %A in ('dir /b *.csv') do if %~zA LSS 250 del "%~dpnxA" doesn't work...
Hi, My JOB : http://s7.postimg.org/rn501ysij/2013_08_06_095231.png In the first stage "Execute Command", the command is cd MYDIRECTORY , it's works In the second stage, the command is for /F "delims=" %A in ('dir /b *.csv') do if %~zA LSS 250 del "%~dpnxA" but it doesn'...
But on "Execute Command Activity", I have not found a similar command DOS (cd myfiles) to put before for /F "delims=" %A in ('dir /b *.csv') do if %~zA LSS 1024 del "%~dpnxA" in DataStage
Like my csv have "first line is column names", the size of files = 300 o As I did not succes to make it with after-job subroutine, I try to do with a Sequence whit "Execute Command" : IF EXIST \myfolder\ test.csv del /F /Q \myfolder\ test.csv But for the size less than 300o, i do...