Answer Posted / sravan

1.String(item_a||item_b);/*String -> concatenates to
elements*/
2. SUBSTR(item_a,3,5); /* Substring -> returns first item
characters starting from second items count to last items
count, here if item_a = 'algebra' returns substr
contains 'gebra'*/
3.Translate(string,replacement_chars,chars to be replaced)
/*WRK_RQSTDEL_DATE = TRANSLATE
('GH/EF/CD',RQST_DELDATE,'ABCDEFGH'); */
4. verify (x,y); /*DCL MAINSTR CHAR(6) INIT ('ANUK ');
DCL SUBSTRG CHAR(2) INIT ('NA');
RTN = VERIFY(MAINSTR, SUBSTRG); */

how would find total records in files using sequential?

1038

---

suppose I have 1000 rows in a db2 table. I want to update first 100 records, how do I do it?

1167

---

A word in the computer memory is identified by_________

1052

---

What is the mainframe computer?

991

---

What is meant by a bolt dispute?

1410

---

Please send me the real time scenarios in Mainframe Project... i.e., it may be in banking or insurance sector or any other no problem..... please send your mails to krishnaprasadbvs@gmail.com

11802

---

suppose oza017.myorg.emp has 100 records ,oza018.myorg.staff has 200 records but 50 are the common records in both files copy all the common records into oza017.myorg.xyz dataset?

1061

---

How are composite and multiple indexes different?

1065

---

What is comp-1?

1010

---

Describe the benefits of drda?

1006

---

Explain foreign keys?

1075

---

what is difference between file-aid tool and file-aid utility?

1570

---

Can you explain referential integrity?

1061

---

how do we describe static call and dynamic call?

1066

---

Explore the syntax of the evaluate statement?

1015

---