React.js
Angular
Ethical Hacking
Agile
AWS
BlockChain
Cassandra
Cloud
Salesforce
Scaled Agile
TOGAF
DevOps
GIT
Jenkins
Jira
Kibana
Linux
NGINX
Ansible
Artificial Intelligence
in Machine Learning by
Syntax of DBADD command?
Click here to read more about DevOps

1 Answer

0 votes
by

The DBADD command adds a new LREC to a subfile , Facilitates addition of LREC BEFORE or AFTER the current LREC , At a position in the subfile as defined by keys and organisation , By supplying a LRECNBR or at the end of the subfile

Mandatory Parameters for DBADD

REF= | FILE=  (or both)

NEWLREC= | NULLREC =

NEWLREC :  Specify  the   address  of  the  new  LREC to be  added  as the  argument ,   can  specify  a  label

 (Length > 3) , A/label or a register , For Variable length lrecs size and key should have been set up in the new LREC

NULLREC : To add an empty LREC to a subfile  , specify a location that contains the length of the empty LREC (register|label|A/label) and the primary key of the empty LREC , Adding a NULLREC to a UP/DOWN organised subfile might corrupt the organisation . Normally used with W-type and T-type files

EXAMPLE :

DBADD REF=TRABSQ,NEWLREC=EBW000,UP

KEY1=(R=TRABKEY,S=EBW002),

      KEY2=(R=TRABAWB,S=EBW003,L=L'TRABAWB)

DBADD FILE=WRXXSQ,UP,PKY=#WRXXK10,REG=R5,

      KEY1=(PKY=#WRXXK10),NULLREC==AL2(#WRXXL10),

      ERROR=ADDERROR

Related questions

Madanswer
+1 vote
asked May 29, 2019 in Machine Learning by param1987
+1 vote
asked May 29, 2019 in Machine Learning by param1987
...