DSXchange

Hi everyone, Could someone tell me what the command line would be to run a DataStage job from a Cron job? Thanks in advance for your help. Carol Gorrie ________________________________________ North of Scotland Water Authority m Telephone: 0845 743 7437 NOTE: Privileged/Confidential Information may ...

Hi all, I had posted a query about reading data in .rtf files and with some assistance from Lamont have been able to accomplish the same. Here how i did it. Hopefully it may be if interest to someone. I created the DataStage jobs to load the .rtf data in the database...and it was done all in DataSta...

This is a topic for an orphaned message.

Dan It works backwards. When write cache is enabled then it does not overwrite a previous key. So a) and b) are backwards. c) has a constraint where CompareLastRow(key) key. d) constraint is CompareLastRow(key) = key. Thanks Kim. -----Original Message----- From: Dan Paolini [mailto:daniel.paolini@oi...

This is a topic for an orphaned message.

Most of the message is normal. The only different thing is the PRINTER memory segment removed. What this means is that some DataStage process before it finished in an errant manner. For historic reasons, every DataStage process keeps track of certain elements of its current state resident in a share...

Phil, As David says, calling DSLogInfo/Warn/Abort when testing in Manager puts the text Message to be logged is... and the log message into the Result cell of the Test grid. Double click on the Result cell and all will be revealed. If you think about it, this must be so. When you test a routine, its...

Peter, Axcel is an abbreviation of Accelerator (somehow?), and as you rightly point out is multiple job instances at present. I believe that it will be enhanced in version 5.1.1 (now called 5.2) which is due for release shortly. Im not sure I can reveal whats going to be in it at this time, but be a...

I figured that out. I just hadnt replied yet. Thanks for the response and the ideas? Phil. -----Original Message----- From: John Campbell [mailto:john@jcbase.freeserve.co.uk] Sent: Friday, November 23, 2001 9:12 PM To: datastage-users@oliver.com Subject: RE: DataStage Routines Phil, As David says, c...

The test program is written on the fly by DataStage Engine, using the naming convention TSTroutine.B This source code is created in the DSU_BP file, and deleted once executed. You could test for its existence, perhaps with a Trans() function, for example if the name of your routine is Phil42 If Tran...

But it does work when being tested from Manager Double click on the result value in Manager to look at everything the routine would have logged. The thing I find a problem in testing a routine from Manager is when it calls DSGetJobInfo etc. -----Original Message----- From: Phil Walker [mailto:philw@...

Can you connect with the Administrator client (which connects initially to the "UV project"? If so, the Administrator client will display a list of known projects (it does for you what Johns post suggests). Ensure that your project name is in that list. Beware, too, that project names are case sensi...

Does anyone know how I can check if routine is being executed from a job or from DS Manager test function? I want to be able to write a routine such that if the routine is being tested the error handling does not write a message to a job log - as it wouldnt work.

Phil

John, Thanks for those options. Im on DS 5.1 and Ive now managed to construct a Routime that calls Sybase: isql. My main reason for not creating a DS Job is the overhead required in calling/waiting for a job vs a DS routine (very fast). On another subject: Whats this Accelerator Pack ? Is it the sam...

Luc/Adele, Hello again. I would suggest that you contact your Ascential Helpdesk for this - they can give you an immediate response. Im not sure what the error number means! A couple of things though: Is this Unix or NT? Do you get the message when you attempt to select a project from the drop-down ...