in GDG: is it poosible to copy records from a file which
utilizes some 100 cylinders to a gdg whose model is defined
as trk(1,0) and also it possible to copy 100 bytes file to
80 bytes file?
What are common abends
What action db2 takes when a program aborts in the middle of a transaction?
Can a Db2 table data be retrived through JCL?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
What is a DB2 access path?
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
Where do you specify them?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
How to retrieve rows from a db2 table in embedded sql?
What do you mean by NOT NULL? When will you use it?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How to select the duplicate rows from a table?