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,
1032execution of a subordinate module is caused by the use of the cobol verbs ------------in the superior module
IBM,
1143suppose 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,
1071what is the difference between a package and a plan. How does one bind 2 versions of a cics transaction with the same module name in two different cics regions that share the same db2 subsystem?
IBM,
1119
If we say that bms length of field = 0, then what does that mean?
How do you round the addition or subtraction of two numbers in assembler?
Suppose you are processing an input file in a natural program and you want the program to fail if the file is empty. What command you use in natural to force it to fail?
I have a COBOL program that ACCEPTs some input data. How do you code the JCL statement for this?
How can you access qsam (seq) files from cics?
What is the maximum size of varchar data type in db2?
What is lock escalation in db2?
here is my requirement A1 is alphanumeric with value 'A1B2C3D4' as defined below 05 A1 PIC X(8) VALUE IS 'A1B2C3D4' but i need to have A2,A3 as ABCD & 1234 repectively...... A2 = ABCD A3 = 1234 Can you please explain me what are the different ways to do it?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is the kcp in the cics?
What is the disadvantage of dynamic generation of acb?
how do you bind the cobol with db2
What do you mean by between and in? Is between inclusive of specified range values?
How to pass data to a program that is coded in an exec statement?
Define gdg?