DSXchange

Hi Arndw/ray, Thanks for your valuable input.after selecting the system table tab i was able to import the metadata succesfully. however when i try to read it using odbc stage by giving correct table name like in excel sheet ,each workbook is considered as table.so i gave the worksheet name with $ i...

Hi, As you stated to subtract 60 days from date but when it comes to Leap yaer and if month contains 30 and 31..then it wn't work. Ex: Input date=2009-04-30 output date=(2009-04-30)-60 days =2009-03-01 My output date required =2009-02-28 Keep same DD if it is valid after conversion else move the cor...

Hi, I have searched the question ..its not yet answered in forum. Ex:date=2009-04-25 [ccyy-mm-dd] Output Date:2009-02-25 After doing conversion keep same DD and then make sure that it is a valid date. If an end of month DD then move the correct DD for that MM. say for I/date=2008-04-30 after converi...

Hi,

How to get the Previous 2 months from Given Date in Datastage Parallel Jobs?

Date format=yyyy-mm-dd

Any help would be appreciated.

Thanks
Sandeep

Hi andrew, My Definition of 2 months means,subtract 2 months from give date and if the date after difference is correct for the month keep it else take the correct date for the particular month. Ex date=30-04-2010 - 2months output= 30-02-2010 but 30-02-2010 is not valid date for the given year 2010....

Hi andrew, My Definition of 2 months means,subtract 2 months from give date and if the date after difference is correct for the month keep it else take the correct date for the particular month. Ex date=30-04-2010 - 2months output= 30-02-2010 but 30-02-2010 is not valid date for the given year 2010....

Hi, I have 1 requirment in Parallel Jobs regarding date conversion. Input Date is Parametreized as #Ws_Mig_Date#.The output date should be #Ws_Mig_Date# - 2 months. Ex1:#Ws_Mig_Date#= 2010-04-30 Output Date=2010-02-28 Ex2::#Ws_Mig_Date#= 2011-05-25 Output Date=2011-03-25 as you see here in Ex1 when ...

Hi, I have got the solution.one of my friend helped me to write this Routine. Thanks for your Response. ********************************************************************************************************************************* * Remove the FF value and convert the multiple occurences of space...

Hi, Its not a Pure Binary format. i would like to tell with 1 example. Say for column DI and its values which are in Hex Format. DI -- 31 32 33 34 35 36 37 38 21 47 37 63 31 32 33 34 My requirment ----------- if length of DI field is<=4 the i have to use Decimal Value else if Length is >=5 then i ha...

Hi, Its not a cobol type 3 field. Input is coming from Datastage Tx.we can incorporate this conversion at Tx level itself but there are lot of columns to be applied so each column there will be three fields di_hex,di_dec_di,asc .so we wwant to restrict these column. So we want to incorporate this lo...

Hi, I have got 1 requirment to convert the hexadecimal value from input file to Ascii and Decimal using Server jobs? Ex:Say for column di=21 47 37 63 is hex value to be coverted into Decimal and ascii. Datatype for input column is number. output: Asci value: !G7c Decimal value : 33715599 I need to d...