DSXchange

Has anyone used DB2Connect in a Unix hosted Analysis Server, instead of the supplied Data Direct ODBC drivers? I want to connect to a mainframe DB2, and can do this using the Data Direct ODBC drivers. However there are 3 advantages I can think of in using DB2Connect: 1) It requires me to buddy up to...

Kumar_s: Thanks for the reply. Sorry it took so long to get back. The syntax I was using within the transformer was fine - there were no red indicators on any of the columns, nor a yellow exclamation mark on the transformer. Anyway, I figured out the problem. I was trying to do my null handling in t...

Sometimes the line termination character is converted to a field mark (@FM, or Char(254)) as part of being captured. Yup, that's it. Convert(@FM,"",Execute_Command1.$CommandOutput) gives mewhat I need. Thanks. You guys ROCK!!! I had the exact same problem and your Convert fixed it. THANK ...

Our experience is you get marginally better performance using the API stage vs. the ODBC stage. ODBC also won't do an automatic failover, so your jobs stop functioning if your mainframe suddenly loses an LPAR, whereas DB2Connect can support high availability. Probably the nicest thing about the API ...

We use the DB2 API stage in a parallel canvas to connect to mainframe DB2. Underneath the covers we use DB2Connect as our middleware for DB2 API stages. Whenever a new database instance is added, the DB2Connect folks have to create/bind packages (for both mainframe and DB2 UDB on Unix). So I would i...

I've got a very similar error happening on one of my jobs right now. Funny thing is that I'm not using any constraints. The job had compiled and run successfully, until I changed one field so it was converting Null values. After that it wouldn't compile, and when I reverted the column back to the wa...

Is this file created by this job, or is it created upstream by a different job? Maybe the upstream job had problems and thus why it isn't there? Or perhaps your /tmp is full and/or not enough available space to write said file? If /tmp is mounted to a SAN disk, you could "df -k" to find ou...

Hi, There's an interesting post from one of IBM's employees on the ProfileStage forum over at ADN on this subject. Being a newbie to dsxchange, I'm not sure if it's "legal" to copy the ADN content over to here?? The gist is that basically there's a DLL version conflict with the Perl65.dll ...