DSXchange

What kind of file? You can execute the echo command via DSExecute, or go through the more formal OpenSeq, WriteSeq and CloseSeq statements in DataStage BASIC. Search the forum for a useful routine called OpenSequentialFile().

The rules change in version 8, however. Some (all?) import/export activity becomes unavoidable, due to the different platform.

As I said, same rules as SQL. The Aggregator stage does not have Group Key as a mandatory property.

It will help, as will the -stageinfo and -linkinfo options. To use these effectively in a script you probably also need the -lstages and -llinks options also.

When's the interview?

Use SETFILE in a project to create a VOC pointer. Then issue the CREATE.INDEX command. You can remove the VOC pointer afterwards if you wish.

Nick's opening statement is really misleading. While it is true (in version 7.5 and earlier) to state that there is no benefit to running server jobs in a site where Enterprise Edition is installed and server jobs are licensed, there is also no downside - server jobs run as they have always done. In...

This is a SYNTAX description, not the actual command that you, individually, need to use. You are expected to replace the metasyntactic variables (the parts encased in angle brackets) with your own values. Further, the pipe character in a syntax description indicates an alternative - you must provid...

Specify the "Update action" property as "insert or update" or "update or insert". Look at the View SQL tab. Then revert to user defined SQL and put in the two statements.

Otherwise, include a flag ('U' or 'I') and call a stored procedure that implements your user-defined SQL statements.

Welcome aboard. :D

It works the same way as in SQL - if there's no grouping key you get one row containing the results of the aggregate functions.

So set them in the Sequential File stage. It doesn't really matter; the column collection is a property of the link, not of either stage.

It doesn't fail - you merely get import warnings which, if these are the only ones, can be ignored (or even demoted to informational in this job).

New? 44 posts? Ah well. Open the job properties where you will find a tab called Generated OSH. It's there.

Take a look at the score. DataStage is probably inserting tsort operators that sort on the hash partitioning key. Add Sort stage set to "don't sort (previously sorted)" on the link from the Data Set.

Actually I would like to use Insert or Update function. But now I can give only one function(update or insert) at a time for my user defined sql. So may I know whether I can give both statements(insert & update) to my user defined sql? If I can , may I know what is the command? Your assertion i...