What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
4 8147We are using the searching a table which is indexed, once the key is found, how can we get the occurance at which the key was found.
1 4606I have a files containing both duplicate and non-duplicate records.The file is already sorted by a key.I want to determine those records that are duplicate and records that are non-duplicate.If duplicate the record is move to a duplicate file and if non-duplicate that will be move to valid file.thank you
1 5371I have files that contains both duplicates files(occur more than twice) and non-duplicate files.The file is already sorted by a key.I want to determine those records that are duplicate and will be move to a duplicate file and non- duplicate files to be move to a valid file.thank you.help please
2 6803Using string statement.Is coding three destination string from one source string possible in one code?or three codes for every destination string of one source string.?thank you
BPL,
1 3331IF we are calling a PROC from Jcl...This Proc have 3 steps in it and we want to execute only the second step using the JCL, How to do it?? Please give the answer ASAP:)
8 15921if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
8 12199Is it possiable to use a gdg in the INCLUDE statement in a SORT jcl? I am using this because I want to change the condition with out changing the jcl. Please provide with a sample code.
1 5695i have a sequencial file contains multiple records, i want to extract one row which contains various fields like order number,date,warehouse,.ect.. in to the another file by accepting the order number from jcl. how can i do it. pls help me..
CGI,
4 11953
When will a port of ooRexx to "XYZ" be available?
Explain difference between read work file 1 and read work file once? Why we are using work file once?
What are the cobol coding sheets?
Why is free space left in ksds dataset?
What does the following code do? Ap wkur,=p5 where wkur is a label?
Explain delete-connected tables?
What do you mean by rollback?
What is the maximum size of varchar data type in db2?
Can we call instream to catalog and catalog to instream?
What is the binary search?
WORKING-STORAGE SECTION. 77 W-A PIC 9(3)V99 VALUE 23.75. 77 W-B PIC ZZ9V99 VALUE 123.45. PROCEDURE DIVISION. MOVE W-A TO W-B. DISPLAY W-B. STOP RUN. compiler : IGYGR1080-S A "VALUE" clause literal was not compatible with the data category o subject data item. The "VALUE" clause was discarded. WORKING-STORAGE SECTION. 77 W-A PIC 9(3)V99 VALUE 23.75. 77 W-B PIC ZZ9V99. PROCEDURE DIVISION. MOVE 123.45 TO W-B. MOVE W-A TO W-B. DISPLAY W-B. STOP RUN. 2375
What is an ook-rec in idms?
What db2 400?
What is the full form of adabas?
Explain how does idms communicate with cics?