DSXchange

Hi Kim, I had a similar problem in DS version 5.2. Trying to stop an invocation of a job, say 'job1.inv1', I got an error message saying that job 'job1' wasn't running or paused, DSStopJob tried to stop the job without invocation. Ascential delivered a patch file which solved the problem. Kind Regar...

Michael

this doesn't work either. I'm always getting the number of seconds followed by '000'. Seems I'm badly off for HP-UX [:(]!

Stephan

Rob

I tested what I suugested and it didn't work on our system, which runs under HP-UX [B)]. Time() did not deliver fractions of a second. But maybe it's different with other Operating Systems [?].



Stephan

Rob as opposed to the system variable @Time, time() always takes the current time from the server. According to the online help (version 6): The internal time is taken from the server, and is returned as the number of seconds since midnight to the nearest thousandth of a second. After that it should...

You live and learn! (or better: YLAL [:D])

Stephan

Angel

afaik, this can't be done in a sequential file stage. All you can do there to derive a file name is to use job parameters.

Stephan

Only user-defined functions are declared using the 'DSU' prefix! Did you try 'DSX'? What version do you use, I couldn't find SecondsSinceFromTimestamp in DS 5.2?

Stephan

Paul, the gurus all seem to have gone to holiday, so let me try [8D]: I had this kind of message for variables I was using within routines. To avoid the warning, I initialized them, e.g. $R23='' or $R23=0. Maybe you do a conditional initialisation, which is not executed for all of the records proces...

John maybe the function has to be declared (or would you say defined?) before it can be used, e.g. Deffun SecondsSinceFromTimestamp(A1,A2,...) Calling "DSX.SECONDSSINCEFROMTIMESTAMP" In parentheses enumerate as much arguments as the function has, after the Calling clause it is important to...

quote: Originally posted by degraciavg The downside is you'll lose all data that overflows your pre-defined file size. This is recommended if the volume of your data doesn't vary a lot (i.e. significantly increase in volume) on your subsequent runs. Vladimir (and all), will there be a warning or fat...

dlvsrinivas I have no experience with oracle stages, but I would be very surprised if it wasn't possible to form the query using job parameters, as this is a very common in all kind of stages that I use. The main difference is between active stages (e.g. transformer stage, aggregator stage)and passi...

Roy I see links with status 'Starting' when the data is aggregated within a DBMS. As soon as the first row is returned, the status changes to 'Running'. Don't know how to check in Oracle, if the sessions you are killing are still active? In Informix, for example, I could check, whether the query is ...

Kim

always interesting to read this kind of, as it appears to me, old-fashioned code; this one seems to tell me how an entire job can be deleted from a project. But the real question is how to delete an invocation.

Stephan

For portability reasons, I found it sensible to place scripts into subfolders of the project directory, as the utilities executing OS commands or scripts always take the project directory as their working directory. Thus you can always specify the path to your script relative to the project account....

JB,

a couple of ideas are outlined in: http://www.tools4datastage.com/forum/to ... C_ID=84730

Hope this helps!

Stephan