Latest Answer: hi the above said answer is correct but selection criteria to usage should be T ...
Latest Answer: Loading a DB2 table can be done by an utility as mentioned above or u can code a program and insert all the records data from a file by dynamic sql commands validating for all the fields.Eg:EXEC SQL ...
Latest Answer: How does you get record no from 5 to 15 from a dataset of 100 records? ...
Latest Answer: DIFFERENCE BETWEEN SPUFI AND QMF : SPUFI : 1.you can execute more queries at a time. 2. In SPUFI result of the query will be in PS or in PDS member will store but3.you know the sqlcode after executing the query. QMF: 1.you cannot execute more than ...
Describe the elements of the SELECT query syntax. SELECT element FROM table WHERE conditional statement?
Latest Answer: You will declare the Cursor with "WITH HOLD " Option when you want the cursor to be pointing to the next row even after the fetch from the db2 table and you exit from the program until expilicit commit is performed to updated to Db2 and Close cursor ...
Latest Answer: also QUERY TABLE command will tell you if load is complete or not ...
Latest Answer: Yes, We can see the Comp-3 Data by pressing Hex On In the File-AID ...
Latest Answer: Go to spool and in the command prompt give owner '@XXXX' and pre * then you will able to see all the job status for the user XXXX. where XXXX is the mainframe id of other person. ...
Latest Answer: i think only one clustering index ll be created for any table in DB2. This clustering index is created on the primary key of the table. for all other index(es) created on the table they ll be nonclustering index(es) . ...
View page << Previous 6 7 8 9 [10] 11 12 13 14 15 Next >>
Go Top
