Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


If a field is declared as a comp-3 field and if we want to
sort a dataset based on this field, then how will the sort
card be???

e.g- if we want to sort by a field which is defined as a
PIC X(5) then we will mention - sort fields=(1,5,ch,a).
Likewise if a field is defined as PIC S9(10)COMP-3 then in
this case how will the sort field be defined (because in
this case a sign is also involved)???

Answers were Sorted based on User's Feedback



If a field is declared as a comp-3 field and if we want to sort a dataset based on this field, the..

Answer / bramar

Hi Albert,

I have a small doubt in your answer
for S9(10)COMP-3 the size will be 6 bytes
So I think it may be
sort fields=(1,6,PD,A)
Confirme weather my answer is right or wrong
Thanks in advance

Is This Answer Correct ?    14 Yes 2 No

If a field is declared as a comp-3 field and if we want to sort a dataset based on this field, the..

Answer / muttiah

Let's discuss what are all formats we have in sort
X/A - CH
Comp - BI
Comp-3- PD
9 - ZD/CH
So, Here we need to calculate how many bytes does the field
S9(10)comp-3 occupies.
10/2 + 1 = 5 + 1 = 6 bytes
Say field start's @ position 10then the sort command would
be like this..
Sort fields=(10,6,PD,A/D)
Hope this clarifies

Is This Answer Correct ?    9 Yes 0 No

If a field is declared as a comp-3 field and if we want to sort a dataset based on this field, the..

Answer / albert

We have to specify the sort card like below.

Sort fields=(1,5,PD,A) -> PD is packed decimal

Is This Answer Correct ?    12 Yes 6 No

If a field is declared as a comp-3 field and if we want to sort a dataset based on this field, the..

Answer / asish

Yes Bramar is right.
The sort card should be like this
sort fields=(1,6,PD,A)

Is This Answer Correct ?    6 Yes 3 No

If a field is declared as a comp-3 field and if we want to sort a dataset based on this field, the..

Answer / manikandan

yes bramar ur s correct...

s9(10) comp-3 allocate 6 bytes..so sort fields will be

sort fields=(1,6,pd,a)

Is This Answer Correct ?    3 Yes 2 No

If a field is declared as a comp-3 field and if we want to sort a dataset based on this field, the..

Answer / jegadeesan ramu

sort fields=(1,6,a),format=bi

Is This Answer Correct ?    6 Yes 5 No

If a field is declared as a comp-3 field and if we want to sort a dataset based on this field, the..

Answer / y@$w@nth

PIC S9(10)COMP-3

(n+1)/2 i.e (10+1)/2 11/2 =6(it fill follow round approach
if the result is in decimals)

so comp-3 allocates 6 bytes and the data inside comp-3 field
is stored in packed decimal format then we have to give

sort fields=(1,6,pd,a)
(or)
sort fields=(1,6,a) format=pd

Is This Answer Correct ?    2 Yes 1 No

If a field is declared as a comp-3 field and if we want to sort a dataset based on this field, the..

Answer / shailesh soni

Sort card for sorting Comp 3 field is
sort fields = (1,6,PD,A)

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More JCL Interview Questions

wht do u mean by internal reader in jcl ? wht is the use of internal reader ?

1 Answers   Syntel,


What is 'S0C7' abend?

9 Answers  


Is automatic restart possible in jcl?

0 Answers  


COND -> step1 . . step2, Step2, Executes if the CC of step1 is 0. But even if it is NOT 0 and if we dont give COND, will step2 be executed ?

4 Answers   IBM,


How jcl work to handle various input output file operations?

0 Answers  


Can we give TIME = (1440, 59) also ? or is TIME = (1439, 59) is the last one ?

5 Answers   IBM,


how can a gdg base be created in a jcl. What is the difference between empty and scratch parameter while defining/altering gdg base?

0 Answers   IBM,


what is force complete

2 Answers   IBM,


IF WE GIVE COND on step3 then, What does the following mean ? And Just adding to that, All the below COND are VALID as per the specifications. (i) COND = (8,LT,step1,step2) ---(AND/OR ?) (ii) COND = (8,LT,step1,step2, ONLY), (iii) COND = (8,LT,step1,ONLY) will it execute only if this condition is true or only if step1 ABENDS ? (iv) COND = (8,LT,step1,step2,EVEN), (v) COND = (8,LT,step1,EVEN) ?

2 Answers   IBM,


there are 10 steps in jcl how to execute the steps from step2 to step8 only

6 Answers   EDS,


I have a sequential file in which there are 50 records. Now I want to copy all the 50 records in the reverse order into a new file? The last record in the original file should be the first record in the new file. How can I do it?

4 Answers   IBM, TCS,


i am trying to copy a PS file into VSAM file in step2 by using PGM=IDCAMS,COND=(0,LT) and the pS file is getting sorted in the step1. I got the return code 00 for step1 but step2 got flushed. can u please help on this. Below is My JCL. SEPP050 EXEC PGM=SORT,REGION=6144K SYSIN DD DSN=SYSCMN.PROD.CCLIB (F5910BNN), DISP=SHR SYSOUT DD SYSOUT=* SYSUDUMP DD SYSOUT=A SORTIN DD DSN=Z1225BT.F5910EPP.HISOUT, DISP=SHR SORTOUT DD DSN=Z1225BT.F5910EPP.HISOUT.SORTOUT5, DISP= (NEW,CATLG,DELETE),UNIT=DELQ, SPACE=(CYL, (500,500),RLSE), DCB= (RECFM=FB,LRECL=1606,BLKSIZE=16060,BUFNO=15) SORTWK01 DD UNIT=SYSDA,SPACE=(CYL, (1)) SORTWK02 DD UNIT=SYSDA,SPACE=(CYL, (1)) SORTWK03 DD UNIT=SYSDA,SPACE=(CYL, (1)) SORTWK04 DD UNIT=SYSDA,SPACE=(CYL, (1)) SYSIN1 DD UNIT=VIO,SPACE= (80,1) * SEPP060 EXEC PGM=IDCAMS,COND= (0,LT) SYSPRINT DD SYSOUT=* SYSOUT DD SYSOUT=* SYSLIST DD SYSOUT=* *** DD01 DD DSN=Z1225BT.F5910EPP.HISOUT.SORTOUT, // DISP=SHR //*** //DD01O DD DSN=Z1225BT.F5910PHS, // DISP=SHR, // AMP=(AMORG,'BUFND=12,BUFNI=5') //SYSIN DD DSN=SYSCMN.PROD.CCLIB(F5910BBB), // DISP=SHR Output RC for the two steps: SDCBPJ05 SEPP050 00 236 .00 .00 .0 SDCBPJ05 SEPP060 FLUSH 0 .00 .00 .0

3 Answers  


Categories