DSXchange

lakNAR - he doesn't want to use a transform stage...

In this case the input to the shared container is one of 80 or so DB2 tables so we can't simple get the schema or column names. I've opened up a MKS support question but if that comes back negative I'll have to bite the bullet and add the list of columns to the parameters or create and use schema fi...

What database are you connecting to? I don't recall the particulars of ODBC connectors and how the parameters need to be passed. If you replace your custom query with something simple like "SELECT COUNT(*) FROM MyTable;" does that work as expected?

Questions like this worry me. Either they are interview questions (which bothers me in any case) or someone is looking for a complicated solution to a simple problem. The transform stage would easily do this using @INROWNUM or, if parallel processing is being done, by @PARTITIONNUM + ( @NUMPARTITION...

Also, we should know what the conditions are for each link out of the original job.

Filter stage.

My problem is that I have a shared container that uses runtime column propagation (what does that have to do with named pipes, you ask?) and it receives rows with 4 column names that are known and used for processing and an indeterminate number of other columns. I want to compute a single CRC32 or s...

I wanted to ensure that what the op was referring to was, indeed, the DB statistics package which, if I recall correctly, shouldn't be run in parallel but does have some concurrent option.

Routines can be run concurrently. What sort of a function is "gather_schema_stats" (is it a DataStage BASIC function, or a database function, or something else)? Does the RA1 function take 13 seconds to run?

Doing it in a transform stage is the simplest way. You could write your own c++ buildop to perform this conversion but it would be a lot more work than using the transform stage.

You don't necessarily need to reboot your server (although it does give you a clean machine), you can use normal methods to kill those dsapi_slave processes. If no users are logged in and nothing is running, the Windows 2003 command line command of taskkill should do the trick.

Many people have installed 8.1 on LINUX to date.

What exactly is your problem?

I think I've used WinZip to uncompress the file, and just tested with my local compression tool at work, WinRAR. The single element files in the .isx file are in XML format and I haven't tried to import them but if you decide to give it a go please post your results to this thread so that others mig...

-- please ignore this post, I was answering in PX-Mode and not in server mode -- Turn on "$APT_PRINT_SCHEMAS" and examine that entry in the directory log after a run. This will show you where your actual runtime metadata differs from what you expect. Notably with DB2 you can declare the co...

If the target is just one table, then as Sainath has already stated it makes the most sense to put all the data into the table and then change the queries to ones appropriate for user queries of type 1, 2 or 3.