DSXchange

Sudheer

What you can do is read your csv file record as one single string and then inside your transformer check the total commas you expect for good records. Have two links as ouput. One being the good ones which you wanted to use and the other for the rejected records.

Hi Gaurav

Use Kenneth's stored procedure which is the most efficient way to delete records in your case. And do the REORG once all the records are deleted. The REORG will increase the performace whenever there is big change to the table. Involve DB2 DBA to do this when the system is idle.

Rachel 3 to 4 rows per second is not normal. I suspect something is wrong. From Sequential to Sequential without having any complexity inside your transform it should come up with few thousand records per second atleast. By the way how many columns are there in your sequential file. Try to run this ...

Hi

Have a custom conditional trigger on the three jobs to check the status of each job and send all three links to Routine Activity where you can call AbortJob Routine to abort you sequence

First do a search on the forum for Pivot....

For Urgent you need to hire consultant immediately...In DSXchange urgent = ignore

Rachel Welcome to DSXchange KeyMgtGetNextValue and KeyMgtGetNextValueConcurrent is same except the latter is used when you have multiple jobs running at the same time to get the keys. First if you don't think that is never going to happen then you will be better of using KeyMgtGetNextValue. Second y...

Are you trying do any FLASHBACK option in Oracle 10G. What is that you are trying to do. Post your SQL to understand the problem in detail... How frequently it happens. Oracle 10G has options like purge dba_recyclebin purge recyclebin purge user_recyclebin But I would suggest you to discuss with you...

Vinod

When did you took your last datastage project backup?....

Senthil

In developer guide it says

"The Where property supports standard SQL expressions, except when comparing strings."

There should be something else which makes it not to work....

Hi

Stored Procedue stage only support Oracle, DB2 and Sybase as you can these in the drop down box. I never tried calling stored procedure thro datastage, I think you have to construct user defined sql to call stored procedure

Anu

Once you made your Job as Muliti Instance job then if you go and open your Sequencer job you will have Invocation Id tab under Job name. This is the place where you need to type in the invocation id for each instance. hope this helps

Senthil

using "col1>col2-1".

What is your where clause in filter stage. What is the datatype for Col1 and Col2?

Anu Click the Job Properties and inside that tick the Allow Multiple Instance box. It's that easy to make a job multiple instance. While running it you need to give InvocationID which identifies each instance ran for that job. For Custom routine you can start looking at the Routines which comes with...

Hi

There is no direct way to disable and enable index from datastage. As Kenneth said you can have SQL script which does all these things and can be called from datastage.

Check the Oracle Reference Guide for syntax to disable and enable index

Senthil

These files are created under Datastage Project folder in your OS.
(ie ..//Ascential/DataStage/Projects/ProjectName/RT_SC367/OshExecuter.sh )

Thanks