DSXchange

Given that the helper subroutine was DSR_SELECT, check also that the indexing in the Repository is completely up to date. At a time when you have exclusive access to the project, execute DS.REINDEX ALL (from a dssh environment on the server or through the Administrator client Command window). Ray, ...

Hi

Suddenly we started getting the following error in all the projects. Please Help.

Error:


Error calling subroutine: *DataStage*DSR_SELECT (Action=2); check DataStage is set up correctly in project gref300_phII_synch
(Subroutine failed to complete successfully (30107))

Regards
rubu

Thanks Ray.....

Hi


Job1. Load Data To Sequential File S1

Job2. S1-------->Target

While running job Job2, I want to check the source file S1 for data. If there is no row in the file I want to exit the job with Status Success. How it can be done? Please suggest.

Regards
rubu

HI All, Please let me know how to bring down the timing for the job run . To load the data it is taking 4 hr . There are 3 lookup table in the mapping which is haivng 20 lacs of record .The source of the mapping is having 8lacs . There are 8lookups.I have used link partitioner and collector .I have ...

Hello, are you using an Informix stage? (I think the object is drsifx.so (or .sl)) If so, then you are missing the library (it should be in .dshome/ascential/Ascential/DataStage/DSEngine/lib) Was the other project where it functioned on another machine? Arnd, This job was functioning perfectly in a...

Rubu wrote:Hi

While running a job I am getting an error saying drfix.sl file not found. Any idea about what this file is all about.

Initially, i was successfully running the job in diifferent project.

Regards
rubu[/b]

Sorry! The file name is drsfix.sl

Hi

While running a job I am getting an error saying drfix.sl file not found. Any idea about what this file is all about.

Initially, i was successfully running the job in diifferent project.

Regards
rubu[/b]

HI , I am getting an error while compiling any job sequence in my project. Jobs are getting compiled fine, but while compiling any sequence calling these jobs shows the error.. The error is : <JobSeqGenError> <Code>2017</Code> <Desc>XML parser error on input line 0: source='', reason='The system can...

Thanks Dhiraj

I was using 0 row per transaction in <cond4> ODBC and rest were set as 1. But I can not avoid 1 row transaction in cond2 and cond3 as update and insert has to be clubbed.I separated other two links from the 1 row transaction links.... Its running fine...

Regards
Rubu

Hi I have to design a job in such a way that it does different transactions depends on the value of an input code on the same table. Tx-----Tx--<Cond1>------Update |___<Cond2>----{Update+Insert} **same transaction |____<Cond3>---{Update+Insert} **same transaction |____<Cond4>---Insert While running ...

Hi All My requirement is to read a row from a table. Then I want to update it with a new value. But untill I update the row, it should not be updated by any other application....... I think if I can lock the row after reading , untill we update it ..this purpose is served.... OR I can do both the op...

Hi I want to lock a row while reading until I update it in another stage of the same job. The requirement is like this..... I have to read table ABC (col1, col2) where col1 ='xyz' and store col2 in a file. Now, I want to update col2 of ABC table with a value col2 +input1(a number). but my concern is...

Hi We are using a master sequenece to call many other sequences. All dependent sequences are triggered with OK--condition. But while Jobs fails inside CHILD sequence, it still triggers the next sequence, as the Job_Activity stage returns OK--for that seqence. How can I trape only the abort situation...

Thnaks ArndW

I am using v7.1. I suppose I wont be able to use this feature now.

Rubu