DSXchange

hi all, i am using 4 join stages sequentially ,the join lookup is same table for 4 joins and key column also same and i am using the left outer join on 4 joins and 4 joins are produced same column as output.i got output proper but the problem is it is generating the warnings like......... JoinNZMISS...

thebird wrote:Can you try doing a trim of your string before giving it to the conversion function - and let us know if the warning still persisits?

thanks for ur input
the problem is solved by me,in transformer stage at source field i specified the length.


thanks
praveen

Hi Praveen, In which stage you are performing this converison either Transformer or Modify stage. Use the Proper syntax for that in the above stages. If you are perfoming this in any satge without any conversion, then it will throw error to you. In Tarnsformer : TimestampToString Return the string ...

balajisr wrote:What is the length of the destination string?

i dont specify the length.

hi all,


i am changing the datatype of my input column timestamp to string,it is generated error like;

xfmLoadData,0: Conversion error calling conversion routine timestamp_from_string data may have been lost

can u provide the solution...

thanks inadvance
praveen

Change the column name in one of the links to the Join Stage and also switch off RCP on both the links to the Join Stage. This should take care of your warning. The Bird. thanks for ur input if switch off the RPC,in output data set i did not get the data in ralated columns in the join stage columns.

Hi all, While i am trying to load the db2 using the db2/udp stage i got these errors ,at the time i set write method is load and deflault server and database is set to false. errors: dbW_IIPNT0_Tgt,0: DB2 Load Binary Error. main_program: Invalid character conversion found converting to ASCL_MS1252, ...

hi all, while i am loading into the taret DB2 table it is giving the following warnings "dbW_IIPNT0_Tgt: When checking operator: When binding input interface field "PNADR3" to field "PNADR3": Implicit conversion from source type "string[50]" to result type "st...

hi all, while loading the Data into the target Dataset i am getting the warinings like 1."APT_CombinedOperatorController(7),2: A numeric string was expected, got "94134 "; using Decimal, the default value." and 2."APT_CombinedOperatorController(7),2: A numeric string was exp...

In transformer their is no function for extracting the numerics from string and extracting the alphabetics from the string.

Hi everybody, my problem is extract requred data from string like "12.32.345.23 datastage" this is my string,in this i want to extract some time numeric only(like 12.32.345.23) and some times i want to extract charecters only(like datastage).in server jobs code conversions is their,but in ...

Hi everybody, my problem is extract requred data from string like "12.32.345.23 datastage" this is my string,in this i want to extract some time numeric only(like 12.32.345.23) and some times i want to extract charecters only(like datastage).in server jobs code conversions is their,but in ...