How to compare two files in SYNCSORT and on the mismatch record should be deleted from second file.

5062

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?

543

Are there any set of rules for the names of the steps used in a job?

637

What are the 2 sqlcodes that are returned?

643

Explain The Keywords Edtcde & Edtwrd?

842

What is the connection string to connect to the DB2 Database ?

614

What do you mean by monitor block?

1357

without jcl how to run the batch programs

2203

What is isolation level in db2?

577

In the house keeping section of an MVS assembly language program, like the one below STM R14,R12,12(R13) BASR R12,R0 USING *,R12,R11 LA R11,2048 LA R11,2048(R11,R12) .... .... 1. What if BASR R12,R0 IS NOT PRECEDE USING *,R12,R11? 2. USING (base address), REGISTER does USING directive says assembler to treat particular Register as a base register with the mentioned base address..in the above case * i.e current location counter..well if that is the case why we need BASR R12,R0 ? 3. What if I write like STM R14,R12,12(R13) BASR R12,R0 LA R11,2048 LA R11,2048(R11,R12) USING *,R12,R11 there is no address resolution being calculated in both LA statements so is it a right way to set Base register?..will there be any issues with Domain regarding R11 and R12?

1531

what is sflpag and sflsiz ?

2290

What is the syntax for FETCH in DB2 ?

675

what are the types of abends that occur on job failure? And explain the possible causes of these

1118

Is ibm db2 free?

575

What is the device independent method to indicate where a record is stored?

586