DSXchange

Hi everybody


I have a job which read the Balance_CG.csv file for write in a Oracle table.
After reading this file, I must copy the data in a new file named Balance_CG_yyyymmdd.csv and empty the first file.


How can I do that ?

Thank you everybody for you help.

Frederic from Paris (France)

Hi everybody We cannot use 2 different RowProcPreviousValue inb the same. The only solution is to make that with 2 jobs. So I found a solution. The first job update the ID_DATE_FIN_VALIDITE by the previous ID_DATE_DEBUT_VALIDITE The second job update ID_DATE_FIN_VALIDITE = -1 if the previous ID_GROU...

Like I explain, I must put the previous value ID_DATE_DEBUT_VALIDITE - 1 day for the same ID_GROUPE_LOT in ID_DATE_FIN_VALIDITE for give that : id_groupe_lot........id_date_debut_validite........id_date_debut_validite ---------------........--------------------------........-------------------------...

Hi everybody I have in a table differents field and ID_GROUPE_LOT, ID_DATE_DEBUT_VALIDITE (Julien format). ID_DATE_FIN_VALIDITE (Julien format) = -1 I want to update ID_DATE_FIN_VALIDITE (Julien format) with the previous value of ID_DATE_DEBUT_VALIDITE - 1 day if it's the same ID_GROUPE_LOT. The big...

Hi everybody I use a master which run all job with a ini file. For the run first job, I must verify that the last loading has finish with a status OK (I don't have line with 'IN PROGRESS' but 'FINISHED') in the table named 'REPORT' When I run the first job of the project, I read the nexval number se...

I try this solution before your answer and it's a good way.

But I don't understand. Sometimes all is right and sometimes I have this problem.

Thanks everybody for your help.


Frederic from Paris

Stage ORACLE 8

Hello all I have a big problem When I create a new stream with a "User-defined SQL query" like this : select SEQ_NUM_LIGNE.nextval from dual I have this error with the VIEW DATA P121axeBGSOCIETESalimODSPROPRIETAIRE..ODS_SOURCE: Table Name is a required link property for Link DSLink1 P121ax...