Answer / sreedevi

external sort is done by jcl using dfsort,icetool utilities
internal sort is done by cobol sort

Answer / vikash chawla

Sort is a utility using which we can sort a VSAM/ NON-VSAM
file in a perticuler order i.e Assending or Discendin.

Internal Sort - It is a process to sort the file using JCL
External Sort - It is a process to sort the file using
cobol program .

Sort Utilites

sort INREC " select the fields then sort then"
sort OUTREC " sort the fields then select the records out
of them

Include " include a perticuler record
omit " except the perticuler record"

Sum fields = NONE to elemintae duplicate records

sort fields = (start postion , number of characters , type,
order )

what modification we need to do in jcl if we use sort in cobol? I mean whether we need to include tempary file used for sorting in assign statement?

3 Answers   TCS,

---

hi is there any means of deletin a record from a ps usin cobol not using jcl?eg if i am reading a record and if some condition is matched tat particular record must be deletd fom the ps

5 Answers   iNautix,

---

I want ALL ERROR codes in VSAM

3 Answers   American Express, TCS,

---

what are the error codes in cobol, db2, cics, vsam , and jcl

2 Answers   TetraSoft,

---

Difference between ps, esds

3 Answers  

---

I have one column say 'X' defined as VARCHAR Can anyone tell me What are the different ways to update this column thru COBOL-DB2 program?

5 Answers  

---

SSRange is used to do a range check on which of the Following. SUBSCRIPT,INDEX,REFERENCE MODIFICATION,Run-time option.

3 Answers   Lehman Brothers,

---

How many times the loop runs here 01 a pic 9(2) value 1. perform para1 until a=10 move 1 to a. stop run. para1: move 10 to a.

5 Answers  

---

How to solve SOC7. I have the cobol coded as below 01 A PIC 9(4). 01 AIN REDEFINES A. 05 AIN1 PIC S9(4) 01 B PIC 9(4)V99. 01 BIN REDEFINES B. 05 BIN1 PIC S9(4)V99. PROCEDURE DIVISION. START-PARA. INITIALIZE A AIN B BIN. ACCEPT A B. DISPLAY 'VALUE OF A=' A. DISPLAY 'VALUE OF B=' B. DISPLAY 'VALUE OF BIN1=' BIN1. DISPLAY 'VALUE OF AIN1=' AIN1. COMPUTE AIN1 = BIN1 - AIN1. DISPLAY 'VALUE OF AIN1=' AIN1. When i'm executing this code i'm getting SOC7 for A = 12 & B=34. Can someone explain SDSF OUTPUT DISPLAY TCOM058R JOB05458 DSID 102 LINE 0 COLUMNS 02- 81 COMMAND INPUT ===> SCROLL ===> CSR ********************************* TOP OF DATA ********************************** VALUE OF A=12 VALUE OF B=34 VALUE OF BIN1=34 VALUE OF AIN1=12 CEE3207S The system detected a data exception (System Completion Code=0C7). From compile unit PROG1 at entry point PROG1 at statement 29 at compile +000004CE at address 00007ECE. Please address how to solve this issue Thanks in advance.

1 Answers  

---

What should be the sorting order for SEARCH ALL?

5 Answers  

---

write a program to eliminate duplicate records in a input file and send them to output file.

2 Answers   IBM,

---

I know my query will return more than one row but I don't want cursor what should I do?

1 Answers  

---