DSXchange

You won't see it in the generated OSH. You will see it in the score.

So it seems you have a working solution.

The only way to call a stored procedure from a server routine is to use BCI functions, and to execute an appropriate SQL statement with them (for example CALL or EXEC).

Not from a script (without being wrapped in an invocation of a DataStage shell).

Using ODBC each worksheet in a workbook is a separate (system) table. Your DSN points to the workbook and you can import table definitions and otherwise work with the individual worksheets as separate tables. The ODBC driver has its own restrictions, mainly that the worksheet be in tabular format an...

RID = Repository ID

The other is a unique identifier of some record somewhere in the Repository database. I have no idea where.

It may be that your credentials to use the suite (and therefore its associated services) are lacking.

tanmaya wrote: I have a restriction on that I cannot create another job for this.

Resist stupid requirements!

What values do the following environment variables in the project have?
APT_COMPILER
APT_COMPILE_OPTIONS
APT_LINKER
APT_LINKER_OPTIONS

Forget about using rows/sec as a metric of "performance". It's largely meaningless. Then answer some of the questions about your environment posed by others earlier. Also, how many nodes were you running on? What was the startup time and run time (reported in the log)? What does the job ac...

Can you try reversing the order of the host names in the hosts file?

To which server do you connect with Administrator client?

How is your DataStage server described in the hosts file?

The first stage variable (svNewId) determines whether it is a new ID value by comparing the ID value in the current row with the ID value in the previous row (which is stored in svPrevId which has not yet been evaluated in the current row). The middle stage variable (svSeq) resets the count to 1 if ...

bollinenik wrote: Is there any way, we can change and alter options at server side or configuration side, which will replicate Grid performance.

No.

Start by disabling operator combination so you can see which stage is actually generating the error. It may not be where you think.

Unless they have visited your site thay can not assert that you have it actually installed. Even if IBM provided a license for it, that does not mean that you have installed it. (However, if you did order it and have the license, you will have to pay for the license.)

There are two aggregation methods - hash and sort. The former builds a hash table in memory containing the result set, the latter relies on sorted input to avoid the need to do so. There is a memory consumption limit for the hash table at which the alert message is triggered. Modulus algorithm is in...