Printing previous date and blank rows

trushant.w · Posted: Thu Sep 26, 2013 5:33 pm

I want to print name of previous month like "Sep 2013" if job run on 1st of October,in my header.
Also i want two blanks rows after my first header,i am already using two headers and two trailer.

vasanthz · Posted: Thu Sep 26, 2013 5:57 pm

Hello,
Pls post

the input file layout,
expected output file sample,
input & output file dataset attributes.
the name of the sort product that you have.

trushant.w · Posted: Thu Sep 26, 2013 7:21 pm

I am using DFSORT

This job will run on 1st of every month.I am already done with the report preparation i just stuck with the header part.I want to print month name and year like "sep 2013" somewhere in header.So my heading will look like below

"Mailbox for EFT transaction on us (&prev-month current year)"

Please advise what keywords shall i use to do this.
Also i want two blank rows after the header to make the report more readable.

dick scherrer · Posted: Thu Sep 26, 2013 9:08 pm

Hello and welcome to the forum,

You will get to what you want more quickly if you post all of the info requested. . .

Please post a sample of your output so far and an example what you want. I believe we understand, but it is so much easier to see with an example.

Skolusu · Posted: Tue Oct 01, 2013 1:23 am

trushant.w,

Use the following. It doesn't matter when you run the job, you will always get the last month.

trushant.w · Posted: Tue Oct 01, 2013 5:23 pm

Hi Skolusu

Thanks for reply!!

But it looks like as i am already using the build function for other calulations this is not getting proper result.
I am unable to print like"Sep 2013" also my other calculation also getting effected.

Bill Woodger · Posted: Tue Oct 01, 2013 5:39 pm

Kolusu has shown you how to turn a file containing a single blank line into the date that you require.

Neither he nor anyone else is looking over your shoulder to see what other code you have.

You are expected to take the working code provided by Kolusu and apply it to your code.

You will need to append (fixed-length data) or prepend (variable-length data) the formatted date to each record.

Firstly, fully understand Kolusu's code.

Secondly, apply it to your existing code so that it causes no upsets.

If you have problems, post your code, sample input, oiutput produced by the sample and output expected.

vasanthz · Posted: Tue Oct 01, 2013 6:44 pm

trushant.w · Posted: Tue Oct 01, 2013 8:19 pm

I am using below code

Bill Woodger · Posted: Tue Oct 01, 2013 9:47 pm

You can't have more than one function on a single IFTHEN. So you can't have BUILD and FINDREP on the same IFTHEN,

If you look at Kolusu's example, he has one WHEN=INIT store the date and another WHEN=INIT to do the FINDREP.

Why don't you use that approach to extend your input records with the date attached to the end of the record, and then specify that position for your date when you do the BUILDs later?

Skolusu · Posted: Tue Oct 01, 2013 10:25 pm

trushant.w,

Use the following code.

trushant.w · Posted: Thu Oct 03, 2013 8:15 pm

Thank you very much Skolusu....

Thanks for your input Bill.
I am now getting the exact report.

But i am unable to understand the significance of BUILD in OUTFIL
I tried without that BUILD in OUTFIL but its not working

Bill Woodger · Posted: Thu Oct 03, 2013 8:39 pm

Well, what it does when you take the BUILD off (and assuming you took off the comma on the previous line) is a very big clue to the reason for having it.

So, what output do you get when you take off the BUILD? Can you work out what those unexpected things are and relate it to the earlier code in the Control Cards?