Answer / uttam das

Yes, we can sort the packed decimal

SYNTAX
SORT FIELDS=(01,06,PD,A)

what is the purpose of coding notify parameter in job statement?

0 Answers   IBM,

---

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above. 1 What is the maximum number of tables that can be stored on a Partitioned Table Space ? 1 what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names Accenture 5 Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code? 6 When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing? 2 how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE IBM 7 max number of columns in a db2 table? 6 What is package versioning? Please give an example. 1 What is the picture clause of the null indicator variable? 6 How do you filter out the rows retrieved from a Db2 table ? 1 What is DB2 (IBM Database 2)? 3 Can any one tell me about Restart logic in DB2.

2 Answers   Cap Gemini,

---

what are JCLLIB and STEPLIB in JCL?

0 Answers  

---

restart logic ?

2 Answers   TCS,

---

in catalog procedure i have step1 dd dsn=filea dd dsn=fileb dd dsn=filec ur concatenaning all the files. but i need to override fileb with file 2 ? can anyone give the ans pls for ths

1 Answers   DELL,

---

---

I have mainpgm(abc) this is the only cobol pgm(non-db2).And this pgm calling subpgm name "acd" this also only cobol(non- Db)and this pgm calling some other subpgm this pgm has cobol-db2 pgm. 1) IF you calling static mode how to run and how to compile? 2) IF you calling dynamic mode how to run and how to compile? plz suggestion me.

0 Answers   HP,

---

Explain about Specifying compiler options in the PROCESS (CBL) statement

1 Answers  

---

There is one QSAM is the VB file. i want to get the first characters in this file and change those characters from'abcd' to '1234' and creat a vasm file to put '1234' in it. how to do in only JCL. if it not QSAM, it's VASM and VB. how to do it.

1 Answers   IBM,

---

what are the ways of passing data to a cobol program from jcl?

1 Answers   IBM,

---

How can the disposition of sysout datasets be set for an entire jobstream?

0 Answers  

---

in my jcl have 20 steps step1,step2,.... step20.and i have to execute step1,step2,..and skip the step3 and remaing step4,step5 are execute? i want skip step3 only? what code u can write?

3 Answers   Patni,

---

I want to join to input files and write the matching fields on to an output file but i dont want the output file a sorted one

0 Answers  

---