DSXchange

Not sure ot the answer to your question. However, if you are using AT some systems have an -a option that allows the command to run a SYSTEM. I imagine, therefore, that you would need to have some expanded privileges to be permitted to use AT.

:( WaitForResponse If IsNull(DSXMembers.Reply) Then DSXServerForumThreads<TopOfStack> = gateleys.ThisPost TopOfStack += 1 End Else 'Thanks' End Time zones!!! You post this in the middle of the night and expect instant gratification? That costs megabucks.

You can resize the stage icon to make the larger than usual number of input links easier to draw and clearer to caption and maintain.

After job subroutines are not supported in job sequences. You either need to rewrite it as a transform function, or write a transform function that calls the after job subroutine that you already have, using a CALL statement. The Routine activity in a job sequence can only execute a transform functi...

Make sure that you send it a value (let's say 1) and include a constraint in the WHERE clause that ? = 1

That way, DataStage will have sent one or more rows that will properly trigger the SQL statement.

There's no 'Array List' in the Oracle stage. Another generic interview-like question. There's no "Array List" in ANY stage type, which is what motivated my question. I thought I may have missed something. So I believe we're dealing with a beginner here, who meant to type "Array Size". In which case...

There are no data types - everything is stored as string. Add together the lengths, add one byte per field (the inter-field delimiter) then add fourteen bytes per record storage overhead (or twenty-two bytes per record storage overhead for 64-bit hashed files). In your example, that would be 16 + 2 ...

Even one stage can establish multiple connections. This is how the ODBC Enterprise stage in parallel jobs fakes parallel connections. In server jobs, there will be one connection established per input link (or output link) from the ODBC stage.

Everything at the user interface level in 7.5 is fully supported in 8.x although maybe differently - for example the Manager, DataStage Designer and QualityStage Designer clients are combined into one. The underlying architecture is radically different, the purchasing model is radically different (t...

Magesh_bala wrote:Hi all,

What are different types of transformations available in Datastage..

Thanks
N.Magesh

Anything you can imagine, quantify and code.

Check also that the DB2 instance has been started. You can also get "failed to connect" errors if it has not been started.

Can you not simply emplace a Job activity that executes the master job?

In the Sequential File stage specify a Filter command. The filter command to use is cat file1 file2 file3 file4... (or you could use wildcards if your file names are amenable). The Sequential File stage then reads the output of the cat command.

Only for money.

This is a user community, not a consultancy service. You can hire consultants from the parent company who hosts DSXchange (DCS Strategies) or from some of the independent consultants who post here. You can even hire consulting services from your vendor.

If the VarChar contains a valid number, perform some arithmetic, such as adding zero to it.