DSXchange

After corrections, i have 3 outputs files with no extension

First file : Main

2441069
20235922

I have only the second line for "Main" but in column, why?

How to have my two lines of data for "Main" and on-line and not in columns ?

Thank a lot.

Hi Chulett,
I don't understand very well what I have to make.

@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 and Regards,

Hello,

Thank you for your answers. I am not going to follow your recommendations because I don't feel able of making it technically.

I know that it is possible to make it with a routine (and it was on this point that I wanted to know more about it) more a loop on the job.

Thanks to you.

No, I don't know the number and the names of ID_SESSION...

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...

Hello,

I have to create a routine DataStage which allows me to splitter my file in entry to so much file as ID (parameter) in the first file.

Is it possible to make that with a routine?

Thank you.

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'...

It's works !

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

I found this :

for /F "delims=" %A in ('dir /b *.csv') do if %~zA LSS 1024 del "%~dpnxA"

I don't want a batch but one command DOS for the size...

But well it's not serious I will untangle.

Anybody has an alternative?

Why it's only for your message?

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...