DSXchange

Hi Jason, Ive had a similar experience with a never ending job run. What I do is select... clear job status for that particular job and then recompile it. Regards, Doris Jason Mulvin wrote: > I am currently using DataStage v4.2 on NT 4.0 with an Oracle DB > running on Unix. > > Is anyone aware of a ...

I am currently using DataStage v4.2 on NT 4.0 with an Oracle DB running on Unix. Is anyone aware of a issues with batches that never complete? I have a batch that was running a job that ran for way too long, but when the last job in the batch completed, the batch showed as still running. Attempts to...

Hi All My latent Cient want to know how to connect to I-ISAM directly. is It possible to connect directly. This Client(Motors Company) uses Kerridge ERP (K-ISAM) as sales system. If you have any infor. please gimme it. Regards Daehwan Kim (whatcanido@lexken.co.kr 82-2-3453-0320 ext 303 ) S.E Team Da...

If youre using the RedBrick stage, by the time errors occur its really out of DataStages control. Only if you automatically execute the rb_tmu command can you, in the same job, inspect the contents of the tmu error file, probably in an after stage or after job routine, or possibly in the controlling...

PERFORM is documented in the BASIC manual. ENV is a UniVerse command; get to a UniVerse prompt (perhaps in the Administrator client) and type HELP ENVIRONMENT, or get the User Reference manual from the web. Unfortunately, the only display at this level displays all variables. However, by using the C...

Yes. For example to set the FRED environment variable to FLINTSTONE: PERFORM "ENV SET FRED=FLINTSTONE" To clear the environment variable: PERFORM "ENV CLEAR FRED" -----Original Message----- From: Peter Oates [mailto:Peter.Oates@macquarie.com] Sent: Tuesday, 23 October 2001 13:19 To: datastage-users@...

Is it possible to access Unix environment variables from within the DS Job Control script ?


regards,
Peter Oates

Lisa, Could you post more details with your questions, please. In such a general scenario as this, for example, it is hard to guess what kind of reject constraint would cause a job to slow "drastically." The folks will be better able to help if you give us the data examples and the code you tried th...

Alessio, the biggest problem we had was the quote character.....we had to set the quote character to 000 rather than leave it blank because when you export import jobs to move them from one place to another you get the quote character back...so a job that works in test did not work in prod..... Apar...

This is a topic for an orphaned message.

Hi All, Quick question.....When I last used DS I always updated dimension table information in place with inserts and updates because the files coming out of the transformer were different files when the key was found and when the key was not found. When the dimension record was not found we generat...

Is there a way to prevent a job from aborting in Director when it receives a fatal error such as the one below?? Ive researched the data and there may be 1-2 occurrences in 50,000 records and it slows the job down drastically to code around it. The data is bogus and it is ok for the job to skip over...

What database are you running on (writing to)? Is it possible that you have the DB set to commit by default on a connection end? jason -----Original Message----- From: Dirk Moolman [mailto:dirkm@reach.co.za] Sent: Monday, October 22, 2001 9:51 AM To: Datastage List Subject: Transaction logging In a ...

Hi All, Is it possible to load data from text file to SQL Server 2000 using SQLBLK7 plug-in? Ive tried and recieved the following error: BulkLoad.gn_fd_currency: Internal error: Failed to IRowsetFastLoad interface. BulkLoad.gn_fd_currency: Failed to prepare fast load session. Best regards,Alexandre ...

Oh yes, I am using version 4.2, which does not have the "On OK / On Fail" options -----Original Message----- From: Dirk Moolman [mailto:dirkm@reach.co.za] Sent: Monday, October 22, 2001 3:51 PM To: Datastage List Subject: Transaction logging In a job I have, the "Rows per transaction" is set to 0, w...