DSXchange

So that's what it was. The previous guy who set up this server had overridden that value, and the fixpack did not preserve the configuration value. Still a rather unpleasant "feature" of the fixpack, but thanks for setting us straight... Once we changed it from 0x0 to 0x20 everything worke...

We did an upgrade - it must have overwritten the setting... That's bizarre...

We just applied Datstage 8.1 Fixpack 1 on our AIX server and found one rather disheartening bug, and i thought I'd report it here as well. We have some old table definitions in DB2 where the datatype was foolishly set to char instead of varchar, and we haven't honestly gotten around to converting th...

Sorry - I was using cat in my external source stage - I thought external source was the output of a program no? Anyway, is there any settings I should be looking at for this 513 character splitting that's occurring? This product is an extreme exercise in frustration; I would have been done by now if...

Lastly, here's a screenshot of my format settings:

http://imgur.com/rNuYo.png

Just to add, I was looking at my transport environment variables and nothing points to this 513 character splitting. I tried setting $APT_AUTO_TRANSFER_BLOCK_SIZE to true, and I tried increasing the $APT_FILE_IMPORT_BUFFER_SIZE to 4096 and that didn't make a difference either. I've also raised up th...

Same thing - it partitions ever 513 characters...

Hi, I've been following these instructions on how to read in XML data: http://it.toolbox.com/wiki/index.php/Load_XML_files_using_a_DataStage_Parallel_job When I do that the sequential file stage seems to be parsing the XML file into 513 character blocks. When I hit view data on the sequential file s...

I prefer to use mutt :

mutt -a attachment.ext -s subject user@domain.com </dev/null

easy as pie...

That's correct - there's an update for the datadirect odbc drivers, but it only supports MySQL Enterprise because that's all Datadirect was licensed for by MySQL AB. I believe this has to do with the GBL nature of MySQL community edition's APIs, because any derivative work of those APIs would have t...

So here is the email from IBM: I checked with the product managers on DataStage and the drivers, and unfortunately, there is nothing we can do to change this. It is all a matter of licensing. DataDirect's agreement with MySQL only allows for integration/support for the commercial/professional/enterp...

No, that's not the case at all. Many apps we use only need the community version; there is no need to purchase a license for that product. In fact, most apps out there you buy that require MySQL don't actually ship with it because MySQL AB charges a hefty sum for a redistribution license. They fully...

So we've seen some issues with MySQL Support with DS 8.1 - particularly on AIX. I thought I'd at least report to this forum. 1) MySQL 5.3 isn't supported with 8.1 out of the gate. The DataDirect drivers don't recognize 5.3 version as being a valid version greater than 5.1 so you get an error stating...

I've seen this error once - it happened when we started uv as root instead of as dsadm.

run as root
$DSHOME/bin/uv -admin -stop
run as dsadm
$DSHOME/bin/uv -admin -start

See if that fixes it. Check the path in your dsenv file as well and see if that path is included.

Uh, just write a web service that'll execute dsjob shell command with the correct parameters.

Not that big of a deal really...