DSXchange

Hello Sounds like your job status got itself out of sync. The recommended fix would be to reset the job (to put it back in a runnable state) and clear the status file (Director->Job->Clear status file). I'd say open the job in Designer and recompile it. It's the only way to be sure [:)] Kind regards...

quote: Originally posted by Ray.Wurlod [br]There's one file in RT_BPxx for each Transformer stage in the job, and possibly one for a job control routine. The name of the actual Transformer stage is a comment, so you could grep for it to identify the particular file you need to examine. Display it in...

quote: Originally posted by Ray.Wurlod [If you're doing this purely to sort the data in the sequential file, why not investigate using either an operating-system sort facility (such as sort on UNIX), or a third party sort utility such as CoSort or SyncSort? (See www.datastagexchange.com for the CoSo...

Hello I am assuming that the partitioning you are talking about is internal database partitioning, which is transparent and abstracted from the query method. The stage adressing a particular table (be it via native methods or ODBC) will issue a SELECT statement. As long as the output of this stateme...

The parameters (Arg1, Arg2, Arg3) are immediately assigned into variables, with no more referenced being made to the Arg... 'variables'.

Unfortunately, that is not the problem.


Kind regards,
Mihai

_________________________
desk direct:+441908448571

Hello all We are experiencing a very obscure random-ish error and we can't see where the problem is. I hope someone can hazard some guesses. We have a DataStage (4.2.1r8) job that reads some data from a sequential file, runs a routine against it then dumps it to a hashed file to deduplicate based on...

Just a warning to you all

I've put my work email address in my Oliver signature and I started getting porn advertising into my inbox overnight.

Take care y'all,
Mihai

_________________________
desk direct:+441908448571

I hope this post doesn't hit the forum twice...

You can also try
cd `/.dshome`
binuv "CT UV.ACCOUNT * -NO.PAGE" | grep "0011"

Kind regards,
Mihai

_________________________
desk direct:+441908448571

If you don't want to/can't bounce the server, telnetting to the engine and issuing the command
UNLOCK ALL
should do the trick.

This should be done carefully, as locks will be dropped by everything (including scheduled jobs that are running at the time, your colleagues, etc).


Kind regards,
Mihai

Here's a wacky idea... If all you need is the encrypted text, schedule the job and look at the scheduler window - you should see the encrypted password, and you can then type that into your parameter file. If you still need the 'elegant' solution, please let me know. Kind regards, Mihai ____________...

While in the ServerEngine directory, do
binuv "LIST UV.ACCOUNTS"
You'll need to process the output. Hope this puts you on the right track.


Mihai

_________________________
desk direct:+441908448571

The only thing you really need to watch out for is if you use UniVerse level reading of the metadata repository (i.e. DS_METADATA, DS_JOBS, DS_ROUTINES,DS_TRANSFORMERS etc). The metadata repository is structured very differently between 5 and 6. Kind regards, Mihai _________________________ desk dir...

Without being able to test this proposed solution, I can't sure I'm 100% on it. I'd look into building a script from DataStage, detailing the file to attach and so on, then invoking the mailer with the script as a parameter. Kind regards, Mihai _________________________ desk direct:+441908448571

Hello

Depends on what kind of validation you require.

Quality Manager is a good tool, albeit pretty old now. Could you qualify what you mean by 'complete data validation'?

Kind regards,
Mihai

_________________________
desk direct:+441908448571

If you are moving files between operating systems, it may be worth making sure the line terminators are what you expect them to be...


Kind regards,
Mihai

_________________________
desk direct:+441908448571