DSXchange

Configuration file is a file, probably in $DSHOME/../Configurations, whose name ends in ".apt" - for example default.apt The current value of the APT_CONFIG_FILE environment variable determines which configuration file is in use. Every parallel job that runs logs a message indicating which configura...

If you were at the Conference or are an IBM employee, then you have access to the site and will know the URL.

If you had asked this question three months ago I would have been able to find it, but have purged old entries from my email inbox since then.

Easiest, to my mind, would be an If..Then..Else based on length, applying the appropriate date format string in each case. If you have "mm/d/yyyy" and "m/dd/yyyy" as well, this may be a four-way test, and a length test would not be sufficient. Since you did not specify these possibilities, I will no...

Your job asks to preserve partitioning. A Sequential File that is writing must collect all partitions into a single stream and therefore can not preserve partitioning. In the stage that precedes (feeds) the Sequential File stage, check the value of the Preserve Partitioning flag. Set it to "Clear". ...

If you are getting "command not found" the problem lies with your PATH environment variable - not SHLIB_PATH, LD_LIBRARY_PATH or anything else. Fix that first. It needs to include $APT_ORCHHOME/bin. Of course, you must have previously set APT_ORCHHOME, or hard code the pathname in PATH. You will als...

The OLE server in question is probably dsobjects.dll. Sometimes Windows just loses a handle to an object; this is typically reported as an OLE Automation error. There's not a whole lot you can do about it, because Windows then closes whatever application was affected by the fault. Further, it's rand...

Read Method is "Specific File".
You can add more than one "File" property.

This is what I meant by multiple File properties.

Look at Appendix A in the Parallel Job Developer's Guide for the data type conversion functions that are available in the Transformer stage. Surely some combination of these will address your question.

You could, as an alternative, use a Modify stage to effect the data type translation.

Rejected rows can be captured on a rejects link and re-parsed using a Column Import stage.

Go to the Columns grid. Select the row in the grid for that column. Right click and choose Edit Row from the menu. Make sure that Nullable = Yes. In the properties tree there is a folder called Nullable. From the available properties to add, choose Null Field Value. Supply 99999999999 as the null fi...

Do you want just job categories, or routine, table definition and other categories as well? If the latter, simply execute similar commands on the other Repository tables and form the UNION. For example SELECT DISTINCT 'Jobs',CATEGORY FMT '60L' FROM DS_JOBS UNION SELECT DISTINCT 'Routines',CATEGORY F...

Search here and at IBM DeveloperWorks - I recall seeing something about bitmaps being left in unusable state but don't have the time to pursue it.

Change your screen resolution or get your eyes checked. It's OK for me (at 1024 x 768), and I'm (probably) older than thee.

Observation: The OP marked the job type as parallel.

From "Code Obfuscation 101":

How can we automize the process of Excel to CSV/TXT conversion, prior to ETL/DataStage process. (with no human intervension) I appreciate your help. Thanks You will need human intervention, at least in the design phase. The designer will need to create a script - it may be a small VBA script, it ma...