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 6406If 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 8129if a>b continue display x. dispaly y. end-if display 1 display 2. display 3. what should be my output ?
3 5512
Mainframe project required Postby mache123 ยป Thu Jan 29, 2009 9:10 pm hello..... I want to know about some real time projects.If any one have any Mainframes project, please provide me documentation of it Or else give me the link where can I find that Mainframes projects with Documentation...... or suggest me any if......please
Explain about maximum displacement?
What is the full form of adabas?
What is a db2 package?
Write the code to count the sum of n natural numbers.
What are some uses of the evaluate statement?
Explain cebr transaction commands?
how to move the records from file to array table. give with code example
How to code these statements in JCL: CLEANUP INITIAL(NO) RESTART(NO) DYNALLOC(NO) job definition..?
Kindly specify the pic clause for the data type of length option field type of data fields?
What is the role of union all and union
Are view updateable?
In COBOL programming, what is PERFORM? What is VARYING?
how to define a directory and what is the structure and definition for the same?
What is eib?