DSXchange

Yes. You enable collection with Boolean environment variables such as APT_STARTUP_SCRIPT, APT_PM_PLAYER_MEMORY, APT_PM_SHOW_PIDS and so on. RTFM.

In SMP environments they can be used, but best plan is not to because of the performance overheads in translating data between environments (Orchestrate Framework to/from DataStage BASIC). In MPP environments they can only be used on those machines where the full DataStage server is installed. This ...

The orchadmin command has an rm subcommand that can be used to remove a Data Set. Provide it with the Data Set's control file name as its argument. You can not readily purge DataStage logs from the command line without damaging the control records. Use the Director and/or the automatic purge capabil...

Dinesh? Sanjay?

How did you specify the input to and output from your External Filter stage?

Conventionally all client software is installed in C:\Program Files\... The existence of "C:\Program" would manifestly interfere with any search for client software in "C:\Program Files". Not really a Visual Basic problem in this case, you could generate the same problem with Visual C++ or pretty mu...

Use the DataStage Manager or Designer client. They know what to do and, as an added bonus, issue an "are you sure" warning (useful if you've accidentally selected the wrong Category name!).

Always export the project before deleting anything. If you have a backup you won't need it.

At a guess the -selectlist parameter allows you to select which rows will be loaded. The Orchestrate Operators Manual will give you more information.

"Fixed width" and "comma-separated values" are mutually exclusive terms and mutually exclusive technologies. You have one or the other. Require "them" to provide legal delimited files. If the data contains commas, get them to use a different delimiter. Or pre-process the file using a server job. You...

Default values are built-in. You can not prescribe different defaults. You can, of course, override defaults by setting property values.

What do you see in the Peek entries in the job log?

You don't need the Column Generator stage. The Transformer stage can legally generate an output record schema that has more fields than the total number of fields on its input link. Using a Transformer stage means that you could evaluate the current_date() function once (when initializing a stage va...

Check out lookup_int16_from_string() in the Modify stage for small tables, or contemplate using a Lookup stage.

That's the one. :D

Write your own custom stage. Full information can be found in the Parallel Job Advanced Developer's Guide that is part of your standard documentaiton set. Begin by creating a technical specification of exactly what you want to accomplish, before even contemplating creating any code.

I'm sure Walter (our industrious webmaster) monitors this forum also but, just in case, why not post such an enhancement request in the Site/Forum forum?