DSXchange

Thanx Ray,

I guessed that more than 1 records were trying to insert at the same time, so thats why the insert statement failed to execute.
Can this also might be one of the reason??

Hi, One of my jobs aborted giving the following error:- "An insert, update, or delete statement failed to run. (CC_DB2DBStatement::processRowStatusArray, file CC_DB2DBStatement.cpp, line 2,367)". I dont know what this is? I reset my job and restarted it and surprisingly it ran suucessfully...

Hi,

I am using an ODBC Enterprise in one of my job. I was wondering what might be the most effective value of "Fetch Array Size" so as to increase my job performance?
Or does this effective value is dependent on some factors?

Actually we are new to the Information Analyzer. Its challenging task to us to generate few reports based on the loaded data. Decision can be made by the business users by viewing those reports. What are the most useful reports for making such type of decisions? Kindly answer the following question...

Change following points in configuartion file.

1>scratch disk path: make sure you have sufficient space over there.


Thanks
Anil

@pandeesh
I know what you are trying to say, but the bottomline is that the query works.

Hi pandeesh,
Can you plz explain it as I have no idea about REINDEX.

Let KEY_1 is ur PK(or any distinct column) and ABCD is your table,
then this might help

delete from ABCD where key_1 in
(select key_1 from (
select key_1 from ABCD
fetch first 3 rows only)
order by 1 desc
fetch first row only)

@everybody
For every Question there's an answer.

Hi, We are struggling with an absurd problem with Director. For some specific folders, the Director is unable to show the list of jobs and throws the following error and then crashes. Run time error '457'; This key is already associated with an element of this collection. We dont know how to solve t...

Use following command.IT wil work. I have tested sucessfully. ./istool export -domain serverIP:9080 -verbose -username ****** -password ****** -archive "AAAA" -datastage '-includeexecutable "servername/project name /*/jobname.*"' where *****- means username/password AAAA- means p...

Dear Team,

As a best practice we would like to have regular datastage project backup using unix script.

we are using AIX 6X.

Kindly provide me backup script else command for the same.


Thanks and regards,
Kishor

Need basic knowledge of HASH TABLE.

Kindly suggest me how to use hash table in DS8.1

Thanks
Kishor

Yes you can use the different node for your particular stage. consider you have one configuration file having 10 nodes out of that 6 node you can use for particular stage using pools "DB2" and remaing 4 nodes for other stages(default). In particular stage,click on stage icon --> advance se...

we want below information:

1> How many records are rejected( we are using db2 connector ,no reject link)

Hi, As per the business requirement ,we have to find the rejected record count. my job as follows: src_db2_connector----->transformer----->Tgt_db2_connector(Upsert mode) | | -------------exception_tgt_db2 connector Tgt table having primary key. when duplicate records are come job will abort. we dont...