DSXchange

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...

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...

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

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...

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...

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.

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.

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...

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.

ArndW wrote:DataStage Server - yes
DataStage PX/EE - no ...

ARNDW could you explain me about this.how or where does data stage server maintains this.

does data stage has internal database

could you explain me about data stage internal format.

Does data stage has internal storage place to store data.

IN CONTROL PANEL CHECK for data stage administrator there you can start and stop the data stage engine.