DSXchange

Again, that depends on the job design. Stages such as Sort and Aggregator (Hash mode) can block execution of downstream stages. In an unblocked design stages close as close to simultaneously as whatever is controlling the processes can manage. Thanks Ray!! Still i am not very clear. Say if we dont ...

Open command executes when the stage opens. Unless there's some designed-in reason not to, every stage opens when the job opens. Thanks Ray Wurlod!! I was under assumption that the ODBCwhich recieves records first will get open first. Thanks for the clarification. So, in my case if i have "sam...

Hi, Looks like we found a bug in code but was not affecting data. Would appreciate gurus advise on the below topic why this was not affecting data: In my job for target we have 2 ODBC stages writing to the same table. And each odbc stage uses an "Open Command" which deletes the table befor...

Just copy Message handler from DEV to QA or QA to Production. All the nessage handlers stored in the following path with *.msh. /opt/IBM/Engine/InformationServer/Server/MsgHandlers Thanks Man Actually i am using version 7.5.2 Resolved. We exported executable along with job design and reimported in ...

'' is empty string, the most important word there being string. If you set a decimal 14,2 to empty string the result will be 000000000000.00 instead of empty string. You cannot compare a decimal to a string (first two comparisons of the second transformer), its not a valid comparison which is why y...

kumar_s wrote:Looks like you are converting from Varchar to Decimal.
Do a PEEK from the first transformer to see the values thats been passing to the next.
BTW, why do you need to two transformer for this purpose.

I have only decimal(14,2). NO where i am using varchar data type for this fields.

How come your Col1 after Transformation 1 is not an empty string but 0? Looks to me that is there is some inconsistency between the logic and examples you have provided. I verified the data and derivations and i provided they are in align with what i have. Then col1 Null is not becoming empty but 0...

What are the datatypes and default values ? Did you post the derivation copied from the transformer or was it manually typed ? It will be better to see the actual derivation. Why don't you do something like NullToValue(col1, NullToValue(col2, NullToZero(col3))) For all columns source and target dat...

Please give examples of values into and out of each Transformer stage, indicating whether each example is as expected. Here is the data Data in source table: col1: Null Col2: 0 col3: 20 After Transformation 1: Col1: 000000000000.00 Col2: 000000000000.00 col3: 000000000020.00 After Transformation 2:...

Correct me if i am wrong. The DS Developer manual has this example which shows the precision will not be lost after abs function. This example uses the Abs function to compute the absolute value of a number. AbsValue = Abs(12.34) ;* returns 12.34 AbsValue = Abs(-12.34) ;* returns 12.34 That's in th...

mandyli wrote:Just copy Message handler from DEV to QA or QA to Production.

All the nessage handlers stored in the following path with *.msh.

/opt/IBM/Engine/InformationServer/Server/MsgHandlers


Thanks
Man

Actually i am using version 7.5.2

Hi, I have job design like this. ODBC --> Tranformer 1 --- > Transformer2 -> ODBC Transformer1 : if isnull(col1) then '' else col1 if isnull(col2) then '' else col2 if isnull(col3) then 0 else col3 Transformer 2: If col1<>'' Then col1 Else If col2<>'' Then col2 Else if col3<>0 Then col3 Else 0 col1,...

Local message handlers are in the msh files. Global (named) message handlers are in the directory Arnd mentioned. You can migrate the files - they are pure text. The main issue is getting the correct msh file into the correct job SC directory on the target. I believe istool is better at picking the...

Abs will return integer value. So you will loose the decimals. Technically, it returns a dfloat - but the input is an integer, so your trailing decimals get stripped off before they are passed to ABS. How's that for nitpicking? :lol: But, I see you want to strip the trailing decimals anyway, so ABS...

I am using the following: if col<0 then "-":right(abs(col),7) else right(abs(col),7) please suggest me the correct way to do this. you can try this code: If inlnk.inputfield < 0 Then '-':right(Field(inlnk.inputfield ,'.',1,1),8) Else right(Field(inlnk.inputfield ,'.',1,1),8) [/quote] My t...