DSXchange

Hi, Im designing a job with a stage ORAOCI containing the following query: select substr(a.idrbes,1,15) idrbes, a.idrf, substr(a.idvpdwh,2,6) idvpdwh from ODS.tctrt a, ODS.tproduto b where a.idvpdwh=b.idvpdwh and b.ctdrpb=35 The option View Data doesnt return any error. Running the job Ive got the f...

It is interesting. I dont have an answer. But when I find why our jobs (in one project) randomly started abending 4 days ago with a similar message from an ODBC stage, Ill let you know. We intend to trace the execution and see if this sheds some light on the problem. Don Bradshaw AM Corporation Limi...

The EASIEST way is to use before-job and after-job subroutines to execute a shell command such as echo `date` >> #filename# The BEST way is to write DataStage job control code including WriteSeq statements. -----Original Message----- From: Roosa, Mike [mailto:Mike.Roosa@getronics.com] Sent: Wednesda...

On you on a Unix box or NT box? When DataStage runs a machine out of memory you get abnormal terminations. Check this out.

I have several jobs to export data from universe and insert it into SQL Server. I have been asked to write the start and stop time of each job to a text file on the Datastage server so that our applications group and read this text file and see that all the jobs have completed and how long they have...

I have several batch processes set up that run continuously, and have been for approx. 3 months without any change to the job design. Just recently the batch process aborts randomly for different jobs in the batch with the following error message. There is never any more detail than what is listed b...

Hi, we accidentally deleted the directory of a project. We have backups of all the jobs, so now we want re-create the project again with the same name. First I have executed the following command: "delete from UV.ACCOUNT where @ID=PROJDS_MKT_INT" Now I have the following error when Im trying to crea...

To the moderator: Please include my alternate email address ds_user@hotmail.com in the list so that I wont to lose thread while Im away. Another thing, one of the announcements I received before was about a yahoo site that we can visit as well. Please advise me with the address. Correct me if I got ...

This is a topic for an orphaned message.

Here is some food for thought; Technique #1 - assumption is that the header/detail rows have a key relationship Using the complex flat file stage you can have multiple output links. Each link represents a record type and the CFF stage supports variable record lengths if there is a line terminator. T...

Where do you want to put the list? What you want to do is certainly possible in a loop in BASIC, with calls to DSGetProjectInfo and DSGetJobInfo functions. You can declare a dimensioned array or, probably more appropriately, use dynamic arrays. Or write the results into a hashed file or into a seque...

Patricia, there is no facility for most databases to return that information using the generated SQL by DataStage. Your only possibility is to write your own stored procedure to conduct the inserts and updates, and return that information to DataStage to put into the log of the job as an information...

Hello Is there any of you using Ascential Quality Manager please? Ive got couple questions about the product but Ascential support ignores all my e-mails related to it. The release im using is 4.8.1R1. The problems i met: 1) Im trying to define L0 Domain Analysis for tables on Oracle 8i (release 8.1...

When I try to log into Director Im given the error message Run-Time error 6 OverFlow and Im kicked out. Does anyone have any ideas how to correct this?? Lisa --------------------------------------------------------- The sender of this electronic message intends that this e-mail be used exclusively b...

Hello, for better maintenance of our projects I need a list with the status (like director) over all projects with following informations: - project - category - job - status What is the best way to do this? My first effort was reading UV.ACCOUNT -> connect to each project, get a jobhandle and call ...