DSXchange

Hi, I am loading the data from Seq file to db2 database. I am using the stages in this job is like: seqfile----->Transformer----->db2api when I run the job, job got aborted and the error message is like: SFI00PDetailTot02..trns_HostData: [IBM][CLI Driver][DB2/AIX64] SQL0803N One or more values in th...

Hi, I have code like this: select col1 from tbl1 where tbl1.col2=tbl2.col2 and tbl2.col1=tbl3.col1. I can create hash file for tbl2.col2 and map with the source table col but how can I map the second where condition because it doesn't have source table in the condition, two tables are different from...

Hi,

How to import data from excel file to table.?

Thanks in advance

Hi

I want send the director log file to my mail id. Can anybody help in this regard?

Thnaks in advance.

Hi DSguru,

I am using Oracle OCI stage for source db.

thanks in advance.

Hi thanks for quick response.

Do u mean that should i write the user defined sql at source(database) level to sort the records?

thanks in advance

Hi Chulett,

thnaks for quick response.

Can u elaborate it a bit more please?

thanks in advance

Hi ,

My job is like db--->AggStage---->db. I am aggregating the sal group by geography. i am processing 1 million records. my job is running very slow. I used Link Partitioner though its very slow. How can I improve my job performance?

any help would be appreciated

Hi,
I need to use the database as lookup n my sourse is also database, I need to map these two without a key column in XFM stage. How should i procede for this? Is there is any stage to use with out key col?

thanks in advance

Hi,

When do we use static hashed file and on which basis do we define it?

thanks in advance.

Hi, If my table contains 50 columns and I have to extract 30 distinct columns if I used hash file what can be happen to the remaining rows Is there any option other than writing the sql query and the sinario is if if we want to select distinct on 25 columns what can we do any help would be appreciea...

Hi Kumar,

thanks for reply.

Instead of Delete, why cant you just replace the whole content.

What does it mean?
I am giving the query in Before SQL. like this

DELETE FROM SCHEMA.TABLENAME

thanks in advance.

Hi, I am running a job with stages Src(Seqfile)-->LKP-->3 XFM stages-->LCC-->DB2 I selected Round Robin method in Link Partitioner and Sort/Merge method in Link Colletor and sort key is the Key column of Input columns. Update action is "Clear the table, then insert rows" and given DELETE S...

Hi ArndW Thanks for your quick reply. I am very sorry for giving wrong information. Actually the questin is about Random Method in Link Partitioner. How will the Random method in Link Partitioner stage work? I loaded 12 records from src to tgt using 3 XFM stage b/w Link Partitioner n Link collector ...

Sorry my dear gurus,

My question is not about Round Robin its about Random method.

I am extremely sorry for giving wrong name.