DSXchange

Hi, In my project we are loading the data to target DB2 tables, Can you please give answers below questions 1) which stage is better for connecting to DB2(DB2/UDB API or DB2/UDB Enterprise stage or DB2/UDBload) 2)I heard that DB2 connect software is needed for connecting to DB2 database by using the...

chulett wrote: Check to see if the date is valid or not, reject it if it is not.

Which part of that do you need help with?

Hi Chulett,

Thanks for your's response,

I need how to check the date format and reject that record,

i tried with IsValid, it is not working,

Hi,

Thanks for response,

here i need to load the data to target if format is YYYYMMDD only, otherwise need to reject ,

Let me know how to handle

Hi,

We need to check the date format in the source column,

If format is YYYYMMDD then we need to send to Target else reject the record,

Ex: data:20080927 ---it is fine
data:20082708----it is wrong
data:00000000----it is wrong

Let me know how to check this format,

Hi Chulett,

Thanks for your's suggestion,

Actually my requirement is read the data from the Flat file and load the data to DB2 database by using OracleEnterprise datastage,

Hi,

We have one requirement as need to connect DB2 database from Oracle Enterprise stage,

Let me know how to do,

Thanks for your's suggestion, Pivot is not the solution, because i need to write the records into the target output file Job reads the first record from the file and first 3 columns write into the ouput file as first record and next 3 columns write into the same target file as second record and so o...

Thanks for your's suggestion, Pivot is not the solution, because i need to write the records into the target output file Job reads the first record from the file and first 3 columns write into the ouput file as first record and next 3 columns write into the same target file as second record and so o...

Hi, My input record is given below "name","desig","description"=======Column names "raghunath","software","software,engineerfromindia" ===== Data My Requirement is given below, 1) need to check the delemeters(",") count , if it is...

Thanks Reddy fyi,
I am asking about how to run Profiel stage jobs in command line prompt

How to to take all job names in a project and how that routine works !, could you ls expalin me, how to find all Jobnames and statistics in the project , what are the commands we have to use....

Hi, We are dealing with multi country data,these records are getting loaded from Oracle into Oracle tables and when we are taking lookup/join of one table with another which has exactly same data but loaded from some other table lookup is failing. NLS is defined @project level is-ISO-8859-1 Plz sugg...

ArndW wrote:days_since_from_date

Thanks, but can you further help my understanding?

I want the no. of days between Date1 and Date2

Will this work?

DaysSinceFromDate(Date1,Date2)

vinodn wrote:Hi

I have a requirement to calculate service period subtracting 2 dates?
How can I approach this issue?

Thanks

Plss help me out with this issue....

Hi

I have a requirement to calculate service period subtracting 2 dates?
How can I approach this issue?

Thanks