DSXchange

This was discussed recently <a href="viewtopic.php?t=118110&highlight=">here</a>.

J.

You're currently looking for a sequence named 'Control_Sequence' ...

and DS_JOBS.NAME = 'Control_Sequence'

In a routine you can execute the call with ... J.

QualityStage is a product now marketed by IBM as part of the Information Server suite. A description of QualityStage can be uncovered using a website called <a href="http://www.google.com">Google</a>. Here's a link to the search result ranking number 1: <a href="http://www-306.ibm.com...

It might help if you told us why you don't / won't / can't use a shell-based solution. An alternative is to construct a DSBasic routine: - Use the system date to construct a filename mask (E.g. MyFile_ DD_MM_YYYY _*) - Take a look at the relevant directory to see if any of today's files exist yet (s...

Using the 'script' approach I outlined previously you can specify your own date format. E.g. DD_MM_YYYY would be ... MyFilename_`date +%d_%m_%Y`.csv What are the criteria for incrementing the version number? Every job run? If so, you could store the value in an environment variable and use a before-...

... need to get that parallel to server class sorted sometime ...

Nope. What's the attraction to the Column Import stage? Don't get me wrong, it's a great stage - It's got a pretty cool icon too! Do you subscribe to the 'transformers are expensive and to be avoided unless absolutely necessary' ethos? Many people do. If you want to avoid a transformer you could try...

That 'procedural programming' approach to the problem would be tackled by sorting by your filename column and using stage variables within a transformer. They are an ideal mechanism comparing neighbouring rows in sorted datasets. You could also create a 'keyChange' column in the preceding sort to id...

However, my output shows that it sometimes doesn't convert it. Is there any pattern to the 'sometimes' when the conversion doesn't happen? What have you determined from trying example data through your rules using the Rules Analyzer? Do you have any other entries in your CLS file involving the clas...

There's nothing destructive about the script, so go ahead and try it - You'll get a helpful usage message: DataStage Automated Backup Routine Based on design by Manoli Krinos Modified by M Ruland to allow iteration through a complete server set of projects Also Modified by T.J. Griesenbrock to utili...

Why do you want to avoid using scripts? Is it because you don't want to have to manage a deliverable asset external to the DataStage environment? Personally, I'd be inclined to develop the script and implement it in an External Target stage. Your script would : - Read from stdin, - Determine the tar...

... but be aware of the following: Attendance is limited to IBM customers and prospects, subject to advanced confirmation from IBM. IBM reserves the right to refuse attendance based on a registrant's status. So, no free lunch for a common-or-garden developer like me. Which is a shame as the <a href=...

I'm sure QAS can fulfill most (if not all) of your requirements. On a previous project I used QAS to "cleanse" the addresses and QualityStage to process the extraneous vanity/cherished information which QAS throws out as 'junk'. When you're trying to get a bill to the desk of an account pa...

Where exactly is it "not accepting" @LOGNAME?

A couple of other factors which *might* influence your decision are: 1. Is the source table partitioned on the relevant keys? 2. What percentage of rows are duplicates? (or are anticipated to be duplicates in the production data) As ever, the 'true' answer will come from trying both with realistic d...