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
IBM,
2 6661If I defined space as TRK(10,10) for the one file and lrecl = 4K then tell me how many record will vsam file will contain. will it 1,2,3,4,5 or how many,
IBM,
3 8435if a>b continue display x. dispaly y. end-if display 1 display 2. display 3. what should be my output ?
3 5780
What is the purpose of dd?
what is the use of the file status clause in the select statement in vsam?
What is a set? How may sets be ordered?
How do you submit a job for execution?
What is runstats and reorg in db2?
How many root segments do we have per database record?
what are the common errors that occured while programming in AS/400?
what is the difference between COBOL2 AND COBOL390?
If I have a view which is a join of two or more tables, can this view be updateable?
i want to learn mainframe..any websites and material to learn from basic..? my mail id : rajeswaribe2010@gmail.com
Kindly specify the pic clause for the data type of length option field type of data fields?
What are 77 levels used for?
can any one exaplin about Decision Tables in test region with good example
What is precompiler in db2?
Does Disconnect and Connect creates page lock in IDMS ?