DSXchange

The format can be whatever you require. But you can not read file name; you can only have one column being read, into the large VarChar. And you will probably still not get what you want; you will get one row for each line terminator in the file. The file name can be obtained from a stage property w...

DataStage imposes no limits.
Some operating systems and some network protocols limit the physical length of a row.
The bigger the rows, the fewer the rows/second (naturally).

The only good option is to use Usage Analysis to determine in which jobs the table definition is used. Re-import the table definition then manually edit the links where that table definition is used, ... Thanks Ray. I would try out Usage Analysis to get a grip of changes that may be needed. Otherwi...

No. DataStage does not change the data. If there are trailing spaces in the data (for example) then they're there.

I suspect you got that error doing View Data. View Data does not work when the read mode is "File Pattern".

Are you setting the funnel mode to Sequential Funnel? If not, what is your setting?

I don't think it's trying to pass it through, I think it's just trying to alert you to the fact that null might be possible, that the default representation of null is "" and that this can't be loaded into a decimal data type so it is therefore using the default value for decimal. If you transfer nu...

If you're running 7.5.1 or later I'd try the single Transformer stage. They did address most of the performance drags in this stage for this release.

Expect a major announcement next Tuesday at the IOD conference.

locale is a UNIX command, so is executed at the UNIX prompt. It merely reports your current O/S locale setting.

In DataStage you can change the locale in the Administrator client by clicking the NLS button.

That depends on whether your target supports DATE data type. What was the data type of this column in the imported table definition?

Run two processes. In the first process count (using an Aggregator stage) the records for each group, and compare these (using a lookup) with the count values in the header file. Generate warnings where there are mismatches. Only proceed to the second job where there were no warnings in the first. T...

chulett wrote:Well, this thread has certainly taken a hard turn off into the bushes.

And 'wrong shape'? Just a extra 'u' thrown in by accident... sorry about that, Chief.

Actually thinking about diff on Kim's shape vs Lara's shape.

Then, clearly, there is something amiss with your derivation. Please post the derivation expression you used.

A fully-qualified pathname begins with a slash character (on UNIX) or a drive letter or backslash character (on Windows).
A relative pathname does not begin thus, and is considered to be relative to the current attach point.