DSXchange

You can only install engine, services and repository tiers on Windows Server 2008, Linux or UNIX. You cannot install these tiers on Windows 7.

The first thing I'd do would be an internet search for SQLSTATE=08506

0x20 is the ASCII code for the space character (32 in decimal). Therefore what you are seeing is correct.

Does not the SQL Server Connector stage have a "bulk load" capability?

This stage type only exists if DataStage engine runs on Windows Server; otherwise you can use the ODBC Connector, but it does not have a bulk load capability.

Let's get the nomenclature right for starters. Is this really a CDC stage, or is it one of Change Capture, Compare or Difference?

The best time to use a Data Connection is always. (Recall that re-use is one of the holy grails of all IT.)

Does the error message identify which column is the problem? If not, you need to check the defined versus in-job metadata for every column. A good wat to do this is to import the table definition afresh, storing it in a different location, and compare the newly-imported table definition against the ...

More information required.
What are you attempting to accomplish?
What results do you expect?
What actual results are you getting?

This link refers to a thread in the "Dads and Grads" forum, one of the special areas available only to premium members. You can obtain a premium membership by following a link from the DSXchange home page.

I suspect that the interviewers were seeking more in-depth knowledge of the DataStage API. In particular, the function DSGetLinkInfo() can retrieve the total row count for the link (DSJ.LINKROWCOUNT) or a list of row counts per instance (node) using DSJ.INSTROWCOUNT.

Text files don't have data types, they only have text. Technically, they can not have NULL. Therefore, all you have to do is to set the NullFieldValue property to the value that represents NULL in each field. And that's a business decision.

am not able to read your reply. It says premium content. To read the entire response from the premium posters you need to get yourself a premium membership (there's a link from the Home page). Premium membership is the funding model of DSXchange; it's how the hosting and bandwidth costs are met. At...

Of course it takes a long time. How long does it take you to read through a 2GB document? And the log has to be sorted. The moral of this story is to purge old entries from job logs regularly. Incidentally, if you can eventually read the log, then it's not corrupted. So it may not yet have reached i...

It's not possible. The scope of a Data Connection is the project.

Why not set the default values of the environment variable parameters to $PROJDEF so that they pick up their value from the project settings?

We use the defaults (Ctrl+Shift+C and Ctrl+Shift+L), which don't conflict with any other applications we use.