DSXchange

Can you tell what you want to acheive by sorting data? Total number of keys in sort stage? What is the partition type used?

Invalid object name '#calc_val'

1) What stage you used?
2) What user/schema you used in stage for connection? With which user you succesfully executed outside datastage
3) Is the temp table created with in procedure

Please try using the schema name and check for user privileges.

date inside the procedure will be used after removing xml tags

How are we achieving this? Please post on how you are assigning "in_Rq" variable

Did you try making the same SP call with same parameters through anonymous block from sql plus/tools and succeeded?

Can you post some additional information? You said your input is XML? What is the datatype and element you have given in column mapping in stored procedure stage. How the XML is sent as input to stored procedure stage? Whether column value in dataset or XML output stage? Above all this could be your...

Logically, what is the maximum length of LOB values?

Classical solution should work. Self join!
Source -> Copy - > Two output link -> join -> Output.

And as usual the pitfalls in all the solution that is available for this problem statement persist like who is the manager of top executive, referential integrity setup.

In a sort stage, make partitioning and inline sort based on key columns and have the date column partitioned as well as sorted and in the stage page give all the keys except date column. Set key change column to true. Filter the record for which key change column is 1.

Are there any intermediate stages between source and target.
How you are mentioning extraction is consuming time?
Instead of Netezza as target keep a dataset as target and run the job. Then you can narrow down where we have to dig the problem of time consumption

Thanks for the reply. So it teaches us what is going on. Tip for a day . Mark the post as workaround

What percentage of total number of rows satisfy your condition. If the stage is fetching less number of rows then it means there are few records satisfying the condition. If that is not the case why dont you try the negation?

Doesnt it sound interesting. Your question made me to explore more on the stage, and here it is what i have read http://pic.dhe.ibm.com/infocenter/iisinfsv/v8r7/index.jsp?topic=%2Fcom.ibm.swg.im.iis.conn.stp.doc%2Ftopics%2Fr_cstpref_Managing_Cursors_Correctly.html So in our case, is the cursor exter...

somu what is the first parameter TCL in dsexecute indicates. Where is your xmeta installed

What type of parameter it is? In, in out.
In parameter mapping have you not used this columns? Can you Post the columns , parameter mapping

the the very first Select Query (join across 3 tables) that fetches the 4.5 M records takes about 6.5 Mins Imagine what is happening here. An ODBC connection is created. The query is submitted. For array size that you have mentioned, it will get those records from the database. Database server and ...