DSXchange

Hi all, I want to get the quarter format like for the input link Inlink.field1 Inlink.field2 5848 May 08 5848 July 08 Outlink.field1 Outlink.field2 5848 2008Q2 for 2nd quarter 5848 2008Q3 for 3rd quarter I tried for Oconv(Iconv(Inlink.field2,'D MY[A3,2]'),'DQYQ') It's giving me result what I am not ...

Hi all,

Can any one tell me why it's showing null field, whenever I do conversion on that particular field.

i.e., on Inlink.field01 as mentioned earlier.

I could not able to get quarters of that field.

Hi all,

Can any one tell me why it's showing null field, whenever I do conversion on that particular field.

i.e., on Inlink.field01 as mentioned earlier.

I could not able to get quarters of that field.

Hi all, Thanks for your suggestion, but I am using Inlink.field0, Inlink.field1 as varchar in oracle database and Outlink.field1 as number and Outlink.field2 as Timestamp while i am using Iconv(Inlink.field1,'D-YMD[4,2,2]') or Oconv(Iconv(Inlink.field1,'D-YMD[4,2,2]'),'DQ4') the Outlink.field1 is em...

Oconv(Iconv(DSLink2.Field1,"DYMD"),"DQ") Or, if you want an ISO 8601 "quarter tag" format (YYYYQn): QUARTER.TAG(Iconv(DSLink2.Field1, ...[/quote] Thanks ray As I am coding as quoted like, Oconv(Iconv(DSLink2.,"DYMD"),"DQ") job runs successfully with...

converting to get the quarter field

Hi all, I am trying to convert the get the quarter for Outlink.field1 column from the Inlink.field1 having timestamp in the format YDM and my code for the conversion is as follows Oconv(Iconv(TIMESTAMP.TO.DATE( DSLink2.field1),'YDM[4,2,2]'),'YMD[4,2,2]') Job runs successfully throwing warnings but n...

Hi all, I want to select the first row as a updated one and reject the other rows, for example inlink.field01 inlink.field02 jkdkal 2007/12/12 jkdkal 2008/01/01 jkdkal 2006/01/01 fkdajj 2005/05/04 fkdajj 2008/04/08 fkdajj 2008/08/23 I want to take record to ouput column as follows outlink.field01 ou...

Hi Ray,

Thanks for your suggestion,

will RowProcCompareWithPreviousValue work for DATE column
in oracle database.

suggestions are welcome

Thanks in Advance

Hi all, hash I am using ODBC-->TRF---> ODBC i want to take maxium date for lookup how can i get in transformer for every records i want only the max dated recor inlink.field01 inlink.field02 jkdkal 2007/12/12 jkdkal 2008/01/01 I want to take record to ouput column outlink.field01 outlink.field01 jkd...

thanks ray

for your guidance

Hi ray,

I think I misled you

actually, I need the clarifications like, why the warnings are not coming when I am using another sequential file while having the constraint(rejected)? whereas no rows were rejected to sequential file.

Also I am having only one constraint (i.e., REJECTED)

Hi all, I am using ODBC_src-->TRF-->ODBC_trg, ODBC_trg has composite primary keys while I am running this job my job runs successfully, but i am getting 2000+ warnings... like JobName..Trf.Lnk_: DSD.BCIPut call to SQLExecute failed. SQL statement: INSERT INTO TABLE NAME(FIELDNAME) VALUES (?,?,?,?,?,...

Hi all,

Thanks for your suggestions, I had used the constraint and its working.