DSXchange

Your DATA are wrong. Misaligned. You have to fix this.

Do you have appropriate table privileges in the new instance?

Warnings are there for a reason. They either indicate something bad has occurred, or something about which you need to be alerted has occurred. Eschew the approach of disabling warnings. Design your jobs so that they do not generate warnings in the first place. Then any warning that does appear is i...

Look what Code tags can do! Except for the Code tags, this is copy/paste from your original. column ------SQLType --------Length-------------Field Properties ------------------------------------------------------------------------ col1 --------char----------------2 -------------------position=0 col2...

Set the Width property (rather than the Max_Width property) for col3. And for col8, even though that's unrelated to the exact problem reported.

Are you constructing a Build stage?

That's the only place of which I'm aware in which "transfer" is used.

In this context it means to transfer (move) data from a structure (typically an input port) to an output port.

After changing the setting back in uvconfig, did you re-run uvregen command?

Because you're doing a lookup on something that is not unique in the DB2 table - that is, neither the primary key nor a column that has a UNIQUE constraint. DISTINCT does not help if there are other columns in the lookup query; these would have to all be identical to reduce the count. The DB2 stage ...

Hi all, Maybe someone can help answer this question. Is it possible to return data from a Hash File where the keys are equal except the date where it is less than or equal to the date of the source? Or is my only solution to use bind variables and use user defined sql? Thanks Not using a Hashed Fil...

Note that the answer given relates to DB2. Some databases do automatically create an index on the primary key (though not on its individual columns).

All primary key columns in DB2 tables must be NOT NULL.

Re-design the target table. Or use a dedicated default value.

What does it really mean that you want to make part of a key unknown? Ponder on that for a while.

No.

(having some transmission difficulties here - moderator, please remove)

No.

Nothing in help touch was informative - the only options relate to the date/time stamps.

Maybe you could follow your touch command with an attrib command to clear the system file attribute.

An "all terms" search for month difference dates returned 17 hits. Somewhere in there lies an answer.