DSXchange

You can simplify this check by enabling the Create Key Change option in the Sort stage. Then your single stage variable check can be "set the running count to one when the KeyChange column is 1, when it is 0 increment the current count".

Glad that worked. I've seen instances where it works fine without them but many more times where it fails without them so I would include them. Never being sure what the exact rules were, I always erred on the side of caution.

Have you tried including your credentials on the command line - userid and password?

You need to detail for us your job design. Specifically wondering how you are handling any date/time data types - are you reading them as strings and converting them in the Transformer? Doing any validity checks?

Thanks Ernie.

iq_etl wrote:However, I'm not 100% on if I need to create the function or not.

Yes, you do. Here's how to create a Server routine if that's new to you. The entirety of the code needed is in the post that you linked to, there's no need to 'initialize' anything.

Already unlocked...

nagadastagirireddy wrote:But my job is unlocked now, maybe auto unlock has happened.

Answer Arnd's question. Post examples of your extracted DB2 data.

Same basic answer applies. It is your job to put the data in the proper column based on your month rules and the current run date. I don't really see that the fact that it is a "rolling month" is significantly changing what you need to do.

Let's keep your questions in your posts rather than jumping on the end of old ones. Moved this one here: Could anybody please elaborate on How to find the 'lowest' element as the Repetition element? Lowest as in 'deepest'... as in the number of levels down the hierarchy. More of an art than a scienc...

Interesting... if it's already in a decimal data type, what 'possible errors' are we talking about? Precision and scale?

OK... and? Are you still looking for something from us with regards to this issue?

Again, that's a question for your official support provider.

The CHAR() function would not be appropriate here. It "generates an ASCII character from its numeric code value". For example, Char(65) would generate an "A". You haven't been very specific about the nature of your problem - where are these "junk" characters being gener...

How is that a "temporary" fix? What else could you possibly do? You can't put ten gallons in a five gallon bin.