Answer Posted / yuvaevergreen

IN DCLGEN,
>>"INDICATOR VARS .. ===> NO" indicates the presence of
null variables for the fields in the tables.
>>indicator variable should be declared of type s9(4) comp.
77 DAY-IND PIC S9(4) BINARY.
Move -1 to the indicator variable and use in sql.
exec sql
insert into employee(name)
values(:ws-name:ws-name-ind)
end-exec;
ws-name-ind is the indicator variable which inserts null in
the field ws-name.

What is meant by dclgen?

1112

---

What is the use of commit in db2?

1083

---

What is host variable in db2 cobol?

1079

---

What is innodb buffer pool?

1061

---

What are union and union all?

983

---

Explain about dbrm.

1049

---

What is the physical storage length of the data types date, time, and timestamp?

1091

---

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 ?...

4317

---

What is a collection in db2?

1036

---

what is the sqlcode -501

13161

---

What is null value in db2?

1027

---

What is the physical storage length of time data type?

1129

---

What is load replace in db2?

996

---

Is db2 relational database?

980

---

What is the function of logging in the db2 database?

1123

---