DSXchange

Hi, Could you please help me for the below issue. I've a parallel job to update a netezza table . Purpose: update xtable set c1=inputc1, c2=inputc2 where k1=inputk1 and k2=inputk2 and c3 is null I'm using Netezza connector stage as a target stage. When I choose write mode and define k1 and k2 and up...

Thank you all for replying. i used

FIELD(trim(DSLink12.Field001), "|", 1) ='' to check the null records and it worked

Hi I have a pipe delimited input file as below. First byte of the each line indicate the record type. Then i need to split the file based on record_type = null,0,1,2,6 and create 5 files. Since this data is multiformat, i used a seq file (single row)as tab limited.And then thinking of using a constr...

Thanks Sachin and Chulett for quick reply. As Chulett sugested i did concat together and it is returning the value as expected. :D

Thanks Sachin. I tried doing concat just to get the date, but is returning empty value

Arg1 - 2008-05-08 21:28:26.0

OCONV(ICONV(Arg1[1,4]:Arg1[6,2]:Arg1[10,2],"MTS"),"MTH")

Hi I have a oracle date field ('YYYY-MM-DD HH24:MI:SS' ) and seq_no field (NNNN)coming from flat file and i need to concat the date and seq_no to YYYYMMDDHHMMNNN. Here's the example i getting date value as 2008-05-08 21:28:26.0 and seq_no as 0001. the result should be 2008050821280001. can someone h...

Thanks Dsguru. It worked. :D

how do i concat the time portion? From the source it is coming "yyyy-mm-dd" without the time portion... and loading in to timestamp 'YYYY-MM-DD HH24:MI:SS')... actually oracle insert statement convert that to TO_DATE(:1, 'YYYY-MM-DD HH24:MI:SS')

Hi I have a date field coming from a file, it is defined as VARCHAR and need to load that to Oracle field(Timestamp). example it is coming from source : 2008/04/25 I did ...........oconv(iconv(src.Create_Date, "D4-YMD"), "D-YMD[4,2,2]") but it is throwing this error "ORA-018...

Hi I have a sr_number column coming from the source.(oracle) Then need to count the number of records with distinct non null sr_number and then pass it to a another variable. i can create a variable to get the not null values and pass it through a aggregator to get the count. so it would be Vsr_no =...

Thank you ARndW and Ray. It worked. :D

Thanks Chulett for the reply. I have tried substacting the two dates directly, but it retuned only 0 values. For in conv format, yes you are right i gave the wrong format :( . so i changed it to below Iconv(source.COMPLETED_DATE[1,10],"YYYY-MM-DD") - Iconv(source.ENTERED_DATE[1,10],"Y...

Hi I have to do a following calculation to populate no of days for cycle time.Both dates are oracle time stamp values. cycle time column defined as decimal (10) in the target table. cycle_time = completed_date - entered_date example : 2006-02-10 00:00:00.0 - 2006-02-06 00:00:00.0 I gave the variable...

Thank you all for the solutions. I have used the one chulett suggested, It works like a charm

Hi, Input Data VSR VR VUA Instar I need to check the first 2 characters of the field from the left to see if incoming values are 'VS', VR' or 'VU' then assign as "AVPN",else incoming field. I did following to check the 1st condition followed by the other conditions.But it is not selecting ...