AIX LENGTH+ 5 + ( n * PRIMARY KEY LENGTH ) Here "n" is the no.of duplicates we want to have. I don't understand this "n" .. how can we decide that no. of duplicates??? Its is the apporximate value that is going to be . 1 members have posted answers.">
![]() Related Questions When calculating the record size for Alternate index(with duplicates) we use ==> AIX LENGTH+ 5 + ( n * PRIMARY KEY LENGTH ) Here "n" is the no.of duplicates we want to have. I don't understand this "n" .. how can we decide that no. of duplicates??? What is the difference between plan & packagewhat is difference between views & joinswhat is db2 stored procedures? how to work it in mainframehow to calculate n th maximum valueif the error code -811 ? how to rectify it?if the error in dead lock how to rectify it?how to read the last record in data file don't know the no.of records?what is the use of profile in Qmf? Read Answers (1) | Asked by : latha View Question | Asked by : Ramanujam Latest Answer : A Temporary VSAM File can be created using the utility IDCAMS. If you want the job to create this file, kindly let me know so that I'll provide you the code too.In order to delete a record from a VSAM File through a JCL, initially sort the VSAM ... Read Answers (1) | Asked by : Harish If i'm trying to populate an Array with some data, it is giving ABENDU4038.The Array - element (record) size is 70 and the Array Size is 99,999. It is Abending after populating some 10,074 elements How do I use SORT to copy duplicates in a Dataset to another Latest Answer : Use XSUM parameter in SortSyntax for XSUM - SUM FIELDS=NONE,XSUM in the Sort card, and a DDNAME SORTXSUM to define the file for XSUM. ... How to get the mismatch data in dataset during comprision of two datasets of different length? Latest Answer : We have to write JCL by using 'IEBCOMPR'.FOR Sequential data set//COMPSEQ EXEC PGM=IEBCOMPR//SYSPRINT DD SYSOUT=*//SYSUT1 DD DSN=,DISP=SHR//SYSUT2 DD DSN=,DISP=SHR//SYSIN ... What is the best way to retrieve a record from a vsam file? Latest Answer : The Best way of retrieving a record from a VSAM file is performing a KEY READ on the VSAM File. Using the primary key of the record to be located, the record which is required is read directly and the process of Retrieval is faster. ... What is the total size of 9(3)v9(2) Latest Answer : 5 bytes ... How to identify the record that caused the SOC7 abend in a batch program? Suppose there are 1000 records in the input file. how can we find the exact record? Latest Answer : If the cobol program is compile with option FDUMP. you can see the input record which caused the abend CEEDUMP and also the field which cause the error. Something like this.QTY-ACCEPTED ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||