DSXchange

We both did.

Andrew's not here man.

So... how accurate is your example data? Are you literally looking for just "LFA1" or "VENDOR" or does it not really matter what value the "literal string" contains? Can this requirement boil down to just taking everything after the second "~" in the string? I...

Your file "could not be opened". First two things that come to mind are that it either doesn't exist (which seems unlikely given the 'ls' worked) or you have a permissions issue.

Do u think if the data is filling up while running the job then we have the increase the scratch disk space? Yes, that's one answer. If "too many" jobs are running at the same time then perhaps the answer is to run fewer simultaneously. Otherwise, the standard answer to "how much scr...

Monitor the free space while jobs are running... that's when it is filling up.

Number? These are (I assume) EBCDIC signed overpunch numbers so { and A -> I are positive while } and J -> R are negative. And the stage should handle them just fine from what I recall.

Thanks for posting this, Phil.

Not sure if this requires the Admin Console nowadays but a CLEAR.FILE RT_LOG372 would have corrected the issue as well. Worst case you could run it from the command line.

I'd also be curious what settings you are using in the stage.

Last time I had to do this, I ended up using dsx exports with the tools from Chuck Smith's site. I found them simple to modify to my specific needs, including loading results to tables to make them easily query-able.

As you noted, that would be a question for IBM.

That advice looks familiar.

END marks the end of the CASE statement, it's not a field. :wink: Rather than select the same field three times, smarten up the case statement so it only needs to be cast once: SELECT CASE WHEN SUBSTRING(lc.refno,1,3) IN ('OSB','OSG','PPS') THEN CAST(SO.AMT as FLOAT) ELSE CAST(LC.AMT as FLOAT) END A...

I'm assuming Arnd meant he was looking for some output values... you've haven't posted any samples of what comes out of the CFF stage.

Sorry, but you two need to test the posted code a little better if you think they both return the same result in all cases. Using the MonthFromDate() function is not the correct solution.