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 6537If 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 8270if a>b continue display x. dispaly y. end-if display 1 display 2. display 3. what should be my output ?
3 5623
which cics service transaction is used to gain accessibility to cics control tables? Mention the one that has the highest priority.?
What is the compute verb? How is it used?
2 input fles: 2 flat files, with different number of records. both are having unique key for each record and already sorted in ascending order . match these files using unique key and in output only matching key value has to be written. please procide cobol logic
What are the 2 sqlcodes that are returned?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
without jcl how to run the batch programs
what how do you initialize a vsam file before any operation? A vsam with alternate index?
What is idms-restart ?
Define data page.
Explain the function done by data manager?
which parameter is use to declare the name of dataset in dd statement?
What is a dbrm in db2?
What are hierarchy levels in jcl?
What is job control language?
What is need of start 0? In steed of can we use anyother numerics? If we use what will happen?