DSXchange

What are the specifications you are using to effect the conversions? If you use explicit functions you should be able to eliminate the warnings.

Probably some nested If..Then..Else expressions.

Oracle is...
... different

Another example of why it is so important to post the complete error message - we would have been able to see which stage generated it.

What are DB2 error codes -1476 and -911 ?

Generate a copy of Measure_Column. Group by key and by Copy_of_Measure_Column

How would YOU know how to parse those? Clearly it's unreasonable to expect DataStage to be able to! If the columns were quoted, however, it would be rather simpler. You can pre-check the record if you read it as a single VarChar field, then count the number of delimiter characters. Reject the record...

Multiple OCCURS are fine, as the record structure remains fixed.

It doesn't look good at all. You need to UPDATE VOC SET F3='/u01/csunProjects/epmdvl/CS90_CSW91/hash_file_dir/D_HASH_DTTM_PS_ITEM_LINE_SF' WHERE @ID = 'HASH_DTTM_PS_ITEM_LINE_SF' ; (That is, you got the D_ in the wrong place.) UPDATE is DataStage/SQL (akin to UniVerse/SQL or UniSQL in UniData). You ...

What we (Zenith Solutions) do is adopt a special link naming convention for those times when total rows out <> total rows in, and the routines have the capacity built-in to recognise such a link name and not react to a link row count mismatch.

You're not, but it seems you've found a web page that no-one else uses. I use the link from Information Center, but that page doesn't have a visitors counter on it.

Nothing exists. You have to design it in yourself. Some sites have developed row count reconciliation routines, but they don't report at the individual row level. You'd need to design something into the actual job flow itself.

OK, in that scenario "write-through cache" is similar to "staging area". The target Data Set is used as a holding area for data to be loaded into a table that is also being used as a source by the job, to avoid locking issues. Data Sets are ideal for this role because, unlike oth...

Are you sure you used TimestampToString() function?

qt_ky wrote:Out of curiosity, I checked the IBM web site

You thrill-seeking devil, you!