Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
IBM,
3 8030How do you find out whether two Data Sets are having exact Data through ISPF Panel? (Say No of Records, Record Data exactly matching including spaces)
IBM,
8 20776What are differences between Static Call and Dynamic Call?
IBM, KBC, Keane India Ltd, Verizon,
10 28580Wrete a JCL to compare two files and mached records move to onc file & un mached rows wants to another file?
13 121797
How to get the last record in vsam file in cluster?
How to get the last record in vsam file in cluster? And how can you get the kids file records into your cobol program?
Explain how to pass instream data in sysin with assembler?
Explain the data storage?
How many ways are there for initiating a transaction?
What is integrated data dictionary?
I need exexution process for JCL programs
What are the parameter we cannot use in procedure? How many instream we can write in single jcl?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
is delete operation supported in an esds? Is rewrite operation possible in esds?
Can we delete records from view?
What is need of start 0? In steed of can we use anyother numerics? If we use what will happen?
In COBOL programming, what is PERFORM? What is VARYING?
Explain How will you the specification of database file?
Express the distinction between jes2 and jes3?