DSXchange

Yes. Use the 'Trigger Column' option which will cause the output to spool to a new filename every time the value in that field changes. Ensure that it changes every 2000 records.

Right, they didn't want the physical characters "slash n" but rather what that stands for - a 'newline'. And it means different things on different systems as you've just found: for UNIX a LF, for DOS a CR/LF pair, etc.

Perhaps a little much, but a Wiki on the subject:

http://en.wikipedia.org/wiki/Newline

Well... that was certainly one of your questions. I'm sure someone could review it, but it would need to be someone intimately familiar with hashed files, one of the Old Guard here.

As to whether they would have the time or be so inclined, I cannot say.

In other words, the exact same function.

kum_d, you already have two threads on this subject - do we really need a third? Not to mention the fact it is considered poor form to jump on the end of someone else's just-barely-related post.

My requirement is i need to decompress the previous months file only i.e Jul07.gz in the current mnoth.also to decompress aug07.gz in the month of september When it's August and it's time for your job to run and the 'previous months file' is Jul07.gz - is that file the most recent file? Or could Au...

Why not ask IBM that question? I'm sure they'd be happy to discuss that with you and your company.

-craig

I've been through this in the past. A Google search for that message turns up tons of people having the same problem and zero in the way of answers. Typical response? "Your file isn't really compressed". Umm, yes it is - I just gzipped it. [sigh] Gunzip does support decompression from stdin, but you...

-.4 ? Sorry, couldn't help myself. Mostly, things are broken in 7.1 that they fixed in 7.5. Plus anything new in that version will be missing, which is mostly Sequence job related from what I recall. Snipped from the readme: Terminate Activity Looping Support Extra Activity variables Expression Sup...

So, build it on a Windows server for eventual consumption by Linux? You shouldn't have to do anything special, just tick the Line Termination option for 'UNIX Style' and then if you don't want one on the last line enable the 'Omit last new-line' option as well. Shouldn't be any more difficult than t...

Not sure why you get 1907 rather than 2007, but here's what is in the docs: For a date, the format components are: %dd two digit day %mm two digit month %yy two digit year (from 1900) %year_cutoffyy two digit year from year_cutoff (e.g. %2000yy) %yyyy four digit year %ddd three digit day of the year...

Read what I wrote again.

Why not just StringToDate() with the proper mask?

Why not just go with the trunc_zero default? You won't have any 'fractional digits' until after the call to StringToDecimal when you divide that result by 100.

ray.wurlod wrote:Do your metadata practices extend to maintaining the Dependencies grid in the job properties?

Umm... yah... everyone does that, right?