before altering a table is it necessary to lock ? if lock
what is it ? how to do ? ifi want to lock a table what is
that command ?
No Answer is Posted For this Question
Be the First to Post Answer
How to insert more than one record using insert?
Can we declare DB2 HOST variable in COBOL COPY book?
How will you delete duplicate records from a table?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
What is the self-referencing constraint?
How we create a tables in db2,what is the process/syntax to create a table with example plz?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
How can we retrieve the total number of records in RPG & CLLE?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is normalization and what are the five normal forms?
When can an insert of a new primary key value threaten referential integrity?
When reorg is used?