DSXchange

Ok... how is this any different than this post you made four days ago? If you still have 'doubts' or questions, I'd suggest you carry on the conversation there, rather than start a whole new fishing expedition and possibly wasting peoples time replying with very similar answers as have already been ...

I think any direct link on the site here may have been invalidated by IBM's recent revamp of that site. Heck, I'm not even sure I can log in there right now. Probably should contact Support and ask them directly.

I try. Not quite up to Wurlod standards where you work. your. way. through. every. new. post, but I try.

Not in a Server job.

Breadcrumbs.

Hard to answer without knowing the exact job design. Does 'n number of times' mean each run was done with the same input data set, or with different data each time? Was the target reset between each run or allowed to accumlate changes? Unless you duplicate the process exactly each time, more than li...

If 'some warnings' on the second run was less than your limit (which defaults to 50 as you've seen in the Director) then no, it should not have 'failed'.

kduke wrote:I take it for granted that most of us disagree with Craig because he is such a trouble maker.

Whaaaaat???

Pot-kettle-black, my friend.

I mean there is no problem with the datafile and the metadata defined both lengths are also same If that was true you wouldn't be seeing this message. At least one of your records is 'short' and runs out of data before you run out metadata so to speak. Since you are dealing with a fixed width file,...

If you read the OCI stage pdf documentation, the difference will become clear. In a nutshell, the stage will generate either a TO_CHAR() or a TO_DATE() function into your sql automagically and the format of the mask will change depending on the datatype and the action. I always stick with Timestamp ...

The substring of the first 19 characters should be fine, there's nothing "wrong" with the timestamp value in the "Attempt to convert" message. Kris asked the key questions... and the answers should be 'Yes', 'Timestamp' and 'Generated' in that order.

I know you are talking Journaled (or Journaling) File System and perhaps everyone else knows this, but... HPUX, AIX, what O/S are you dealing with Michael?

Or 'Stopped'.

Stage variables. Sort your data appropriately and only pass the first five rows when the customer changes.

You can be the captain, and I will draw the chart, sailing into destiny, closer to the heart. Been stuck in my head for something like the last week and I hoped this might exorcise that particular demon. Nope. Ravi, keys provide values for the 'where' clause which is why there really isn't any such...