Hi Phani,
I have tried this looping but could not achieve the desired result. Could you please explain me in detail what needs to be Done.
Thanks in Advance
Search found 30 matches
- Mon Jan 27, 2014 6:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage scenario
- Replies: 5
- Views: 3113
- Mon Jan 27, 2014 4:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage scenario
- Replies: 5
- Views: 3113
Datastage scenario
Hi Team,
I have below requirement,please suggest approach to get desired output
input:
2
3
4
1
output:
2
2
3
3
3
4
4
4
4
1
Output should get the multiple values based on the value of input field.
I have below requirement,please suggest approach to get desired output
input:
2
3
4
1
output:
2
2
3
3
3
4
4
4
4
1
Output should get the multiple values based on the value of input field.
- Tue Oct 22, 2013 2:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Conversion Error
- Replies: 3
- Views: 1824
Conversion Error
Hi Team,
I am using below conversion in one of the derivation in Transformation stage:
DateToDecimal(Column_name,"%yyyy%mm%dd")
Which is throwing below warning:
Conversion error calling conversion routine decimal_from_date data may have been lost.
Please help to avoid above warning
I am using below conversion in one of the derivation in Transformation stage:
DateToDecimal(Column_name,"%yyyy%mm%dd")
Which is throwing below warning:
Conversion error calling conversion routine decimal_from_date data may have been lost.
Please help to avoid above warning
- Sat Oct 12, 2013 12:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connector Update then Insert mode not working for RCP
- Replies: 8
- Views: 11945
Oracle connector Update then Insert mode not working for RCP
Hi Team, I have Type 1 table,where in new records will be inserted and if matching record foound it should update existing record. So in target oracle connector enabled RCP and the write mode is Update then insert ,but throwing below error. The connector could not automatically generate the WHERE cl...
- Tue Sep 17, 2013 12:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: connector received Oracle error code ORA-1406
- Replies: 14
- Views: 24433
- Tue Sep 17, 2013 12:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: connector received Oracle error code ORA-1406
- Replies: 14
- Views: 24433
- Mon Sep 16, 2013 8:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: connector received Oracle error code ORA-1406
- Replies: 14
- Views: 24433
- Mon Sep 16, 2013 7:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: connector received Oracle error code ORA-1406
- Replies: 14
- Views: 24433
- Mon Sep 16, 2013 7:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: connector received Oracle error code ORA-1406
- Replies: 14
- Views: 24433
connector received Oracle error code ORA-1406
Hi Team, Derivation for one of the column in my oracle connector is as follows: AVG( NVL(C1, 0) ) * AVG( CASE WHEN C2 <= 0 THEN ABS(C2) ELSE 0 END ) When i run job,getting below error message: While reading data for column COLUMN_NAME, the connector received Oracle error code ORA-1406. (CC_OraStatem...
- Mon Aug 19, 2013 11:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Format Error in parallel job
- Replies: 2
- Views: 1649
- Mon Aug 19, 2013 9:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Format Error in parallel job
- Replies: 2
- Views: 1649
Date Format Error in parallel job
Hi Team, I am using below below query in oracle connector in my parallel job in order to get yaer and month from date. select to_char(DATE_COLUMN,'YYYYMM') from table_name. While running facing error:literal does not match format string. If i run same query in oracle datbase its working,not sure why...
- Thu Jul 18, 2013 6:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp to Varchar conversion
- Replies: 1
- Views: 1906
Timestamp to Varchar conversion
Hi Team, I have requirement to convert timestamp to varchar.my source field is time stamp and target is varchar field. input:07/18/2013 17:00:00 output:07182013 i'm getting desired ouput,but warnings are coming with error message: conversion error calling conversion routine... i had tried below opti...
- Fri Jun 14, 2013 12:40 am
- Forum: General
- Topic: Converting server routine into parallel
- Replies: 4
- Views: 2052
- Wed Jun 12, 2013 10:32 pm
- Forum: General
- Topic: Converting server routine into parallel
- Replies: 4
- Views: 2052
Converting server routine into parallel
Hi Team, I have a server routine with below code to get the status of job,i need the same functionality to incorporated in a PX routine.As am not familiar with parllel routine,can any one help me with code. $include DSINCLUDE JOBCONTROL.H JOBHANDLE=DSAttachJob(JOBNAME,DSJ.ERRFATAL) Ans=DSGetJobInfo(...
- Tue Jun 04, 2013 12:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generic job to migrate tables from sybase to oracle
- Replies: 1
- Views: 1925
Generic job to migrate tables from sybase to oracle
Hi Team, I need to develop a parallel job to migrate tables from sybase to oracle server. I'm using sybase connector and oracle connector with create target table YES and RCP enabled in job properties. but getting below error in the oracle stage,though enabled RCP The connector could not validate th...