suppose I have two tables a and b. Both tables are connected with ssn number as foreign key. I want to retrieve a column data from b table. How will you write a query?
IBM,
742execution of a subordinate module is caused by the use of the cobol verbs ------------in the superior module
IBM,
787suppose oza017.myorg.emp has 100 records ,oza018.myorg.staff has 200 records but 50 are the common records in both files copy all the common records into oza017.myorg.xyz dataset?
IBM,
745Post New IBM MainFrame AllOther Questions
Can you define foreign keys?
how do we prepare test data using file-aid tool?
What is meant by an isolation level?
What is the function of the verb initialize?
Is the order of the when clause significant in an evaluate statement?
How to compare two files by using sort?
What is the difference between inrec and outrec?
Can records be accessed randomly in esds?
What is the need to code commits in batch programs?
Write about a ‘view’ in brief?
execution of a subordinate module is caused by the use of the cobol verbs ------------in the superior module
What is the need of running runstats in the test environment?
10. Why mainframe testing is so important? Give any three advantages of Mainframe Testing?
What is the use of base and index registers in the IBM 360/370 processor?
How to find all duplicate records?