DSXchange

Changing the array size and record count to 1 is also working...

Apparently, there is something wrong with the values stored in memory or something... and when the DB is making commits for each line, then, there is no problem anymore...

A bit strange...

The good news is that I succeeded in reproducing the problem ! When the ODBC stage is doing ONLY inserts, everything is working properly ! But if there is one update only, then, all the inserts are wrong (for the dates)! I think there is a bug somewhere... As a workaround, I think I will split the u...

Is it possible that the INSERT statement and the UPDATE statement make these differences ? Apparently, when the insert is made, the date is wrong and when the record is updated, it's correct ! :shock: The target is on ODBC. Can the ODBC driver cause this problem ? The SQL is generated and not user-d...

The source field is an Oracle DATE field. I've tried to convert it to a varchar field, using the following syntax : TO_CHAR(TRANSACTION_DATE,'YYYY-MM-DD HH24:MI:SS'). I've populated the data into a flat file and I got the good values (the same as in the source) but it's still wrong in the SQL Server...

Hello ! I'm asking a question to Datastage gurus because I'm totally lost here. I've got a simple parallel job with an Oracle connector as a source, then a simple transformer and an ODBC stage as the target. The target is actually an SQL Server Database. I get wrong results in the date fields in the...

Hi everybody ! I wanted to know if there is a way to make an update of a field only if a certain condition is OK. I have a lot of fields and I want to update all of them in all cases but one only if a condition is satisfied for a piece of data. In the transform, I would like to make this test : If l...

I don't exactly know how to achieve that ! :oops: Must I Telnet the DS server or can I manage to test it in the Datastage Administrator ? But this request should be well-build because sometimes it's working well... I think there is no syntax-error... I can 'view data' without any error when I look a...

Ok, I will remove extra quotes around the table name (but it shouldn't resolve the problem since some of the treatments are going well...) I've already read Ray's answer on that page but I don't see why this answer is related to my problem... :oops: I don't have a 'GROUP' field in my table... If Ray...

Hi, I have a problem in a job using Universe stages... In my job log I get the following error (some of the executions are ending well and some are throwing this error): TraverseesR2kSeafret..Transformer.FS_FERRYY000: DSD.BCIGetByKey call to SQLFreeStmt failed. SQL statement:SELECT DS.FE.FERRYY000.@...

I made a mistake ! I did not check the box (Log warnings after activities that finish with status other than OK). That's why i was not getting the warning message... Now I get the warning message even with only two stages ! The two stages are the following : Routine activity with two triggers : Fail...

I have tried to do this with only two stages, my routine activity and a sequencer and it is not getting the warning anymore...

I am going to recreate the sequence in order to see if the problem disappears...

It is still getting a warning in the sequence log : seq_TEST..JobControl (@R_pwd): Routine DSU.ReadParam did not finish OK, return code = 'myPassword' The code generated in the sequence is the following : ************************************************** L$V5S1$START: *** Activity "R_pwd"...

Hi Craig !

Thank you for interesting to my problem...
I have made some more tests but I still get the warning !

I think I have tried all the combination but no one is working...

Are you sure that the trigger can handle the error and avoid the warning ?

Thanks Ray for answering... but I still can't manage to make it work... :? I have a routine Activity that is calling a routine and the return code of the routine is not 0, it is a string (I use it as DB connection parameter). I have created 2 triggers (that go to the same sequencer) : One is custom ...

Hi everybody ! I have the same problem as explicited and i have not very well understood what ray said... :oops: How can i Provide an explicit trigger from my Routine activity that handles all expected return values ? The trigger is the third tab in my routine activity, right ? What must i add in or...