DSXchange

I tried to make what you say, but It don't work !

Can you describe me, what i put in the after-job subroutine?
I can't find the DOS command for the size of files...

Thanks.

Thanks chulett !

Ok it's a pity!

Chulett it's possible to send you my dsx?

Ok thanks, it's possible to know if the file is empty although the column name ?

It's not possible to create a job for checking if the file is empty or not?

Hi,

I created a file csv but I would not like to create the latter when it's empty (only column name present), is it possible?

Thanks

I do not understand very well,

So that the Stage Folder works, I have to put all my lines in a single column and a single row.

Do I have to a Stage Variable to transform it (how can it be done?), add Aggregator? To put all this in a Routine?

Thank you for helping me.

I have a problem, how I can make in my StageVariable :

file :
ColumnA;ColumnB;ColumnC
1;2;3
3;4;5
6;7;8

What I want before TheAggregator:
ColumnA
1;2;3;4;5;6;8...

Thanks

To recapitulate my job : I will do this

Oracle(SQL)-->Transformer-->AGGREGATOR-->StageFolder

it's ok?

Thanks Chulett

Ok thanks, it's possible de create *.csv files et not *.txt?

oK, It will be :

Oracle-->Transformer--->Stage Folder ?

Yes, thank you I have already read this doc but I block on the place where it is necessary to insert the Stages Folder.

My job :

Oracle-->Transformer--->Sequentiel File Stage

Where place the Stages Folder?

Thanks

Thank you very much for your answer.

On the other hand, have you an example on Folder Stages? Because my skills in DataStage are more than limited

Thanks

Hello, I shall want to know if it was possible to put in the name of my files of exits, the data of a column, I am understandable : On a job, I extract from Oracle via a request SQL a table. On this table, there is a column Code_Test which possesses several values (ex: Code1, Code2, Code3). I create...