DSXchange

Your "using an API" means that this is not a DataStage question. You can use DataStage stages to select from views. Simply import the view definition as you would a table definition, and use it the same way. The only difference in operation is that you must wait - as would any other client - for the...

Use a Failed trigger to detect failure of the first job.

Use a Routine activity (or Command activity or maybe even a Nested Condition) to determine whether the conditions related to the file and its name are satisfied.

On the basis of that, determine whether to run the second job.

You were in the $DSHOME/bin directory. You should NEVER answer Y to this question.

You need to cd to a project directory before executing this command.

Also, get into the habit of preferring dssh (or ds) to uv. The uv command will be going away one day.

What is the impact on your model of a 20-minute refresh being triggered by the button being clicked every minute? What is the impact if there are 400 browsers connecting through the portal and each of them clicks the button? Perhaps the DataStage process needs to set a flag that the web portal can r...

Change your selection method from "user-defined SQL" to "call stored procedure". Make sure that you have imported the stored procedure definition. Make sure also that your job design specifies the correct number and type of columns, as expected by the stored procedure definition.

CSV is, of course, a variable-width format, so DataStage merrily makes use of that fact. If you want to prove that errors can occur, change to a fixed width format; the column width in the text file is determined by the Display Width property of a column definition (not the SQL data type). You will ...

You would never need to reinstall, only to clear the log file that had become corrupted by an attempt to exceed 2GB. Writing all those entries will, of course, slow your throughput, but they will not otherwise "impact the UniVerse". Ideally, you can change your metadata within DataStage after it's b...

Yes I can. No there isn't.

However, there's no reason not to create a DataStage job that uses QualityStage stage type to invoke whatever it is you're doing in QS, and this you can start with the dsjob command.

Not necessarily.

If you scroll to the right in the Columns grid of the Sequential File stage, you will find the ability to inform the stage that a column may contain terminator characters, and thereby incorporate the ability to handle them gracefully.

The document that describes the APIs for communicating with the RTI services is supplied when the RTI Services are purchased. It is called Real Time Integration Services User Guide (DS_RTI_User.pdf), and is accompanied by a technical bulletin called Text Over JMS Binding (RTI_TOJMS.pdf). I put these...

Almost certainly NOT an appropriate use for RTI Services, there's no "real time" requirement, is there?

Its an hourly rate, so i am expecting it to be small...

Have you no ambition?!!

How is the key defined? It is just the two values with no space between?

Use the PX expression editor to construct your expression, rather than assuming that ":" is the concatenation operator.

1.0 There are substantial changes when the major number changes. Probably the biggest change in version 6.0 is that DataStage is no longer built on UniVerse as its engine. There are enhancements to hashed file processing (particularly caching). For a complete list view the readme that accompanies th...

Arnd's post makes the point that you need the generic specification of how you are defining your start and end dates. For example "start date is the first day of the calendar month following the calendar month following the calendar month in which the current date occurs". With such a specification,...