DSXchange

You can certainly use 'characters' in the Case statement of the switch.

For example, try:

CASE = SMITH=0
CASE = JONES=1

Under Options, pick either Drop to drop rows not in the CASE, OUTPUT for sendingdown a reject link, or FAIL to abort.

Actually, they're not. What you have in sequential files are empty fields rather than nulls. ... <sigh> Picky, picky,picky :wink: True, they are empty fields, but when you are processing them into a transformer and writing them out you need to handle them as being null, which is what I believe the ...

Of course null values are possible in text files. As an example, you have a pipe-delimited text file with 4 columns .... you get data like:

1|A|B|C
2||D|E
3|F|G|H

On the second row, you have a null on the second column.

Look at the documentation for the Netezza stage. You must install the Netezza client if you want to use nzload. If you haven't the client installed, you must use the External Table method.

Out of curiosity, have you tried one of the DB2 stages instead of the ODBC Enterprise stage to see if you get the same errors?

I don't think coming up with ways to split the file will accomplish anything other than complicating the job and getting the same results. :roll: The issue the OP has is one of disk space. You can split the file into hundreds of smaller files and it won't matter one iota if you are still writing the...

chulett wrote:what is the right forum to post this question in?

Interview questions????

Have you tried:

SELECT NAME FROM DS_JOBS WHERE CATEGORY = '\coverage_performance';

Make sure you are specifying the correctly spelled category - do:

SELECT DISTINCT CATEGORY FROM DS_JOBS;

Craig has removed the original post, but it was the exact same question. So what's changed?

chulett wrote:Ah... I see Mark was quicker.

Yeah, it must have been the tone of the message made me jump in so fast :D

I think you asked this already in another entry... ... @eostic, that s not the anwser that i expected, if you see any post with answer you can send me the link ...and why should he do that??? You can check your own posts and see that you've asked this before: http://www.dsxchange.com/viewtopic.php?...

In transformer stage, Sort the input Date Column in DESC order and using constraint send out the First Six Rows. If you are running your job in parallel use this in constraint to filter the last 6 months: (((@INROWNUM -1) * @NUMPARTITIONS) + @PARTITIONNUM + 1) <= 6 Hope this helps Huh??? :roll: I t...

Well, here is one way to get your results, though I'd check your resulting file carefully :D . For this, define your YYYYMM column in your sequential file as integer. Create a stage variable - in this example I named it 'CUTOFF'. This is defined as follows: StringToDecimal(DateToString(DateFromDaysS...

You might want to review the docs for Sequences to get a better handle on them, but in answer to your question, yes, it can be done. In your Job Activity stage, on the Triggers tab you can set a Custom conditional expression. In the expression, you can specify the conditions that the next job activi...

Maybe try CURRENT_DATE instead of DATE???