IBM MainFrame (5234)
IBM AS400 (1355)
IBM PL/1 (31) In CICS/VSAM every file that is accessed should be defined in FCT. we have CICS READ, WRITE, BROWSE commands for VSAM files. How does it work with DB2 tables. It know it has to do with the plan. Please expain with examples.
1 4677i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
2394Can anybody know what is Pick/Basic? Is it a programming language? can it be used in AS400 machine?
2 8719what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
2 4827i have 1000 records in pf.what are all the ways to read a particular name records in rpg?? ie.. in pf i have a name called demo appeared around 52 times hw will we read this particular records in rpg/400?.
IBM,
11 20953how to see number of logical files depending on a pf?...can we declare more than 20 logical files from a single pf? is it possible
ocbc,
4 9922(1)In Cl Program,Are PGM and ENDPGM mandatery Keywords or not .If yes, please tell me why these keywords is necessary. (2)If we will not define these two keywords (PGMand ENDPGM) then any error will be come or not.
5 21840Q. Soppose one job is running in a batch mode for long time now i want to kill(end)this batch job.How you will achive this?
IBM,
4 12057
How to view db2 table structure?
What does the keyranges parameter in define cluster commends do?
What are the types of perform?
How can the duplicate values be eliminated from db2 select?
Whats the difference between search & search ALL?
Explain the thress bms options?
Name all the file-open modes
Can you explain exec cics handle condition command?
Suppose there are 2 Input files Infile-1 and Infile-2. Both the Files contain Employee Records. You need to compare both the files and Write the Common Records in third file named Outfile. How can we do this using File-Aid?
Define the term function request shipping?
what is the maximum number of records you can specify in a display file?
Can you define commarea?
What Is Default Data Type (if You Define Decimals '0') In Physical File?
Name and explain the type of locks?
What is the difference between goback, stop run and exit program in cobol?