DSXchange

Not to talk up another product, but in Informaticas director, if your job fails, you simply click on the job and hit restart (or something like that). Informatica keeps a log of exactly what it has and has not committed to the Database as well as the data being processed. Recovery requires little to...

It has been available with Informatica PowerCenter/PowerMart for a few years. If someone know how to do this with DS I would be very interested as well! "Ravindra Y Nagaraj" To: Subject: Restart the job from the last commit point 12/11/2002 08:51 PM Please respond to datastage-users Hi all, I have w...

Sorry, not this list, it was Tools4DataStage Forum. ----- Original Message ----- From: "Ray Wurlod" Date: Thu, 12 Dec 2002 22:26:18 +1000 To: "Nilotpal Roy" Subject: Re: Urgent help needed - Calling stored procedures in Datastage with In and Out parameter > I have already replied to this question vi...

Number of rows on a link from DSGetLinkInfo() function. DSGetJobInfo() can return a list of active stage names, and DSGetStageInfo() can return a list of links connected to that stage. Rows per second by dividing the number of rows by the number of seconds since stage start (best done in the parent ...

This is a topic for an orphaned message.

I have already replied to this question via the list. I believe you need SQLBindCol() rather than SQLBindParameter() for the output argument. As a general rule I do not respond to enquiries sent to my personal email address, unless you are engaging my consulting services (that is, in exchange for pa...

Hi, How can we retrive the number of rows processing in each link, and the time of processing rows/second ? regrads Rui Soares Rui Miguel Soares NOVABASE - Business Intelligence Mail : Rui.Soares@Novabase.PT Tel (NB) : 351 21 383 65 92 Tlm : 351 96 347 08 40 Fax : 351 213 836 309 -----Original Messa...

Hi Ray, We will try to use the DSGETxxx function, to get the log information. I think if we access to the hashed ( RT_CONFIGnnn, RT_LOGnnn, RT_STATUSnnn ) we maybe not have all informtion of DS job, and we also have to get first the jobhandle. regrads Rui Soares Rui Miguel Soares NOVABASE - Business...

Youve been able to do this since version 1.0, but you have to design it that way, which typically involves an appropriate staging area (e.g. a temporary table or a sequential file), from which you load the real table. Some have implemented another mechanism, whereby they keep track of the row count ...

Interesting word, "disponibilizated"; I am guessing you mean generated. The run time information is stored in three hashed files for which metadata are not published by Ascential. These hashed files (one set for each job name) are: RT_CONFIGnnn run-time configuration RT_LOGnnn job log (metadata avai...

Hi ppl, Actually we are working, in an repository where we can have all information about the execution of our DS jobs. How can we get this information ? regards Rui Soares Rui Miguel Soares NOVABASE - Business Intelligence Mail : Rui.Soares@Novabase.PT Tel (NB) : 351 21 383 65 92 Tlm : 351 96 347 0...

Which version of DataStage ? Kasia At 17:43 10/12/2002, you wrote: >Hi, > >We ran in to a problem in our project. We had a load run 2 days ago. We >create around 7 hash files using job1 and then use those hash files as >lookups in job2. At that time the load ran as expected. > >We had to do a reload...

Hi Gurus, I was wondering if someone has connected successfully to an Ingress database on UNIX before without the use of the I-Way adapter pack? I know that the I-Way (EDA/SQL) connectors exist that allows the connection, but unfortunately I do not have access to these. Is there a different method t...

Hi all, I have worked extensively with Datastage 4.2. I wanted to know whether in the new versions 5.2 or 6 is there a way if say i have comitted some 1,00,000 rows after which some error occurs and the job gets aborted , so the next time if i restart the job would start from 1,00,000 row onwards an...

Before you even attempt to do that, read the end user license agreement (EULA) for XP, in which you are forbidden to install any software that lacks official Microsoft approbation. -- __________________________________________________________ Sign-up for your own FREE Personalized E-mail at Mail.com...