DSXchange

how to count the distinct of a column value

if the column values are

2
3
4
2

then the count should be 3

how to acheive this in datastage other than DB2

While writing in the DB2 Enterprise stage, if the job is aborted what is the flexibility of restarting it by deleting the written records in the previous unsuccessful run in the same job other than looking up the same table again in the same job before writing it or running one more job for solving ...

I am trying to read a column from a sequentile file to use it in the DB2 to delete the records. While running this job i am getting the following warning SEQL_File: Import consumed only 10bytes of the record's 106 bytes (no further warnings will be generated from this partition) How can i remove thi...

Try to change the columns names in it, since if u r using more than one joiner it might have this kind of problems. So Inside the joiner try to change the column names and run the job.

Even i 2 faced this kind of problem before, now it got solved using this name changing

We have a data set which has the following columns and data type The structure of the data set is Dset1 C1 char(40) C2 smallint C3 char(6) C4 decimal(9,2) C5 integer C6 decimal(9,2) C7 integer C8 decimal(9,2) C9 integer This data set will have 150 million rows so how much will be the size of the Da...

Hi while trying to creat a new column(SEQ_I) in the DB2 Enterprise stage and defining it as a not null column it is showig the warning as follows: When checking operator: When binding output interface field "SEQ_I" to field "SEQ_I": Converting nullable source to non-nullable res...

Hi In am using an aggregator stage to do a sum of a count whose output should have a data type of integer. But as of my knowledge i am getting the output only in dfloat and decimal. While tryong to to convert it into integer it is showin warning. How to convert the output from decimal to integer wi...

i want to make this trim inside the DB2 query in a DB2 API stage itself could u pls let u know more exact query for writing the same

How can i achieve the output of the string with its space in between being removed in DB2 stage written in DB2 as a query

ex. input col: AB IT

req output col:ABIT

Actrually in my project in am dealing with a very huge amount of datas around 1-2 TB

Hi Lakshmi, What is the purpose of the temporary table?. You can use a Dataset for temporary storage. The Dataset need not be truncated but overwritten with the data from current cycle and used to load the database. You can also have different datasets based on different extraction dates. HTH --Ric...

Thanks for ur interest. Actually what i need is, in need a time delay between the fetching of parameters for the 1 time to the next. For example if v have "a" & "b" as the contents in a parameter file, and this has to be passed a paramter to another file one by one, after fet...

Truncate operation not possible in DB2 use delete for table truncate. Please explain more clear about your requirements. I have extraction dates for a same job which has to be passed as a parameter to create a temporary table. This is has to be inserted and transfered to another tables by performin...

I want to have a DB2 stage which has to have a Insert as setting for certain number of runs and it should to truncate for the next and this whole process has to repeat in a cyclic process. How can I achieve this? For expample, if i have 5 buckets of data running in a consequtive process with job sp...