DSXchange

/dsexport.exe almost certainly does not exist. You are telling UNIX to look for a file called dsexport.exe in the root file system, and it's almost certainly not located there! I suspect what you meant to type is ./dsexport.exe but, even then, I am concerned about the ".exe" suffix. This i...

I'm not entirely sure that there is an equivalent function. You would have to find it in the DataStage API - perhaps in the dsapi.h header file.

Unlock it in Director (Cleanup Resources) if it's there, otherwise unlock it by disconnecting the Information Server session using Web Console for Information Server.

You can not set job status to "X" - I believe you mean user status. Job status is an integer. There are lots of ways you can manipulate the warnings, but typically it's by building error message strings from components such as link variables, system variables, DataStage macros, return valu...

These problems are not related, and the good news is that you are now connecting successfully.

Your DBA needs to know about the size of the dbf file (and you may need to address the executing user's ulimit values).

200 records in 5 sec. Do the arithmetic. 60,000 records in X sec. X = ? What are your expectations, and why? Is there an ORDER BY clause in the query? What else is the job doing while the clock is running? Do you include the time it takes for DB2CC to connect to the database in your timings? Do you ...

Not possible in Row Generator stage, but you can have a row generator stage generate rows and a Transformer stage generate the mixed values.

I'd use annotations to alert future developers about this potential requirement. Use some stand-out colour, such as royal blue text on sky blue background or bold red text on white background.

The LIKE operator in a Filter stage uses asterisk (*) as a wildcard. It's all explained in the manual. I don't believe there's any single character match available.

Yes: the Performance Analysis tool. It provides precisely this information, as well as information about other resources (e.g. memory, disk).

That is an impossible question for anyone not at your site to answer, which a moment's thought will verify.

The solution involves providing the full pathname, rather than just an entryname, for a file referred to in a #INCLUDE directive.

Link variables, system variables, DataStage macros and your own routines.

That is only true if you match on them. If you match on first initial, every name with the same first initial will be "the same".

Welcome aboard. The easiest way to create a schema file is to save it from a table definition. However, if you know what you are doing, you can create a schema file using any text editor. It would be unusual to use a schema file in a real time job. Real time jobs - at least in my experience - expect...

All you specify is the value ('P'), and direct it to output link #0.