DSXchange

You don't get a choice. Some operating systems implement semaphores using mutex locks. End of story. OK, you're still allowed to hate them, but your only alternative is to change operating systems, an expensive undertaking!

Certification is designed to sort out the sheep from the goats. Not passing the certification exam may not be a bar to employment. What it will provide, however, is a "report card" of areas where the candidate is strong and areas where the candidate is weak (related to the exam's objectives, as docu...

Sounds like you are populating your reference data set (from the dimension table) with both current and non-current rows. Check that you only load current rows.

Maybe this thread belongs in the General forum, rather than in the server forum with a job type of "parallel"?

Could it be "punched card"?

It does work. I've done this with over 80 tests. I use intermediate stage variables to concatenate each group of 10 or so, then concatenate those together, just to make things more manageable.

That construction is so useful I store it as a reuseable component, a Transform called FinalDelimitedSubstring.

You can edit your uvodbc.config file to set MAXFETCHBUFFSIZE to a value larger than its default of 8192 bytes. The UniVerse/SQL syntax requires a SUBSTRING function. SELECT SUBSTRING(FULL.TEXT FROM 1 FOR 1000) FROM RT_LOG217; Or you can override the format. SELECT FULL.TEXT FMT 'L#1000' FROM...

Buried among all the jocularity above is my answer.

The Join stage in mainframe jobs does a pairwise join so, to join five tables you would need to cascade four Join stages.

Probably it's easier to specify the join in the DB2 stage.

The Schedule tab in Administrator does not schedule jobs. Rather it sets up a Windows user ID under which scheduled jobs will be executed (by AT) and allows the user ID/password combination for that user ID to be tested.

Max rows per partition = 10 means 20 rows on two partitions.

It's your design - specifically this property - that is limiting the number of rows output from the stage.

You have taken a sample!

Schedule is disabled because you are not logged in as dsadm or root or because you are not connected to a Windows-based server. Mainframe is disabled because you do not have a licence for mainframe jobs. Parallel is disabled because you do not have a licence for parallel jobs or, if you do, because ...

The Parallel Job Developer's Guide chapter on Modify stage gives full information about constructing specifications, though it has some of the functions incorrect (for example NullToValue should be handle_null). Ask your support provider to obtain the Orchestrate Operators manual (and the other Orch...

None at all. Send an email to the Hawk beta team, like your beta testing agreement requires you to do.

It's called Runtime Column Propagation and you get it in parallel jobs only.

Check your .odbc.ini file in the $DSHOME directory and the uvodbc.config file in the project for existence of an entry for this DSN.