DSXchange

Sequential File stage to read (import) the data using comma as the field delimiter (this is a Format property). Sequential File stage to write (export) the data using pipe as the field delimiter (again on the Format tab). Voila! You have already posted about handling of nested quote characters, so I...

No. You need to profile each record type separately. If there are fields that are common to different record types and you want to profile all of those, you need to assemble them into a single place, such as a temporary table.

Not without a hack. I haven't found anything in custom reports that gets at this information - have you?

Clearing the logs does not relinquish automatically allocated table space. There are DB2 utilities for recovering table space. (Ask your DB2 DBA which are the preferred utilities at your site.)

There is no single table that contains this information - each job has its own status in its own table. However you could create a routine or dsjob script that cycles through all job names and reports the status of each, perhaps with a filter of 3 or 96 built in there somewhere. In theory you should...

OK, use a message handler to demote the warning to informational. This is a message that is unlikely to impact your processing of data.

The alert message is telling you that there can only be one field called col2 on the output, but you have one on each input. The message is informing you which one was used and which one was not used (dropped). If you want to preserve both, you need to name them differently on the inputs. Make sure,...

In a type D record, is "xml file" on the same line as the other fields? Does "xml file" include line terminator(s)?

Could it be that the server name is dsqs and you have mis-transcribed the port number (which is actually 31538)?

This is a query, or report. It is not the type of task an ETL should be asked to perform. There IS a solution, using stage variables. Even without sorting, remember the highest and second highest value thus far processed and, downstream of the Transformer stage, limit output to the last row containi...

Connector stages have a common interface and do funky things with Java and XML under the covers. Enterprise stages are specific to database, do not have a consistent look and feel, and use the database client software more directly. Connector stages are newer than Enterprise stages. Connector stages...

There is no automatic extension: I use ".rmp" as a personal convention. The range map is only used when Range partitioning is specified. Thus you can not "read a Data Set with a range map" unless the data were written to that Data Set using Range partitioning and the same range m...

I read that you want to incorporate the functionality of First_JOB into Second_JOB. It is unlikely that what you want to do is possible; this will, of course, depend on what First_JOB actually does. Please let us know what First_JOB does. If First_JOB retrieves a value from a database table, for exa...

... or just an inner join on empno and sal once the max has been determined in the Aggregator stage.