DSXchange

To be more precise, I have two sequential with a transformer between them. In the transformer, I call my routine. In the final sequential File, I want to have some rows like this :
Update .....nanana
In the Update statement, names of the fields are essential. It's the reason I need this.

Can you be more precise ?

OK, so you recommand me to use Truncate Facility. this table was installed by myself for the needs of the project. I don't really matter by DBA or others persons.
Can I use Truncate at the end of my job ? I'd seen that i could delete at the end of my job but what about Truncate ?

Hi, I have this routine to construct Insert SQL statement : Ans="INSERT INTO ":NomTab: " VALUES (" NbCol=DCount(Ligne, "|") For i=1 TO NbCol IF i<NbCol THEN Ans := FIELD(Ligne, "|", i):"," ELSE Ans := FIELD(Ligne, "|", i) Next i Ans:="...

At the end of a job, I want to clean a temporary table in oracle. I need to keep this table but a cleaning is necessary. Indeed, If we need to start again the job, data will be add to the table and data of my job of front are too old. Help me please!!!

It works now. I just have two Stage "Sequential File", with a bond between the two. Thanks very much for your answers !!

Chullet has rigth. I had already check the append option but it doesn't work.

About this, i have my first row in differents files which is the name of columns. When I concatene all this files with a unique columns, I don't know how to keep only one time the first row in the final file. I obtain several times the row with column names. My idea is to extract in a file only the ...

I want to concatene 2 Sequential File in one Sequential File. Is it possible ?
When I test it, I have just DATA of one sequential file but not of the two. The structure is always the same (just one columns).

Your idea about create a fixed table with extra-column plait me. I just have one table to manage, it's more simple. I have now a question about this. When my job is finished, I want to delete all the rows of a specific client in this table (something like : Delete from email_temp where client='trala...

When I match a Hashed File and a sequential File, I have this in the log :
0 rows read from Extract_BlackListeTotale. But my Hashed File has 80000 rows. I don't see where is the problem. Could you help me ?

Yes, you understood my problem. I had developped a new idea about it. I make my SQL statement in user-defined query of ODBC. it is : I stock all adress mail in a temporary table called TEMP and it works marvelously !!

Happy DAY!!!

I don't know how to say to Datastage to create a table. I have a parameter that is the name of the client, and I want to create a table in oracle with this name like NomClient_email_temp. if the table exists, I keep the table in oracle. In the same level, I want to delete all data in a table at the ...