How can you get the number of rows impacted by the last executed query?
No Answer is Posted For this Question
Be the First to Post Answer
Can we use select * statement in cobol program without giving field names ???
How to create a table using embedded sql?
What are delete-connected tables?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
How would one remove old reorg information from the DB2 catalog?
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
What is a lock?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
Can we install 2 different versions of Db2 on same mainframe?