DSXchange

Hi Rasi, I have seen isvalid function .It was given isvalid(%typestring%,%Valuestring%). please correct me if iam wrong isvalid(decimal,7,4).but before inserting in to a table I have to check ex : contract type is decimal (7,4) if it doesnot have decimal(7,4) I have to send to a reject link . How to...

Hi,

Iam using an stagevariabe as integer .ex total (variable)

Total(integer) = Total(integer)+Reclinenumber(decimal). I want this Reclinenumber to convert to integer.How to convert decimal to integer can I take it asinteger function to convert decimal to string. Please help me


Thanks
Somaraju

Hi, Thanks for every one. My problem was solved why Iam getting that error is my output is char(8 and when I used rasi steps I got my output as 2006-07-26 but I want as 20060726 so I coded like this to achieve my target DateToString(DateFromDaysSince(-1,StringToDate(Dslink.Validfromdate,"%yyyy%...

Hi, Iam having a requirement like this . Iam getting a message and it was parsed by xml and Iam inserting or updating or deleting the records in DB2 API stage . After entire XML message has been processed (i.e either inserted or updated or deleted ) then I need to commit the table. I read in some po...

Hi Rasi,


I really appreciate you for helping me out. Thanks one more time for helping me to achieve my target



Thanks,
Somu.

Hi Rasi, I followed the steps you said but Iam getting the same error as I mentioned above post. I think this error is because of the function datefromdayssince.I think it will take only int(32) value or Iam making a mistake in conversion that is (%yyyy%mm%dd). Correct me if Iam wrong DateToString(D...

Hi Rasi, Thanks for your answer. But When Iam connecting a look up to a reject link. Reject link is not allowed unless input reference link failure property is set to reject. Iam having a sequential file connected to transformer and connected to lookup its a stream link and reference link is DB2 /UD...

Hi, Please help me . I have a requirement like this I have to look to a table DB2 for xxx,yyy,zzz columms with input source file and if it matched then I need to filter by condition (validfromdate from inputfile =or <> validfromdate in db2 table)and I must write records to db2 table. And I need to w...

Hi Rao, Iam getting an error like this when I used your logic APT_CombinedOperatorController,0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "**********" for conversion "date=date_from_days_since[**********](int32)": APT_Conversion_Date_DaysSince: Invali...

Hi ray, Thanks for reply. My requirement is I have a date with sql type char '19800412' and I want to minus one from this so I have to get '19800411' with sql type char. When I used DateFromDaysSince function.I getting an error since my requirement is with char sql type I tried like this in transfor...

Hi Rino,


sorry my requirement is not only for 9991231 and I have dates othr than that 19980204. I want to subtract 1 from these dates.




Thanks,
Somaraju

Hi,

I have a requirement like this I want to minus -1 day from the date .
For Ex. If I have date 99991231, I want to have 99991231-1 i.e 99991230.
how to achieve this. please help me




Thanks,
Somaraju

Hi Rasi,


Can you brief me how to use isvalid function .Thanks for reply,



Thanks,
Somaraju

Hi, I have an requirement like this. I have a columm in transformer called EconomicDevalution with DEC(7,4).The data is comming to transformer from xml and Iam loading to a DB2 table.I have to check if that Economic Devalution contains DEC(7,4) length. If it doesnot I have to load in a file. When I ...

Hi Narshima,



Thanks for your help




Thanks,
Srinuraju