DSXchange

Welcome aboard. A Search for the exact error message would reveal that others have seen in before. Is the job is a runnable state? "Records rejected" is an entirely different question and, as phrased, too vague to answer. There are squillions of reasons why records might be rejected, not l...

In version 8 server jobs have to run (on the principal node) in the parallel execution environment, so there is a deal of conversion of data types that needs to be achieved. I suspect what you're seeing is something to do with this, but you really need to involve your official support provider to ve...

Probably. For testing purposes can you output three extra columns that contain "Y" if the field is null and "N" otherwise to see what's consistent? Not sure what your CONVERT is trying to achieve, perhaps leave that out of the mix also, or convert all mark characters to "pri...

Think about it. NULL in any operation (including concatenation) must return NULL.

Now re-think what you want to get out of this expression and post that specification.

Welcome aboard. Please strive for a professional standard of written English on DSXchange; this assists those participants whose first language is not English. If you really mean TX (transformation extender) installation, please post in the TX forum. This is an entirely different product and, indeed...

If the problem is resolved, as you have marked it, the custom is to make a post indicating exactly how it was resolved. This will assist future searchers.

This is unrelated to the original question. If you have a new question please begin a new thread.

Quote the non-pattern elements (literal text) in the pattern expression. SSELECT DS_JOBS WITH F3 = "xxx" OR F3 LIKE "'xxx\'..." No need for a full Wurlod here; just read about pattern matching in RetrieVe in the UniVerse manual for that language. Or you could use DataStage/SQL. S...

i been working since more than 24 hrs so......brain not working... :idea: Never do that. ETL developer is a job that requires immense attention to detail. You can not achieve the same if fatigued. No correspondence will be entered into concerning this advice, deadlines or any of the other artificia...

1. A Sequencer does nothing but make an Any/All decision based on when its inputs have fired. The term you need is Sequence. 2. Job sequences do not process records AT ALL. Therefore your requirement for a sequence to process 50 records is moot. Please re-think your requirement, re-specify and post ...

Without seeing your job design and, in particular, the preserve partitioning settings of each stage, it is impossible to comment cogently.

As Craig has already told you more than once, you need a valid job handle. This part of the code is generating your error. JobName = "srcDlyCalcTxns_LN" *BatchName = DSGetJobInfo(DSJ.ME, DSJ.JOBNAME) BatchName = DSGetJobInfo(JobName, DSJ.ERRNONE) You must attach the job (assigning a job ha...

Not possible within a single job. See solution in my previous post.

In an after job subroutine use DSGetLinkInfo() to determine whether any rows were sent to the target file. If the row count is zero delete the file and (optionally) set the ErrorCode argument of the subroutine to a non-zero value, which has the effect of aborting the job. But I don't believe you nee...