DSXchange

Go to Ascential's web site and do a search for "benchmark". There are some success stories (with big data volumes) that you can use to support your pro-DataStage case.

YOUR particular offset is configured in your profile. There is no mechanism for changing it automatically. (That's actually quite a difficult task to achieve in a world wide sense - for example some states in Australia do have summer time while others don't.)

Revert to status view in Director. What is the status of the job? The usual reason for the Clear Log facility being disabled is that, rightly or wrongly, the status of the job remains recorded as Running. If this is the case, and you are totally certain that the jobs are no longer running, then you ...

ExecDOS installs on UNIX servers.

FUNCTION GenerateOutputLine(Arg1, Arg2, Arg3, Arg4, Counter) * Generates as many tab-delimited output lines as Counter indicates EQUATE TAB To Char(9) If System(91) Then Terminator = Char(10):Char(13) ; * DOS End Else Terminator = Char(10) ; * UNIX En...

Yes, you use a Transformer, but almost certainly use a Routine to generate the single output column based on the input columns, which are arguments to the routines. If you just wanted empty rows you could use Str(Stuff:Char(10),Counter) but for anything much more complex a Routine is indicated. The ...

Good catch!

Last time I heard, Mukund was in the UK, so might only need NLS to display the correct currency symbol!

That's actually quite a different problem, but solved fairly easily using an intermediate text file and generating the same number of line terminators as there are in your count column. You need to be careful to specify no formatting in the Inputs tab for the Sequential File stage; when you read fro...

Your SQL is wrong. What you should be doing is SELECT COUNT(TableB.SID) FROM TableA,TableB where TableA.SID = TableB.SID (there are two table names in the FROM clause, and the counted column is exactly specified, which can be more efficient than * in certain databases). Build your SQL in wha...

If ExecDOS is not there, either someone has removed it (some people believe it's dangerous to permit access to the operating system), or your DataStage server is incompletely installed.

Log in as qsadm and start the qsrtmngr manually. Detailed instructions are in the manual. This will allow you to determine whether this is your only problem. If it is, get your system admininstrator to configure the qsrtmngr to start automatically when all the other DataStage processes start.

You can also use DDL. This has the side-effect of building the dictionary (as does Chuck's approach).

You might investigate the cause of such a large stdout, so that you can address the cause and avoid its recurrence.

Provided you're not using too many routines, the memory address is cached, so that you really only incur the cost of loading the subroutine code ("snapping the link") once. Unless the machine is overloaded, the likelihood of actually finding the routine still in memory for the next row is very high....

If the routine is connecting to DataStage database (hashed files, UV tables) then you can use BEGIN TRANSACTION, COMMIT, ROLLBACK and END TRANSACTION as you seek to do. If you are accessing other databases via the BASIC SQL Client Interface (BCI), then you use SQLSetConnectOptions() to specify manua...