MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How to compare header date and reord date
Goto page 1, 2  Next
 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities
View previous topic :: View next topic  
Author Message
shyamsaravan
Beginner


Joined: 12 May 2010
Posts: 44
Topics: 12
Location: India
PostPosted: Tue May 18, 2010 6:07 am    Post subject: How to compare header date and reord date Reply with quote
mY Input file isFB/LRECL 88 Date Pos in header is 10-17
record is 8-15
Code:

000001 00HEADER 18/05/10
000002 01AEDUNITED ARAB EMIRATESUAE DIRHAM OTHER FOREIGN
000003 01ALLALBANIA ALBANIAN LEK OTHER FOREIGN
000004 01ARAARGENTINA AUSTRAL (OLD) LATIN AMERICA
000005 01ARPARGENTINA PESO (OLD) LATIN AMERICA
000006 01ARSARGENTINA ARGENTINE PESO OTHER FOREIGN
000007 01ATSAUSTRIA SCHILLING EUROPE Y199901
000008 01AUDAUSTRALIA AUSTRALIAN DOLLAR ASIA-PACIFIC
000009 0301FRF1981093000001790000000000000000000000
000010 0301ILS2000093000002485089500000000000000000ZZZ
000011 0310RON2010051700000007203540800000000000000
000012 0301NLG1987033100004907000000000000000000000
000013 0310EUR2010051700003114294612300000000000000
000014 0310BRL2010012800005408778301500000000000000
000015 0310CNY2007041000001292826191600000000000000
000016 0311CYP2007091700023753851420700000000000000
000017 0311RON2010051700022650207182300000000000000
000018 0311EUR2010051700012602000000000000000000000
.
.
042221 99TRAILER 042219 000001 000001 042221



I tried below as the control card
Code:

SORT FIELDS=COPY
INREC IFTHEN=(WHEN=INIT,OVERLAY=(89:C'20')),
IFTHEN=(WHEN=GROUP,BEGIN=(1,2,CH,EQ,C'00'),
PUSH=(91:16,2,13,2,10,2)),
IFTHEN=(WHEN=(1,2,SS,EQ,C'00,99',OR,
1,7,CH,EQ,C'0310EUR',AND,8,8,CH,LT,89,8,CH,OR,
1,7,CH,EQ,C'0310RON',AND,8,8,CH,LT,89,8,CH,OR,
1,7,CH,EQ,C'0311EUR',AND,8,8,CH,LT,89,8,CH,OR,
1,7,CH,EQ,C'0311RON',AND,8,8,CH,LT,89,8,CH),
OVERLAY=(97:SEQNUM,6,ZD))
OUTFIL INCLUDE=(97,1,CH,GT,C' '),IFOUTLEN=88,
IFTHEN=(WHEN=(1,2,ZD,EQ,99),
BUILD=(1,10,11:C'0000002 0000001 000001 ',97,6))
//*


output dispalyed like this
Code:

000001 00HEADER 18/05/10
000002 0310EUR2008112100012602000000000000000000000
000003 0311RON2010051700002948030000000000000000000
000004 0310EUR2006052200012753000000000000000000000
000005 0310RON2010040600003272105520200000000000000
000006 0310RON2010021900003272573226800000000000000
000007 0310EUR2010021100013718000000000000000000000
000008 0310EUR2010051700012909000000000000000000000
000009 0310EUR2010012000014132000000000000000000000
000010 0311RON2009051300003290010000000000000000000
000011 0310EUR2008061300015336000000000000000000000
000012 0310RON2009102700003465921006600000000000000
000013 0311EUR2009041700013078999877600000000000000
000014 0310RON2009100800003449299065400000000000000
000015 0311EUR2009012800013250318608800000000000000
000016 0311RON2010051700002940230000000000000000000
000017 0310EUR2008081400014907000000000000000000000
003167 0310RON2005102000003313374913300000000000000
003168 0310EUR2006020700011973000000000000000000000
003169 0310RON2008062000004248197033600000000000000
003170 0311EUR2010051700014107720385300000000000000
.
.
003171 99TRAILER 0000002 0000001 000001 003171

bUT I NEED BELOW SHOULD BE THE OUTPUT
Code:

000001 00HEADER 18/05/10
000002 0310RON2010051700000007203540800000000000000
000003 0310EUR2010051700003114294612300000000000000
000004 0311RON2010051700022650207182300000000000000
000005 0311EUR2010051700012602000000000000000000000
000006 99TRAILER 000004 000001 000001 000006

For the above code it displayed all records which are all having the date field less than the Header date .
But i need one day prior day record,if not available in the input file means, needs three day prior day record(ie 20100514 date record).

Please any one can help me;

Thanks;
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
PostPosted: Tue May 18, 2010 10:22 am    Post subject: Reply with quote
shyamsaravan,


I am repeating the same answer as I gave on the other board. SORT products do NOT have capability of performing date arithmetic on any date.
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
shyamsaravan
Beginner


Joined: 12 May 2010
Posts: 44
Topics: 12
Location: India
PostPosted: Wed May 19, 2010 3:36 am    Post subject: Reply with quote
oK,,Please let me know any filter code can use for the above code to give a immediate lesser date record only.
Can you clarify any JCL code can do date arithmetic function Question
Back to top
View user's profile Send private message
shyamsaravan
Beginner


Joined: 12 May 2010
Posts: 44
Topics: 12
Location: India
PostPosted: Wed May 19, 2010 8:18 am    Post subject: Reply with quote
My requirement is changed..Now we need to fetch latest 10 earlier prior date records and write to o/p with compare of current date.(No need to consider Header date)
The input file is same as what i mentioned earlier
for Ex if current date is 19th may 2010 means, we have to use the folllowing search key to retieve the records

0310RON20100518--->18th may 2010
0310RON20100517
0310RON20100514
0310RON20100513
0310RON20100512
0310RON20100511
0310RON20100510
0310RON20100507
0310RON20100506
0310RON20100505-->5th may 2010

0310EUR20100518
0310EUR20100517
0310EUR20100514
.
0310EUR20100505


0311RON20100518
0311RON20100517
0311RON20100514
0311RON20100513
.
0311RON20100505

0311EUR20100518
0311EUR20100517
0311EUR20100514
0311EUR20100513
.
0311EUR20100505

So O/p should be

00HEADER 18/05/10
0310RON20100518
0310RON20100517
0310RON20100514--->see here ,the previous two days record missing,bcoz of Sat and Sun
0310RON20100513
0310RON20100512
0310RON20100511
0310RON20100510
0310RON20100507
0310RON20100506
0310RON20100505
0310EUR20100518
0310EUR20100517
0310EUR20100514
0310EUR20100513
0310EUR20100512
0310EUR20100511
0310EUR20100510
0310EUR20100507
0310EUR20100506
0310EUR20100505
0311RON20100518
0311RON20100517
0311RON20100514
0311RON20100513
0311RON20100512
0311RON20100511
0311RON20100510
0311RON20100507
0311RON20100506
0311RON20100505
0311EUR20100518
0311EUR20100517
0311EUR20100514
0311EUR20100513
0311EUR20100512
0311EUR20100511
0311EUR20100510
0311EUR20100507
0311EUR20100506
0311EUR20100505
99TRAILER 000040 00001 00001 000042

so Trailer record should have the following details

000040-->indicates Total no of detail records
000001-->indicates Header record count
000001-->indicates Trailer record count
000042-->indicates Total No of records

Please let me know,if any
Give the solution please....
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
PostPosted: Wed May 19, 2010 10:24 am    Post subject: Reply with quote
shyamsaravan wrote:
My requirement is changed..Now we need to fetch latest 10 earlier prior date records and write to o/p with compare of current date.(No need to consider Header date)


The following will fetch all records which are greater than or equal to current date - 10 days.

for ex: today is may 19th , so minus 10 days gives May 9th , so any record which has a date greater than or equal to may 10 are written to the output file along with the header record. we create the trailer record at the end with counts. Note that counts are only 6 bytes in length. If you have more 999,999 then your counts will be off. so make sure to adjust the length

Code:

//STEP0100 EXEC PGM=SORT                                 
//SYSOUT   DD SYSOUT=*                                   
//SORTIN   DD *                                           
00HEADER 18/05/10                                         
0310RON20100518--->18TH MAY 2010                         
0310RON20100517                                           
0310RON20100514                                           
0310RON20100513                                           
0310RON20100512                                           
0310RON20100511                                           
0310RON20100510                                           
0310RON20100507                                           
0310RON20100506                                           
0310RON20100505-->5TH MAY 2010                           
0310EUR20100518                                           
0310EUR20100517                                           
0310EUR20100514                                           
0310EUR20100505                                           
0311RON20100518                                           
0311RON20100517                                           
0311RON20100514                                           
0311RON20100513                                           
0311RON20100505                                           
0311EUR20100518                                           
0311EUR20100517                                           
0311EUR20100514                                           
0311EUR20100513                                           
0311EUR20100505                                           
//SORTOUT  DD SYSOUT=*                                   
//SYSIN    DD *                                           
  INCLUDE COND=(8,8,CH,GE,DATE1-10,OR,1,2,CH,EQ,C'00')   
  SORT FIELDS=COPY                                       
  OUTFIL REMOVECC,                                       
  TRAILER1=('99TRAILER ',COUNT-1=(M11,LENGTH=6),         
            ' 000001 000001 ',COUNT+1=(M11,LENGTH=6))     
//*

_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
shyamsaravan
Beginner


Joined: 12 May 2010
Posts: 44
Topics: 12
Location: India
PostPosted: Thu May 20, 2010 2:51 am    Post subject: Reply with quote
Code:

//SYSIN  DD *                                                       
  INCLUDE COND=((1,7,CH,EQ,C'0310EUR',AND,8,8,CH,GE,DATE1-10,       
                                                               OR, 
                  1,7,CH,EQ,C'0310RON',AND,8,8,CH,GE,DATE1-10,OR,   
                  1,7,CH,EQ,C'0311EUR',AND,8,8,CH,GE,DATE1-10,OR,   
                  1,7,CH,EQ,C'0311RON',AND,8,8,CH,GE,DATE1-10),     
                                   OR,1,2,CH,EQ,C'00')             
    SORT FIELDS=COPY                                               
    OUTFIL REMOVECC,                                               
    TRAILER1=('99TRAILER ',COUNT-1=(M11,LENGTH=6),                 
              ' 000001 000001 ',COUNT+1=(M11,LENGTH=6))             

Thanks;

Above code is working fine,,but, in case of ,The input file does not have month of May records means,the o/p is not dispalyed anything.
In such a case the o/p should be displayed on previous month(April) 10 days records(ie latest earlier dates record);

Any possible to do that ?..

Thanks in advance
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
PostPosted: Thu May 20, 2010 9:58 am    Post subject: Reply with quote
shyamsaravan wrote:

Above code is working fine,,but, in case of ,The input file does not have month of May records means,the o/p is not dispalyed anything.
In such a case the o/p should be displayed on previous month(April) 10 days records(ie latest earlier dates record);

Any possible to do that ?..

Thanks in advance


what happens if you don't find APRIL records? You need to go back to March? and even if that is NOT found you go back a month again? This seems a never ending loop
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
shyamsaravan
Beginner


Joined: 12 May 2010
Posts: 44
Topics: 12
Location: India
PostPosted: Fri May 21, 2010 1:34 am    Post subject: Reply with quote
Yes,,

You are right,If the april month record also not available means go for march..search will end at 1 st jan 1979 ,and the records not available means it comes termination..

I tried the below coding
Code:

//STEP1 EXEC  PGM=ICEMAN                                     
//SYSOUT    DD  SYSOUT=*                                     
//SORTIN DD DSN=INPUTFILEGDG(0),                           
//          DISP=SHR                                         
//OUT1   DD DSN=NE.EB.OUT1,                           
//            DISP=(OLD,CATLG,DELETE),                       
//            UNIT=SYSDA,SPACE=(TRK,(15,15),RLSE),           
//            DCB=(Z.DUMMYDCB,RECFM=FB,LRECL=88,BLKSIZE=1760)
//*                                                           
//OUT2    DD DSN=NE.EB.OUT2,                           
//            DISP=(OLD,CATLG,DELETE),                       
//            UNIT=SYSDA,SPACE=(TRK,(15,15),RLSE),           
//            DCB=(Z.DUMMYDCB,RECFM=FB,LRECL=88,BLKSIZE=1760)
//*                                                           
//OUT3    DD DSN=NE.EB.OUT3,                           
//            DISP=(OLD,CATLG,DELETE),                       
//            UNIT=SYSDA,SPACE=(TRK,(15,15),RLSE),           
//            DCB=(Z.DUMMYDCB,RECFM=FB,LRECL=88,BLKSIZE=1760)
//*                                                           
//OUT4     DD DSN=NE.EB.OUT4,                         
//            DISP=(OLD,CATLG,DELETE),                       
//            UNIT=SYSDA,SPACE=(TRK,(15,15),RLSE),           
//            DCB=(Z.DUMMYDCB,RECFM=FB,LRECL=88,BLKSIZE=1760)
//*                                                           
//OUT5     DD DSN=NE.EB.OUT5,                           
//            DISP=(OLD,CATLG,DELETE),                         
//            UNIT=SYSDA,SPACE=(TRK,(15,15),RLSE),             
//            DCB=(Z.DUMMYDCB,RECFM=FB,LRECL=88,BLKSIZE=1760) 
//*                                                           
//SYSIN    DD    *                                             
  INCLUDE COND=(1,2,SS,EQ,C'00',OR,                           
                1,7,SS,EQ,C'0310EUR,0310RON,0311EUR,0311RON') 
  SORT FIELDS=(1,7,CH,A,8,8,CH,D)                             
  OUTREC IFTHEN=(WHEN=(1,2,CH,EQ,C'00'),                       
           OVERLAY=(89:SEQNUM,8,ZD)),                         
         IFTHEN=(WHEN=(1,7,CH,EQ,C'0310EUR'),                 
           OVERLAY=(89:SEQNUM,8,ZD)),                         
      IFTHEN=(WHEN=(1,7,CH,EQ,C'0310RON'),                     
        OVERLAY=(89:SEQNUM,8,ZD)),                             
      IFTHEN=(WHEN=(1,7,CH,EQ,C'0311EUR'),                     
        OVERLAY=(89:SEQNUM,8,ZD)),                             
      IFTHEN=(WHEN=(1,7,CH,EQ,C'0311RON'),                     
        OVERLAY=(89:SEQNUM,8,ZD))                             
  OUTFIL FNAMES=OUT1,                                         
     INCLUDE=(1,2,CH,EQ,C'00',AND,89,8,ZD,LE,+1),             
     BUILD=(1,88)                                             
  OUTFIL FNAMES=OUT2,                                         
          INCLUDE=(1,7,CH,EQ,C'0310EUR',AND,89,8,ZD,LE,+10),         
     BUILD=(1,88)                                               
  OUTFIL FNAMES=OUT3,                                           
     INCLUDE=(1,7,CH,EQ,C'0310RON',AND,89,8,ZD,LE,+10),         
     BUILD=(1,88)                                               
  OUTFIL FNAMES=OUT4,                                           
       INCLUDE=(1,7,CH,EQ,C'0311EUR',AND,89,8,ZD,LE,+10),       
       BUILD=(1,88)                                             
    OUTFIL FNAMES=OUT5,                                         
       INCLUDE=(1,7,CH,EQ,C'0311RON',AND,89,8,ZD,LE,+10),       
       BUILD=(1,88)                                             
//*                                                             
//*                                                             
//STEP2 EXEC PGM=SORT                                           
//SYSPRINT DD SYSOUT=*                                         
//SYSOUT DD SYSOUT=*                                           
//SORTIN DD DSN=NE.EB.OUT1,DISP=SHR                     
//        DD DSN=NE.EB.OUT2,DISP=SHR                     
//        DD DSN=NE.EB.OUT3,DISP=SHR                     
//        DD DSN=NE.EB.OUT4,DISP=SHR                     
//        DD DSN=NE.EB.OUT5,DISP=SHR                     
//SORTOUT  DD DSN=NE.EB.EUR(+1),                         
//            DISP=(,CATLG,DELETE),                             
//            UNIT=SYSDA,SPACE=(TRK,(15,15),RLSE),             
//            DCB=(Z.DUMMYDCB,RECFM=FB,LRECL=88,BLKSIZE=1760)   
//*                                                       
//SYSIN  DD *                                             
     SORT FIELDS=COPY                                     
       OUTFIL REMOVECC,                                   
       TRAILER1=('99TRAILER ',COUNT-1=(M11,LENGTH=6),     
                 ' 000001 000001 ',COUNT+1=(M11,LENGTH=6))
//*                           

It is working fine,but i feel too much of complexity,because it is used 5 OUT files and again it is concatenated to last output GDG file.

Any possibility do the code with one output file OR any other logic.

see below the O/P-->it doesnt have month of may records,,so it displayed month of April records,
Code:

00HEADER 30/04/10                             
0310EUR2010043000013315000000000000000000000 
0310EUR2010042900013256000000000000000000000 
0310EUR2010042800013245000000000000000000000 
0310EUR2010042700013290000000000000000000000 
0310EUR2010042600013321000000000000000000000 
0310EUR2010042300013311000000000000000000000 
0310EUR2010042200013339000000000000000000000 
0310EUR2010042100013373000000000000000000000 
0310EUR2010042000013486000000000000000000000 
0310EUR2010041900013432000000000000000000000 
0310RON2010043000003223970944300000000000000 
0310RON2010042900003204254290500000000000000 
0310RON2010042800003201595358900000000000000 
0310RON2010042700003219476744100000000000000 
0310RON2010042600003234979843600000000000000 
0310RON2010042300003227691561500000000000000 
0310RON2010042200003220735947400000000000000 
0310RON2010042100003232535653800000000000000 
0310RON2010042000003251989389900000000000000 
0310RON2010041900003230554620200000000000000 
0311EUR2010043000013326426495800000000000000 
0311EUR2010042900013258132192300000000000000 
0311EUR2010042800013187541171000000000000000 
0311EUR2010042700013322320662500000000000000 
0311EUR2010042600013301675034200000000000000 
0311EUR2010042300013331076422500000000000000 
0311EUR2010042200013349317961500000000000000 
0311EUR2010042100013434357634200000000000000 
0311EUR2010042000013509626353900000000000000 
0311EUR2010041900013435287560000000000000000 
0311RON2010043000003228620000000000000000000 
0311RON2010042900003204000000000000000000000 
0311RON2010042800003183090000000000000000000 
0311RON2010042700003229970000000000000000000 
0311RON2010042600003229660000000000000000000 
0311RON2010042300003229040000000000000000000 
0311RON2010042200003223620000000000000000000 
0311RON2010042100003249180000000000000000000 
0311RON2010042000003256590000000000000000000 
0311RON2010041900003229870000000000000000000 
99TRAILER 000040 000001 000001 000042             

Please help me in anyway..
Thanks;
Back to top
View user's profile Send private message
Anuj Dhawan
Intermediate


Joined: 19 Jul 2007
Posts: 298
Topics: 7
Location: Mumbai,India
PostPosted: Fri May 21, 2010 5:02 am    Post subject: Reply with quote
Please learn to use BBcode, it's very tough to comprehend the code you posted without that.
_________________
Regards,
Anuj
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
PostPosted: Fri May 21, 2010 7:39 am    Post subject: Reply with quote
shyamsaravan wrote:
You are right,If the april month record also not available means go for march..search will end at 1 st jan 1979 ,and the records not available means it comes termination..
It is working fine,but i feel too much of complexity,because it is used 5 OUT files and again it is concatenated to last output GDG file.

Any possibility do the code with one output file OR any other logic.

see below the O/P-->it doesnt have month of may records,,so it displayed month of April records, Please help me in anyway..



shyamsaravan,

Is this a different job? The job you have shown,is not comparing the records to the current date or header date bonk

you are just picking up the first 10 records in each group.bonk It can be done much easily if that is indeed the real requirement. You just wasted 4 days with poor description. Post detailed information on what you're trying to accomplish. Do not make people guess what you mean. This will give you a much better chance of getting a good answer to your question.

Learn to use BBCODE which will have columns aligned and easy to read. Read here

http://www.mvsforums.com/helpboards/viewtopic.php?p=19031#19031
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
shyamsaravan
Beginner


Joined: 12 May 2010
Posts: 44
Topics: 12
Location: India
PostPosted: Mon May 24, 2010 4:09 am    Post subject: Reply with quote
Pl excuse,,yes my requirement is changed...they feel it is complicated to get a records with compare of header date..so they wants only latest 10 days records which are available in the input file,Pl dont mind on Header date..

I feel the above coding is much lengthier(i used 5 output files),So that i need lesser coding for the same requirement,

Please guide me on the requirement.

I dont find any BBCODE info available at the mentioned link.

Thanks; Confused
Shyamsaravan
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
PostPosted: Mon May 24, 2010 10:33 am    Post subject: Reply with quote
shyamsaravan wrote:
Pl excuse,,yes my requirement is changed...they feel it is complicated to get a records with compare of header date..so they wants only latest 10 days records which are available in the input file,Pl dont mind on Header date..


wow . I wish every complicated request gets changed to an easier one. Anyway use the following control cards which would give you the desired results.

Code:

//SYSIN    DD *                                               
  INCLUDE COND=(1,2,SS,EQ,C'00',OR,                           
                1,7,SS,EQ,C'0310EUR,0310RON,0311EUR,0311RON')
  SORT FIELDS=(1,7,CH,A,8,8,CH,D),EQUALS                     
  OUTREC OVERLAY=(89:SEQNUM,8,ZD,RESTART=(1,7))               
  OUTFIL REMOVECC,BUILD=(1,88),INCLUDE=(89,8,ZD,LE,10),       
  TRAILER1=('99TRAILER ',COUNT-1=(M11,LENGTH=6),             
            ' 000001 000001 ',COUNT+1=(M11,LENGTH=6))         
//*


shyamsaravan wrote:
I dont find any BBCODE info available at the mentioned link.


How do you think the code in this thread looks as if it is a mainframe session? It uses the BBCODE code block. Read it once again and understand it
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
shyamsaravan
Beginner


Joined: 12 May 2010
Posts: 44
Topics: 12
Location: India
PostPosted: Tue May 25, 2010 1:55 am    Post subject: Reply with quote
Thank you very much Very Happy

you are a such wonderful person to simplify the complication,,Thanks a lot.

The above code is working fine,it gives good result what i am exactly asking..

Thanks again, Mr. Green

shyamsaravan Smile
Back to top
View user's profile Send private message
shyamsaravan
Beginner


Joined: 12 May 2010
Posts: 44
Topics: 12
Location: India
PostPosted: Tue May 25, 2010 7:45 am    Post subject: Reply with quote
1.Please clarify, why you are using EQUALS in the Sort card for this requirement ?
2.Is it degrade the performance?
3.Without using of EQUALS also,it gives desired output! Please guide me.. Question
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
PostPosted: Tue May 25, 2010 9:13 am    Post subject: Reply with quote
shyamsaravan wrote:
1.Please clarify, why you are using EQUALS in the Sort card for this requirement ?
2.Is it degrade the performance?
3.Without using of EQUALS also,it gives desired output! Please guide me.. Question


Shyamsaravan,

1. Read this

http://www.mvsforums.com/helpboards/viewtopic.php?p=51748#51748

2. EQUALS does have an overhead but depending on how you need the results you can code it or remove it

3. Again read the link I gave you
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities All times are GMT - 5 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group