DSXchange

I'm not at DB/2 right now, but what does "select min(length(TRIM(addr1))) from schema.tablename " return?

ratikmishra1 wrote:... Am I missing something?

Nope, I did. How about declaring DB/2 synonyms for the columns that use reserved words?

Convert the SQL to custom SQL and add the double quotes.

You have set up your aggregator so that it expects the incoming data to be sorted but your data is actually not sorted in that order, thus the error.
You either need to ensure that your source file is sorted (the best and most efficient option) or to change the aggregator.

Could you tell us what your configuration is like, perhaps post your APT_CONFIG file and note if you are using a networked PX system? Also, if you create a simple job with just a single column generator writing to a sequential stage /dev/null do you get the same error? It also helps debugging if you...

Craig - a good example of the old "one-two" teamwork approach to DSXchange :D

Giri - I think you've managed to break the record about giving the least amount of information about your problem in 2 posts - What are you doing in the aggregator? - When is the job aborting : immediately at the start or after processing some or many records? - if you use a dummy input file with ju...

Welcome to DSXchange. You will find that you getter better responses if you post in the correct category. The error looks like a server job error message from the Aggregator stage, is that correct? - Does this error occur right away or after some period? - if you do a "reset" of the job you will get...

I recommended "LOGTO UV" and not "LOGTO <project>". The UNLOCK verb does not exist in the projects.

Make sure you are logged in as the administrator and do a "LOGTO UV" before you issue the command. This command is not present in any but the master account's VOC.

Did you use a TRIM() on both the WRITE and on the LOOKUP side? You could check whether the keys have embedded blanks by writing a quickie job to output the hashed file key plus the result of the derivation "LEN(In.KEY)=LEN(TRIM(In.KEY))" to see if any are equal to "0". Also, are you using a compound...

I am using this in the Derivation for the stage variables KeyMgtGetNextValue('SEQ') -- svSEQ KeyMgtGetNextValue('SEQ1') -- svSEQ1 and using the stage variables for assigning the surrogate keys. My question is in the derivation where you use the stage variables are you certain that you haven't dropp...

Sorry, I just realized that this was a PX question, in which case neither hashed files nor the KeyMgt works.

In PX this is even easier, since you actually have a surrogate key stage to take care of this for you!

How busy is your machine? Is this error limited to just one job or any/all PX jobs? Does this happen every time or just occasionally?

calling the stage variables SEQ, and SEQ1 in the transform by KeyMgtGetNextValue('SEQ'), KeyMgtGetNextValue('SEQ1')... (I have posted this Above as well...) Please note that this is NOT what I was referring to. The stage variables are set to the appropriate value, but you assign them in a DERIVATIO...