Mention some fields that are a part of sqlca.
No Answer is Posted For this Question
Be the First to Post Answer
select 100 records from million records ?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
What is schema in db2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is node in db2?
Are views updateable?
What is db2 plan table?
What do you mean by storage group (stogroup)?
How do I add a column to an existing table in db2?
How do you retrieve the data from a nullable column?
How is deadlock resolved?
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