DSXchange

Thank you with all. I will wish to know the very large disadvantages of the DB2 bulk loader. I carried out a test such as (Update or Insert and commit = 1000) : Sequential File --------> Transformer ----------> Plugin DB2 the performances are the same ones (200 lines second) It does not have no tran...

Hello, I have a problem of performances during the treatments between a flat file and DB2. (approximately 100 lines per seconds). :cry: In my treatments, I read the file (1 300 000 lines), there are one or two lookups, and then I write in the table (update or insert). I am obliged to pass by update ...

hello, you can use the routine "DateTimeStamptoOraOCI" which is in the following tree structure: Routines/sdk/Date RoutineName = 'DateTimeStamptoOraOCI' If Arg1 Then Ans = Arg1[1,4]:"/":Arg1[5,2]:"/":Arg1[7,2]:" 00:00:00" End Else Ans = Arg1 End Bye :wink: Mur...

I finally directed my development differently. 1 - I seek the number max by identifier 2 - The number max is stored in a file 3 - In a job control, I read the file which contains the value max, and thus I make turn the job time as many as the number max stored in the file. It goes very well. Thank y...

After some adjustments in my code which is upstream of what I had given , and the integration as of the your corrections, all functions .

Thank you very much

Muriel

Hello, I must find smallest of the identifiers while passing by different the connections (it is the history of the grandmother, the mother, the girl). But I do not know how much there are levels. The awaited result is: The grandmother has a relation with the mother The mother has a relation with th...

I have several projects to deploy.
A project "Calculation of the risk",
a project "Extraction" and a project "Assessment"

For these 3 projects, we must use VC. For this reason I wondered whether one could use VC V7 with DS6

Thank you for these infos

Muriel

Hello,


It is possible to use Version Control V7 with Datastage V6 ?
I would like to be able to have several projects "Version" according to the environments (Receipt, production), but VC V6 does not allow it.

Thank you

Muriel Auvray

I use translate google to write, then sorry for grammar :wink: However this type of treatment functions under oracle, universe. DB2 cannot treat this kind of operation... Suspect for a relational data base. 8) I think that our customer will make us spliter the jobs into 2 to treat the delete separat...

Thank you with all for your answers. In my case, a line cannot go towards the 2 links. The constraint sends the line towards one or the other. I thought well of making 2 jobs instead of one, but I have a large volume to treat. After having called the Ascential support, they made the following tests:...