DSXchange

Check Tools > Options in Director. This is where the default limit may be set.

No. Use separate Data Set stages and run them into a Funnel stage.

That answer IS for parallel jobs. Most of the stage types mentioned in my answer only exist in parallel jobs.

Server job. ODBC stage using user-defined SQL on the reference input to a Transformer stage. Use the LIKE operator in the user-defined SQL.

Yes, the ODBC stage is the correct one. A couple of tips ("gotchas"): (1) Excel worksheets are presented by the driver as system tables so, when importing table definitions, you must check the "include system tables" box. (2) Worksheet must be in columnar form with column heading...

I'm about to embark on integration of SubVersion, though I don't know what "brand" the SubVersion server is (just started at new gig). We're using Tortoise as the client - but who doesn't? So, sometime in the near future, we have to configure the interface between Information Server Manage...

Out of exasperation, I tried a server job using the old, steam-powered ODBC stage and succeeded in loading the table with no warnings apart from non-fatal "informational message returned from database" about microseconds being truncated from the timestamp. Alas, the whole plan was to creat...

Using ODBC connector to write into MySQL table. mysql> describe OLAS_ERRORS; +----------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+---------------+------+-----+---------+-------+ | ERR_DATE | datetime | YES | | NULL | | | ERR_ID | var...

Where is svYear getting its value from? (You might also ask yourself how a VarChar(4) could have five characters.)

Double check your expression and stage variable data types.

Wrong. Separate images are loaded for each link. So if you have three links referring to the same Data Set, you get three copies of it in memory. Note that using shared memory for Entire partitioning in an SMP architecture applies to each reference link - you still get one copy (in shared memory thi...

Day of week:

Can't you simply cross-mount, and set APT_ORCHHOME (and maybe other environment variables) on each machine?

There is no way of which I am aware to have stages on the job design area that are not included in the flow of execution. If you need to save them, perhaps during iterative development, park them in a temporary job or shared container.

This is the tool used by the Concierge service. The motivation for the service was to ensure that the tool was being used correctly, and to provide feedback to IBM about how people were attempting to use it.

I understand that the Concierge service will remain available for a little while.

I believe (at 8.5 anyway) that when you load a Data Connection object into the Connector you get the actual "as defined" values from the Data Connection rather than parameters. You can then go and replace these with parameter references, even from the Parameter Set associated with the Data...