DSXchange

The plug-in that reads from IDOCs, of course. Part of the SAP Extract PACK. Ask your vendor, or browse the IBM web site.

Don't set Max_Width. Set Width.

Investigate the Record Delimiter String property (rather than the Record Delimiter property). Specify as \r\n

Each row in a Data Set (or File Set) carries an additional four columns of management information totalling 80 bytes; the partition number, the partition count, the ordinal number of the record within the partition and the record ID. It could have been more effecient, if the column information is s...

Only the ones without an RMM stage.

Check that touch worked before attempting the FTP.

Your requirement is not clear. Your words and your example do not match. Please document the algorithm by which 1 generates 1,2; 2 generates 3,4; 3 generates 4,6 (note that 4 is repeated); 4 generates 7,NULL and 5,6 and 7 do not generate anything. It would appear (if the result for 3 is a typo, and ...

Your file uses two characters as the line terminator. Either use the Record Delimiter String property set to \r\n or define a fourth Char(1) column (to read the \r) and specify UNIX newline as the Record Delimiter property.

However you approach it you are going to have to edit the table definition in your repository to include the new column. Optionally you might set the "incomplete column" property as suggested. Before doing that, select the table definition and perform a Usage Analysis to identify all the jobs that u...

You have posted this question in the ProfileStage forum. ProfileStage typically uses ODBC as its connection modality. If you can provide an ODBC driver for extracting the data, then the answer is yes. Otherwise I suggest that you pre-process the data, as kumar_s suggests, using DataStage or any of t...

Hi All, Can any body will suggest me ow to add enviornment variable in datastage parallel job. Do you mean: (a) add a new environment variable that a job can use as a job parameter? (b) add an environment variable to a job as a job parameter? (c) change the value of an environment variable while a ...

We do, and they're still legal. But only banks are forced to accept them. Also, you can write a cheque for two cents. I once had to write a cheque for three cents because of a stupidly programmed computer.

Or from the Administering DataStage class now offered by IBM. Beware, however, that this class is very heavily about parallel jobs.

But easier to change databases subsequently when some smooth-talking sales person convinces management that dBase IV is the only database you'll ever need and it's cheap as well.

I add my two cents worth to Craig's making a grand total of four cents' worth advocation the "avoid unnecessary double action" design.