DSXchange

Thanks for that. Im out of ideas for now. Hopefully the TAR will give rise to something, but you can expect a bit of work following up on requests from Oracle for information, traces etc. I presume it is just a typo in your email, but the insert statement you quoted lists 4 columns but only provides...

Hi David, We are using Oracle 9.2.0.3.0. Query is a user defined query. It is inserting data into a Dimension table. We are using oracle sequence to generate surrogate keys. Otherwise the query is pretty simpler looks like - INSERT INTO TEST_DIM (TEST_ID, PARENT_ID, TEST_CODE, TEST_DSC) VALUES (TEST...

Hi Wim, Ask your DB-Admin. Any other client or software using Oracle on this PC or Server does need this settings too. Wolfgang -----Original Message----- From: Dommelen van W. (Wim) [mailto:Wim.van.Dommelen@NL.Fortis.com] Sent: Monday, July 14, 2003 9:49 AM To: datastage-users@oliver.com Subject: O...

Hi, anyone knows where I can find the setting for ORASID, ORAHOME etc.? Thanks! Wim van Dommelen. -----Oorspronkelijk bericht----- Van: Saliah, Regu (LMRD) [mailto:regu.saliah@DEFRA.GSI.GOV.UK] Verzonden: maandag 14 juli 2003 9:29 Aan: datastage-users@oliver.com Onderwerp: RE: Oracle Error We used t...

We used to get the same error on version 9.1.0.x when we attempted to replace or recompile an object that already existed on the DB. The work around was to drop the object first, but your problem is a different scenario. In our case the problem did go away when we upgraded the Oracle version. Regu. ...

We resolved this off line by working with the JOBSCHEDINSTS and JOBPARAMINSTS records in the RT_CONFIG file for this job. Details were not given on-list because of likely danger in getting it wrong (for which I would not like to be held liable). ----- Original Message ----- From: "Peter Keogh" Date:...

Bruce - any answers to my other questions? ALRT.LOG? Trace files (in the udump directory)? Exact version of Oracle 9i? Ill pre-empt your response on this one. If you are using 9.1.0.x, my simple response is dont. It is not robust enough to run as a production platform. It has too many bugs. You need...

We have Oracle 8i client on the ETL server. The error code was returned by a Insert statement. The table has referential integrity constraints. I searched on Metalink but it donot have any info about this particular error code. Thanks, Bruce --- David Barham wrote: > Sorry Bruce, I should have also ...

What happens if you export the job, delete the job, then import it. Im familiar with 5.1 on Unix but not Windows. On unix, Solaris 7, what appears in the list in the DataStage Directors Scheduler is determined solely by the entries in cron. If you delete the cron entry it disappears from the list in...

Checked using both the AT command and the scheduled tasks on the DataStage server, but the entry is not there, only in DataStage Directors Schedule of jobs. Any other thoughts ? I was hoping that the entry was stored in DataStage somewhere and I could remove it using some command line process. -----...

Thats where the problem arises, though Ray. AT wont show you any tasks that have non-numeric schedule Ids. For example, one of our servers has about a dozen scheduled tasks, but AT shows none. Tasks scheduled with AT will appear in the Scheduled Task list with a name like "At14" where the id with AT...

If that doesnt work, then you can open a DOS window (cmd.exe) and use the AT command there. AT with no options should show all scheduled tasks. You can use the /DELETE switch to remove any scheduled task on the list. AT /? or HELP AT will provide full syntax. ----- Original Message ----- From: David...

DataStage schedules jobs using the AT command (or some equivalent system call, Im not sure). This always generates a numeric schedule id. If you change this scheduled task using the Windows scheduler, the schedule id will no longer be numeric and DataStage can no longer deal with it (as AT can no lo...

I have a entry in the schedule that has become corrupted, and because the schedule Id is now not numeric I cannot remove the job from the schedule. Is there another way of removing an entry from the schedule rather than using the GUI that is more powerful ? Im using DataStage V5.1.0 on Windows 2000....

Here is a process I implemented to accomplish something very much like this, except that I used a flat file instead of a hash file. 1) I stored my Job Parameters in a file in name, value pairs (in the format name=value). 2) I wrote a routine I called GetParameterFromFile. You pass in the file name a...