how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
UST,
1 5869in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
4 11375How to replace the GOTO statement in COBOL without changing the structure of program. e.g. consider following code... I.D. E.D. D.D. P.D. compute C = A + B. GOTO para 100-display. compute D = C - D. GOTO 200-display. some other logic...... ........ GOTO 300-para. ...... ...... GOTO 400-para. Now I want to replacce all GOTO statements without changing the structure and otput of program.
6 23210I have program P1 which calls file F1 which has 100 records and following structure 001 .................. 002 .................. 003 .................. 098 .................... 099 ................... 100 .................... Now I want to read these files and write these records in file F2 in following manner. 001 ...... 051 ..... 002 ...... 052 ..... 003 ...... 053 ..... .......... ....... .......... ....... .......... ....... 048 ........ 098 ...... 049 .......... 099 ....... 050 .... 100 ......
4 12384Why we need to use redefine clause when we can define the variable seperately... what is actual need....
5 14970in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
3 10607How to resolve the error "WER488A JOIN CAPACITY EXCEEDED" I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem? I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem?
1 8583a job have 5 steps and it will executes a proc which have 5steps in it. now i have to execute step3 only when step2 of proc executes successfully
3 7573
What are the access method services used in vsam?
List in order the hierarchical levels of jcl?
What is the function of dd name parameter with a 2 part structure; audit.report?
What is the function of logging in the db2 database?
What is the use of dclgen in db2?
How to find occurrence of mu and pe fields in a file?
Which commend used for terminating a browser operation?
Explain the difference between temporary storage queue (tsq) and transient data quene (tdq)?
What is dclgen in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Kindly specify the pic clause for the any bll cell type of data fields?
what is the meaning of notcat 2?
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?
What is the comaera (communication area)?
Step 1 RC 4 Step 2 Step 3 I want to know the COND parameter which can be coded in step 2 or 3. Step 2 should be executed based on Step 1 RC and Step 3 should not be executed based on step 1's RC