DSXchange

Where I need to use TimeToString()? Here the problem is If i am not getting any thing from source(null or length <>6) then I need to hardcode with "1900-01-01 00:00:00". else time like 20:01:01. I try with so many way but i didn't succeed on this. Please help me.

it's SQL Server2005 Database

Regards
Kondeti

Hi All I am getting below problem plz look in to this. My Database is: SQL Server2005 Target_column_Datatype: Datetime Source Posting_time -------- 200607 200708 210708 In Derivation: If Len(DSLink6.POSTING_TIME) <>6 Then "1900-01-01 00:00:00" Else Left(DSLink6.POSTING_TIME,2) : ":&qu...

Hi I need to pull the data from source oracle system. i.e., for yesterday data. For this I am putting condition in where cluase as sysdate-1. But i got access for this source system from night 11:00 P.M to Early Morning 4:00 A.M. in this case 2 different dates are involving. I want to pull before 12...

I got result. Thank you

Hi Plz tell me how can we read the fixed width files in Parallel jobs. In server jobs fixed width option is available in sequential file. Is there any option available Parallel jobs. I am already done some R&D I didn't find that option plz help I am new to parallel jobs is there any alternative....

Convert that .xls to .csv file and read the file throgh Sequential file or Fileset.

Regards,
Shiva Kondeti

Hi

Exactly when ever you loading data first in sequentialfilestage/fileset then DB2 we need to do the below thing for char/Varchar Datatypes

you need to use the hardcode thing in " "(Double Code) in the Derivation part


Regards
Shiva Kondeti