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 4615i 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.
2350Can anybody know what is Pick/Basic? Is it a programming language? can it be used in AS400 machine?
2 8586what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
2 4699i 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 20523how 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 9750(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 21599Q. 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 11856
Explain the function of dd disp parameter?
How do I start db2 in windows?
What is the importance of common attribute?
What is adabas and why it is used?
What is the maximum length of sqlca?
Suppose I have five jobs to do. But I want to hold one?
SET is the ANSI standard for variable assignment, SELECT is not. SET can only assign one variable at a time, SELECT can make multiple assignments at once. If assigning from a query, SET can only assign a scalar value. If the query returns multiple values/rows then SET will raise an error. SELECT will assign one of the values to the variable and hide the fact that multiple values were returned (so you'd likely never know why something was going wrong elsewhere - have fun troubleshooting that one) When assigning from a query if there is no value returned then SET will assign NULL, where SELECT will not make the assignment at all (so the variable will not be changed from it's previous value) As far as speed differences - there are no direct differences between SET and SELECT. However SELECT's ability to make multiple assignments in one shot does give it a slight speed advantage over SET.
where will control be passed after the execution of the *pssr subroutine if the factor2 of the endsr is blank ?
Define where and its usage?
in conjunction with which statements can orxx and andxx conditions be used ?
How can you classify the locks in db2?
what happens in execution stage in job processing?
How to detect record is locked in cobol/400? What is the solution for that?
How do you code cobol to access a parameter that has been defined in jcl? And do you code the parm parameter on the exec line in jcl?
What is reorg?