For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
No Answer is Posted For this Question
Be the First to Post Answer
How can you count the number of rows from a table tab?
Define sqlca.
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
What is page size in db2?
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
Can you define an Index if the table size less than 10 PAGES?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
How do you Load a table ?? and what is Load replace ?
What is the difference between cursor stability and repeatable read isolation levels?
When reorg is used?
What is check constraint. Explain with example.
What are the full forms of spufi and dclgen and why are they used?