Interested to Buy Any Domain ? << Click Here >> for more details...
What is a predicate?
- 1 Answers
- 4800 Views
- I also Faced
- E-Mail Answers
Answer / s
predicate is a search condition coded in the SQL statement
to filter rows.
| Is This Answer Correct ? | 3 Yes | 1 No |
Is db2 a mainframe database?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
Can you search give an array in the WHERE clause of a db2 query?
what is rebinding ?
When can an insert of a new primary key value threaten referential integrity?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
How will you return the number of records in table?
How do you pull up a query which was previously saved in qmf?
How do you insert a record with a nullable column?
COBOL 
