DSXchange

Had T42 used the adjectives "simple" and "complex" to describe SQL perhaps his meaning would have been clearer.

He suggests that you use simple, straightfoward SQL statements to extract data, and let DataStage EE worry about the partitioning of those data.

You're really getting into this UniVerse/SQL now, aren't you? :D

The current job is already "attached" and can be accessed by other functions using DSJ.ME as the job handle. It is not necessary, and is probably catastrophic, to invoke DSDetachJob() for the current job.

You will, at the very least, get warnings if you try to install a 4 CPU licence on an 8 CPU machine. It may not install at all, depending on the version number.

Using the UserStatus was what I had in mind. Other than that, you could write values to a file and use an ExecuteCommand activity to retrieve them, or something similar to that. The "UserStatus area" is, in fact, disk based (which is why you can get at it after the job finishes), so any file-based a...

Once upon a time BCP also worked with SQL Server. Is there no longer a bulk loader? I'd be surprised if this were the case.

Do you want this in real time or afterwards? When does timing start and when does it end? For example do you want to include or to exclude the time taken to start the jobs, to establish connection to and to disconnect from the database? Search the forum for "rows/sec". It really is a meaningless met...

Who says MS SQL Server stored procedures aren't supported in DataStage? Can you import the stored procedures? That's ultimately the test of whether they're supported - you can read about what the rules for supported/unsupported are in the Server Job Developer's Guide - it's about whether there are o...

Who says you need MQ Series? MQ Series is a queue-based IBM messaging protocol; DataStage - via appropriate plug-in (which only means "optionally installed") stage types - has the ability to read messages from a queue and to write messages to a queue. Typically these messages will contain rows of da...

You can install DataStage EE on a machine with fewer CPUs than you have licensed. The others will show up as "spare" in the Adminstrator's licensing information. I do not know about installing two DataStage servers on one machine, even on different logical partitions. Apart from any legal questions ...

That's not supported functionality. Whatever you do with DataStage, ultimately you're processing rows and columns. What you might like to do is to import the table definition. When the list of tables appears, select just one table. Then the Details and View Data buttons are enabled. Use Details to g...

Depending on the DataStage version, click the Cleanup project button in the Administrator client, or execute options 2 and 4 from the DS.TOOLS menu on the server.

Welcome aboard! :D

Can you post the exact expression you're using?

The only supported way is through Repository view in Manager or Designer. You can delete a whole category at a time. The repository should not need cleaning up, unless you interrupt the deletion process. An unsupported way is to delete records from DS_ROUTINES; the routine name is the key value, but...

They're not officially documented - though quite a few have been revealed over the years on this Forum.

Beware that substantial changes are afoot in the repository structure in the next major release.