What is difference between defining the DB2 cursor in working storage section and in procedure division? How does it affects to Cobol-DB2 program if the cursor is defined in working storage section and if defined in procedure section.
Latest Answer: Char function returns a character format of date or time. ...
Latest Answer: The main difference between DB2 and DB2 UDB is that DB2 UDB has open DBMS connectivity to other open systems. I.e., though on a mainframe system, it can connect to Java, Unix and a variety of other open systems. DB2 UDB provides graphical administration,Java ...
Latest Answer: sysibm is a default schema which has all the base tables and syscat is also a default schema which has the tables and views of sysibm objects... ...
I have to use BMCUNLOAD to unload from production image copies and LOAD them into Test DB2 tables to perform volumn testing. The image copies are having 91 partitions of data. How many SORTNUM number i must use in BMC UNLOAD utility? For 1 partition we are using 12 (or sometime 64 for another table). There are 91 partitions that i need to LOAD.
Latest Answer: The performance of an application can be monitored and enhanced in the application, as well as at the database level. •In application side the SQL’s can be tuned to make them more efficient, and avoid redundancy. •It is better to structure the SQLs so ...
Latest Answer: If DBP1 is the subsystem name, then the below unload step can be used//STEP001 EXEC DBP1UNLD,USER='USERNAME',ULDTAB='FILE1',DATE='UNLOAD(+1)' //UNLOAD.SYSREC00 DD SPACE=(CYL,(65,10),RLSE) ...
Latest Answer: In Copy pending status the table is available only for query processing. The solution of copy pending status is take an image copy or use repair utility.Check pending status happens only when the table is loading with ENFORCE NO option.It means the load ...
Latest Answer: for both -911 or -913 , you can check further SQLERRD(3) also contains the reason-code which indicates whether a deadlock or timeout occurred. The most common reason codes are: ...
View page << Previous 3 4 5 6 [7] 8 9 10 11 12 Next >>
Go Top
