How do you run JCL in cobol program
Explain the contents that are a part of dclgen.
What is difference between alias and synonym in db2?
what is check point and restart Logic ? why do we go for that ??
What is dclgen in db2?
What is collection in db2 bind?
When is the authorization check on DB2 objects done - at BIND time or run time?
What is lock contention?
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
What are the various data types available in db2?
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 else is there in the PLAN apart from the access path?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?