what is the Foreign key? explain?

How we create a tables in db2,what is the process/syntax to create a table with example plz?

how to excute a querry in QMF at a perticular time.

TCS,

In DB2 Large OBJECTS(lob) COLUMNS ARE USED TO STORE LARGE OBJECTS(DOCUMENTS,PICTURES) IN DATABASE.WHICH OF THE FOLLOWING CLAUSES CANOT BE USED ON LOB COLUMNS? A)GROUPBY B) HAVING C)ORDERBY d) NONE OF THE ABOVE WHICH MQ COMPONENT IS ESSENTIAL IN DISTRIBUTED SYSTEM MESSAGING? A)MQSERVER B)CHANEL C)CLUSTER D)QLOCAL E)QREMOTE IN THE MVS WORLD,COBOL INTRODUCED POINTERS TO THE COBOL.WHICH OF THE FOLLOWING STATEMENT IS TRUE ABOUT COBOL POINTERS? A) A COBOL POINTER CAN POINT TO ANY KIND OF OBJECT. B)COBOL POINTER DOSENOT ALLOW POINTER ARTHEMITIC. A)A b)b C)BOTH A AND B D) NONE WHAT IS THE NAME OF THE JOB THAT HAS AN ADRESS SPACE IDENTIFIER(ASID) OF ONE? what is the cics commands to enable writing mixed characters in cics region? a)cemt caps off b)caps off c)ckti d)ceot tra e)ceot caps off

TCS,

I want to code a REXX Program in order to load many tables in a database simultaneously in a batch fashion. Currently batch codes ar available in which only one job is submitted at a time and this loads only one table. My requirement is that many tables should be loaded at a time when one Job is submitted and can this be done using REXX Tool???

I want to code a REXX Program in order to load many tables in a database simultaneously in a batch fashion. Currently batch codes ar available in which only one job is submitted at a time and this loads only one table. My requirement is that many tables should be loaded at a time when one Job is submitted and can this be done using REXX Tool??? I want code snippet or the coding for this , please

I want to code a REXX Program in order to load many tables in a database simultaneously in a batch fashion. Currently batch codes ar available in which only one job is submitted at a time and this loads only one table. My requirement is that many tables should be loaded at a time when one Job is submitted and can this be done using REXX Tool??? I want code snippet or the coding for this , please

1)what is the maximum limit for occurs? Eg: 01 A PIC X(10) OCCURS N TIME. What is the max value for N?

Wipro,

How to find How Many Lines in Sysin DD * Parameter Thru Cobol Coding? If any one knows the Answer Please Reply .....Thanks From Shree

Merrill Lynch,

Suppose I have Five Steps in PROC In this Case I want to Execute third Step in PROC using Main JCL don't use any COND Explain with Coding Thanks & Regards SHREE

Merrill Lynch,

1.what is the panel name of ispf primary option menu ? 2.What is the facility that allows mainframes to be partitioned into LAPARs? a.Z/os b.PR/sm c.Vitual storage d.Coupling facility

Wipro,

select TURE Statement(s) aboUt eject statemenet in cobol? a)The eject statememnt must be the only statement on the line b.It causes the program to edit abnormally c. eject statement can be written in either area A or area B d. specifies that the next source statement is to be printed at Top of the next page e.The EJECTstatement has no effect on the compilation of the source program itself

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

Wipro,

.what is required for establishing connectivity between MQ and cics on z/OS? a. MQ-cics gateway b.INITQ as QLocal c. CICS-MQAdapter d.INITPARAM of SIT e. INITQ as QRemote

Wipro,

What is the difference between Perform para and perform asaection in cobol?

TCS,