Answer / ravi & dhana

10 HNAME.
49 HNAME-LEN PIC S9(4) USAGE COMP.
49 HNAME-TEXT PIC X(10).

Answer / a

its
10 HNAME.
49 HNAME-LEN PIC S9999 USAGE COMP.
49 HNAME-TXT PIC X(10).

that's it.

Can you tell me how can you find out the # of rows updated after an update statement?

1 Answers  

---

What is the meaning of -805 SQL return code?

3 Answers  

---

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,

---

What are leaf pages?

3 Answers  

---

i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.

0 Answers  

---

What are the advantages of using a PACKAGE?

2 Answers  

---

What are foreign keys?

1 Answers  

---

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1 Answers  

---

How does cobol compile db2 program?

1 Answers  

---

Is the primary key a clustered index?

1 Answers  

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

1 Answers   IBM,

---

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1 Answers   MCN Solutions,

---