What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
4 7954We 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 4499I 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 5255I 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 6677Using 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 3238IF 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 15619if 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 11922Is 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 5620i 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 11723
how can we apply for HSBC exam(Mainframe) in India??? i went to their site and was told to submit my CV ,. etc..( totally confusing...)
EXPLAIN MAIN FRAME TESTING PROCESS...HOW TO FIX THE MAINFRAME BUGS?
Can you explain primary aspect of cics?
What is the physical storage length of timestamp data type?
What are the types of the dfhmdf present in the cics?
what is the use of IEBGENER utility?
if we display var1 then what will b displayed in below condition. 77 var1 pic s9(2) value -10. 77 var1 pic s9(2) value -11. " " " -12. " " " -13. -14 ... ... -19.
What is the pic clause for the data type of length option field type of data fields?
can anybody post me about file-aid and changemen tools pls and give me reference if any mainframe guys are there
Name all the file-open modes
Explain what is a cursor in cics sql processing?
What is the difference between the positional and keyword parameters? Give examples.
I have mainpgm(abc) this is the only cobol pgm(non-db2).And this pgm calling subpgm name "acd" this also only cobol(non- Db)and this pgm calling some other subpgm this pgm has cobol-db2 pgm. 1) IF you calling static mode how to run and how to compile? 2) IF you calling dynamic mode how to run and how to compile? plz suggestion me.
What is control interval?
In real storage usage. By monitor through rmf iii the usage of real storage keep in increasing everyday. Why this happen?