DSXchange

Does the behaviour change is you set APT_DISABLE_COMBINATION to "true" at the job level?
You might also dump the score to see if one of the two copy stages is not being optmized away.

As far as I know, you can only do that in Server jobs. For Parallel jobs, just use the row generator stage (perhaps with a dummy column).

If your maximum value in Col2 is known and a small amount, then a simple Transform stage with multiple outputs for each iteration value followed by a funnel would be sufficient.

Ray, I think the humor in your Japanese text is going to be lost on almost everyone here - but I liked it

Assuming that the string will always have at least one zero:

Complex Flat File - term originating from COBOL, where multiple record types and a variable length array ("OCCURS DEPENDING ON") make for potentially complicated file structures Sequential File - the "classic" flat text file. File Set - A DataStage construct which can only be re...

Is the output also varchar? If so, Right( '00':Field(In.String,'-',1),2):'-':Field(In.String,'-',2,2) might do what you want. Field(In.String,'-',1) takes everything from the beginning of the string to the first '-', i.e. "1" in your example '00':"1" makes a string "001"...

There is no magic solution possible. If the UTF-8 (I assume that was a typo in your original post) character is not mapped to the Unicode counterpart then it can't be represented. Some of your choices are: - use UTF-8 everywhere to avoid conversion to Unicode - Ignore the warning - Convert these cha...

Ray is asking you to execute "dsjob -lprojects" or "dsjob -ljobs" to see if that works.

I disagree about the best practice of importing uncompiled jobs.

Most production environments I have used and know don't have a c++ compiler installed.

If you plan on comparing all fields you can use a CDC stage to at least detect which rows are new/deleted/changed given a key. I've used this type of generic job often, but all I want to know is if there is a difference, not which columns have changed. If you really need to compute which of the colu...

Can you do a successful "view data" on the reference source stage? The error shows that what you've declared in the job and what is being delivered by the stage are not the same.

I haven't seen that. I'm on IE8 and IE9

Have you identified the 2 keys that work in the old version but don't in the new?

Do you know what changed in either DataStage or Oracle between the time it worked and the time it stopped working?

Also, can you execute the insert logic from a SQL tool (e.g Toad or the like) to see if the error is also present there?