DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 12 matches
Author Message
 Topic: Oracle connector stage not rejecting data truncations errors
Lavanya B

Replies: 6
Views: 302

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon May 21, 2018 10:31 pm   Subject: Oracle connector stage not rejecting data truncations errors
Hi,

Any patch/environment variable setting is available to suppress the truncation of data?
Please provide suggestions.
 Topic: Oracle connector stage not rejecting data truncations errors
Lavanya B

Replies: 6
Views: 302

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue May 15, 2018 5:50 am   Subject: Oracle connector stage not rejecting data truncations errors
When I increase the length of the field ()i.e varchar 15) in the Input tab of Oracle connector, then the record gets rejected from Oracle connector stage.

Yes even I think DataStage is truncating t ...
 Topic: Oracle connector stage not rejecting data truncations errors
Lavanya B

Replies: 6
Views: 302

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun May 13, 2018 8:25 pm   Subject: Oracle connector stage not rejecting data truncations errors
I have tried inserting into Oracle table using TOAD, but I get an error saying that the number of characters exceeding the length.
But I am surprised why am I not getting this error while running the ...
 Topic: Oracle connector stage not rejecting data truncations errors
Lavanya B

Replies: 6
Views: 302

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri May 11, 2018 12:44 am   Subject: Oracle connector stage not rejecting data truncations errors
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

I am loading data to oracle database using Oracle connector stage as my target.
The source column is varchar 20 and target oracle column is varchar2(10).
I have put a reject link from the tar ...
 Topic: Unable to connect to SQL server through DataStage
Lavanya B

Replies: 1
Views: 538

PostForum: General   Posted: Fri Oct 20, 2017 4:16 am   Subject: Unable to connect to SQL server through DataStage
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,
The DataStage server is on unix.
We are unable to connect to SQL server through DataStage.
We are trying to import table definitions using ODBC table definition. After selecting the DSN from th ...
 Topic: Job with External source stage hangs
Lavanya B

Replies: 4
Views: 974

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue May 05, 2015 12:13 am   Subject: Job with External source stage hangs
The filename is a file with unix commands to get data from different files.

But I want to know the reason why external source stage hangs.
 Topic: Job with External source stage hangs
Lavanya B

Replies: 4
Views: 974

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon May 04, 2015 11:48 pm   Subject: Job with External source stage hangs
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
We have a job that reads from external source stage.
The source program given in this stage is
"sh filename".
The volume of souce data is 193 million rows.
The job hangs after reading 17 million ...
 Topic: datastage job having high start up time
Lavanya B

Replies: 8
Views: 3069

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 28, 2015 12:20 am   Subject: datastage job having high start up time
There are no before SQL statements that are executed in the source Teradata stages.
 Topic: datastage job having high start up time
Lavanya B

Replies: 8
Views: 3069

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 27, 2015 4:20 am   Subject: datastage job having high start up time
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,
There is a datastage job with Teradata Enterprise stage and Teradata API stages as the source. Data is being loaded to Oracle. All the stages in this job are running in sequential mode.
The star ...
 Topic: orchadmin copy command
Lavanya B

Replies: 8
Views: 6871

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Sep 08, 2011 1:06 am   Subject: orchadmin copy command
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
The requirement is: Using orchadmin command, copy the data from one dataset to a new dataset and the data files for the new dataset should be created.
I executed orchadmin copy command:
orchadmin c ...
 Topic: Job with Oracle Enterprise stage as the target hangs
Lavanya B

Replies: 2
Views: 824

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jul 30, 2010 5:34 am   Subject: Job with Oracle Enterprise stage as the target hangs
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,

We have a job with Oracle Enterprise stage as the target. The job has 1.3 million+ records coming from source. This job has been migrated from DatStage7.5.1 The design is as below:

ODBC---& ...
 Topic: TDMload stage error:Bad keyword in the IMPORT command
Lavanya B

Replies: 2
Views: 1452

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jul 22, 2010 4:43 am   Subject: TDMload stage error:Bad keyword in the IMPORT command
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,
I have parallel job where data is coming from DRS stage(67 rows), then lookup is performed with ODBC stage(reference data, 1.5 million rows) which is then loaded into tdmload stage.

The job ab ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours