-
IBM MainFrame (5234) - IBM AS400 (1355)
- IBM PL/1 (31)
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
3 8890What is the job entry system used in your project? based on what criteria the sequence of jobs are picked if priority is not mentioned in the job card?
1811if in a job, region is mentioned in both jobcard and in step then which is cosidered at the step level? A job has region 4k in jobcard and step1 with region 0k and step2 with 16k, then what is the region allocated for the entire job? what is the region step1 takes? what is the region step2 takes?
4 9524what is the option to be coded on return to associate a transaction identifier with next terminal.
IBM,
1 5843My Question is 1. How to cound no. of records in JCL. Please explain with an example. 2. How to execute only odd steps in JCL? I know EDIT TYPE = Inculde, Step Name = 1,3,5 and COND code for all even step. Anyone knows other than this.
19901) SORT FIELDS=(20,4,CH,D,10,3,CH,D) OUTREC FIELDS=(7:20,4,C' FUTURE ',20,2,10,3,1Z,1,9,13,7, 24,57,TRAN=LTOU,6X'FF') This example illustrates how a fixed-length input data set can be sorted and reformatted for output. The SORTIN LRECL is 80 bytes. The reformatted output records are fixed length with a record size of 103 bytes. SOLRF (the IBM-supplied default) is in effect, so unless the SORTOUT LRECL is specified or available, it will automatically be set to the reformatted record length of 103. in the above example i have some doubts that a) sort fields=(20,4,CH,D,10,3,CH,D) -what exactly it does and this fields related to output record fields or input record fields b)outrec used to refprmat the records after sorting that means could please reply me as soon as possible Thanks. Venkat
1 7093How to prevent user to access a screen directly from cics Native screen by using Trans Id?
IBM,
2 8288how to fetch the record before the last record in a cobol file( its a huge file and if the key field is not known)
IBM,
5 16984How to open VSAM file from 3.4? i have millions of records and i dont want to use the print ch ids(/) command bcz it takes to much time. so if you have any another command to open this plz tell me.
HSBC,
2 22822
What is the use of symbol // in jcl?
What is qsam? How it is used?
1)In a pf if we delete a record then how to insert a new record at the same place in that pf?? any logic or code? 2)A batch job is taking a lot of time to run,found that it is going into loop and wrapping up so how to skip that loop and process the job without changing the code? 3)In which scenario C D I R comes and C D G F comes in a job? 4)If a job came to error while processing a file how we can know at which record the error hit and how to skip that record and process other records without changing program code?
Is their any limit for data sets?
How to find the number of rows in db2 tables?
What is a SSRANGE and NOSSRANGE?
Explain the maximum number of segment types allowed for a single database?
Define sqlca.
by using xpeditor if we want to debug the subpgm, how can you code in x-ped for mai-pgm n sub-pgm ?
how can a cgi check whether an ifs object is available?
How does jcl specify the job to the operating system?
What are the types of identifiers?
In a CICS program, how will you read a VSAM file?
What are the mainframe computing pros and cons?
What is the difference between PIC 9.99 and PIC9v99?
