Search found 20 matches
- Thu Feb 10, 2011 11:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data truncation
- Replies: 3
- Views: 3800
Adding transformer downstream we can avoid warning..My question is if we fetch a value using sub string from a column we will specify only the desired length of the sub string and not the length of the source column... In such case we get warning to use the Length of the source column. Is it a bug w...
- Wed Feb 09, 2011 12:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data truncation
- Replies: 3
- Views: 3800
Data truncation
Hi, I have a field named material in my database which is of length 18.But the max length of the value is 7.I am using the below query and specified the column length as 12 because I am joining with similar column of length 12.But i am getting the below warning.. If I set it as 18 as in Database the...
- Mon Sep 20, 2010 11:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 bulk Load
- Replies: 4
- Views: 3020
Re: DB2 bulk Load
HI kwwilliams,
I have insert Privilege on the table..I am getting those message only when I use DB@ bulk load stage.While using rest of the stage it's fine.
Suman
I have insert Privilege on the table..I am getting those message only when I use DB@ bulk load stage.While using rest of the stage it's fine.
Suman
- Thu Sep 16, 2010 6:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 bulk Load
- Replies: 4
- Views: 3020
DB2 bulk Load
Hi , I am using DB2 bulk load stage I am getting following error 1) does not have the privilege to perform operation "LOAD". 2)DB2_UDB_Load_289,0: Input 0 consumed 1744300 records. In job it show 1744300 records has been passed but no Record is found in Target The user has Access permissio...
- Thu May 13, 2010 1:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DATE FORMAT IN DB2
- Replies: 0
- Views: 896
DATE FORMAT IN DB2
Hi All, My input stage is DB2 and Target is DB2 on of my source column has the input as 0001/01/01 Data type Varchar and in my target stage Iam passing this as Date.The output what Iam getting is 12-30-0001.I need as 01/01/0001 in output and if I have Empty string in my source DB2 is there any way t...
- Thu Feb 25, 2010 6:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: TRansformer
- Replies: 4
- Views: 2515
TRansformer
Hi guys, I have a file with records A B C I want to pass this to three outputs seperately from transformer as output1=A,output2=B and output3=C without passing constraints or using any conditions. one output can have constraints, is it possible to do with functions in transformer.
- Sun Aug 03, 2008 7:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: process metadata
- Replies: 2
- Views: 1405
process metadata
HI friends,
our job is to generate process meta data ,to get job log in to file we did this with after job subroutine option dsjobreport and got the output generated. is there any other possible ways to do this.
our job is to generate process meta data ,to get job log in to file we did this with after job subroutine option dsjobreport and got the output generated. is there any other possible ways to do this.
- Wed Mar 26, 2008 2:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove Duplicates
- Replies: 3
- Views: 1766
REMOVE DUPLICATES
use sort stage with the option key change column which gives the output value as '0' for non-duplicates and '1' for duplicates.And then use filter stage to filter these records separately based on the key value. source------>sort--->filter-------->target Do a search on "remove and capture the d...
Looks like a remove duplicates logic to me. Do you want to remove all the duplicates from the data? Then use a Remove Duplicates stage instead of a filter stage. Hash partition and sort the data on the key fields. i didn't mean removing the duplicates. i set 'output row once', option in filter stag...
filter
In filter stage i am filtering the particular record which has many duplicates.
which gives all the rows,in order to the first row I set row out put only once. instead of getting only one row i am getting all the row.
could any one help me.
which gives all the rows,in order to the first row I set row out put only once. instead of getting only one row i am getting all the row.
could any one help me.
database
does data stage has internal database
- Thu Feb 28, 2008 12:35 am
- Forum: General
- Topic: internal storage
- Replies: 4
- Views: 2664
- Wed Feb 27, 2008 11:19 pm
- Forum: General
- Topic: internal storage
- Replies: 4
- Views: 2664
internal storage
Does data stage has internal storage place to store data.
- Sat Jan 19, 2008 10:44 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to start and stop DS Engine on Windows
- Replies: 3
- Views: 2076
Re: How to start and stop DS Engine on Windows
IN CONTROL PANEL CHECK for data stage administrator there you can start and stop the data stage engine.