Answer Posted / mr. cooooool

SELECT CURRENT DATE, CURRENT TIME FROM SYSIBM.SYSDUMMY1;

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2210

---

Which command is used to connect to a database in DB2 ? Give the Syntax.

1102

---

What are the bind parameters ibm db2?

1050

---

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

4311

---

What is explain in db2?

1020

---

How to find the number of rows in a db2 table?

1120

---

What is a db2 cursor?

1055

---

Describe major components of db2?

1091

---

What are packages in db2?

1023

---

Which component is responsible for processing sql statements and selecting access paths?

1127

---

What is a bind card?

1216

---

What are db2 tables?

1125

---

What is catalog database in db2?

1162

---

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2936

---

Mention the definition of cobol in varchar field.

1248

---