DSXchange

Try this logic, its somewhat similar to Arndw i guess.

Create one stage variable.

SvRUN_DT(Varchar) = DSJobStartDate[1,8]:01

Then in the output derivation for RUN_DT, put:

DateFromDaysSince(-1, StringToDate(SvRUN_DT) )

Try this i got the logic from another post and modified the stage variables logic, but i am not sure. Declare 3 stage variables like below. SvRUN_DT = DSJobStartDate svYear= YearFromDate(SvRUN_DT) svMonth= MonthFromDate(SvRUN_DT) Then in the output derivation for RUN_DT, put: If MonthFromDate(RUN_DT...

sorry the design is not correctly posted.

This is the test job that i did for your question. after the source stage in Transformer take 3 stage variables. Vari1: key1:Key2 Vari2: If Vari1 = Vari3 then 1 Else 0 Vari3: Key1 : Key2 Flag : If Var2=0 then 1 Else Flag+1 Then Create 3 output Links in First link Put a constraint Flag=2 and get the ...

Try changing the output link column datatype to Varchar in transformer and then use the function StringToDecimal.
If you want to use just one Transformer use Stage Variable and then use StringToDecimal Function in column derivation cell. Just my thoughts.

In transformer stage define a stage variable and write an If condition saying If inputcolumn < 9999 then '1' Else '0'. Then put a constraint on the output link saying Stage Varibale = '1' and for the rejects link constraint should be Stage Variable = '0'. Its just my thoughts.

Try this DecimalToString(Column_name,""fix_zero,suppress_zero") and change the output Column data type to Varchar.

Try calling metadata from Plug-in metadata definitions.

Thanks for reply. my problem was solved.
error occured due to column name is more than 30 charecters.

Hi , When i am trying to create a Match specifications while running "Test All Passes" following OSHErrorLog is generated. can any one please suggest solution in this. ##I IIS-DSEE-TFCN-00001 21:13:23(000) <main_program> IBM WebSphere DataStage Enterprise Edition 8.0.1.4665 Copyright (c) 2...

you can suppress those warning messages by using message handler management in DS director->tools

thanks for all, i am using datastage 8.0 here which plugin is better to use here i have websphere MQ stage & websphere MQ connector stage.

cust_id= unique id my data flow in job : 2 oracle data base ->join stage ->xfm ->MQ serises plug-in I am reading two tables and joining by using cust_id and sending data to transformer.my source table1 contains cust_id as key and in 2nd table the keys are cust_id and cust_transx_number Each cust_id ...

As shiva4joy said i tested converting yyyy-mm-dd to yyyymmdd using sequential file and in transformer i used convertion string , convert('-','', inputlink_columnname)and changed length properties of datecolumn in column tab in target to 8 and it worked fine. But i did in server job.

ray.wurlod wrote:Since there is no version 7.2x I will assume you are using version 7.5x2.

This is an error in the DataStage client. The only solution is to re-install the client software. ...

After reinstalling my client software, it really worked out thanks to all.