Answer / vegeta

Sqlca is SQL communication area.SQLCA will have all the information like return code, error id, error details etc,. after the DB2 query execution.

how to know that the file has 300 records how to acess it?

0 Answers   Hewitt, TCS,

---

What is the use of intialize verb?

0 Answers  

---

What is the difference between perform … with test after and perform … with test before?

0 Answers  

---

i have two file, each file having : file1 is having 2 fields field1 field2 file2 is having 3 fields field1 field2 field3 my req is to make it one file like: field1 field2 field1 field2 field3 if anyone know please send me syntax, i tried this with DFSORT but could not succeed.

9 Answers   Syntel,

---

If there are two copybooks which have same variables and we are using both the copybooks in our program. will there be an error and if i move values to the variable which copybook varibales gets the values i move in.

3 Answers   CTS,

---

where do we use dyanamic call ? and where do we use static call pls give any example pls ?

3 Answers   Patni,

---

what is soc7 abend?how u can trace it?

4 Answers   Accenture,

---

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  

---

Is this allowed? 01 WS-TABLE. 03 FILLER-X PIC X(5) VALUE 'AAAAA'. 03 WS-EX REDEFINES FILLER-X OCCURS 5 TIMES PIC X(1). can redefines clause be used with occurs clause?

4 Answers  

---

can we use the two 01 level in file discription ?

6 Answers  

---

State the various causes of s0c1, s0c5 and s0c7.

0 Answers  

---

have in 100 records in a file i want to move only matched records to one output_file1 and nonmathed records are moved to another output_file2 ... any one can provide logic code

3 Answers  

---