if my GDG limit has been kept as 50 and if am trying to put 60 records.what would happen. will there be any abend for this scenario
4 9748a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
3 7795in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
2 8929Suppose you are adding a new field in a map, and that field should also be added as a new column in DB2 table. How do you implement this? what is the impact analysis u will do?
2 7969Suppose your program is reading a Sequential Vsam file. The file contains 10 records. How will you code the JCL to read only 2nd, 5th, 7th,and 10th record?
1 8413I've one sequential file, that file size is LREC=100 (File contain Records like 1 to 100). Now I was increase the file size is LREC=102. My question is I want insert 00 (Two Zeros) in to the new file (That output file looks like : 00123 up to 100). How will write the SORT card in JCL. Please let me know.
2 11650I've one string with spaces ( I N D I A ). My question is I want remove the spaces & combine in to single string without space (INDIA).How we can write the cobol program & wich options we need to use. Please let me know.
10 22541how can count the number of character in feild ?? suppose for instance i have a feild with value ' rajesh sarkar' then how can v count the number of characters whitout spaces...........
4 10636I encountered an error when I move spaces to a numeric field?What should I do to move spaces on that field?help please.
9 12978In A cobol program , we can use COPY Statement in FILE- SECTION / WORKING-STORAGE SECTION / ENVIRONMENT DIVIION basically what is the difference
IBM,
3 10986
Can we give +2 instead of +1 while creating a new gdg file?
Define communication area?
Define dl/i?
Can we use DISP=SHR in output file in JCL
Are you comfortable in cobol or jcl?
what are s0c1, s0c4, s0c5, s0c7 abends?
in options (main) , what is meaning of main . if u not used main what will happen? After compiling, os will not understand where to load and execute from
What is a db2 schema?
What is the utilization of copybook in cobol?
What is the binary search?
Explain the maximum of key fields and search fields allowed in a segment?
Hello Guys, I have 1+ Year Experience in MAINFRAME TESTING. After 1 Week I have an Interview With a Company on Mainframe Testing. Please Could You Guys Please Suggest me What Sections Should I prepare ?? ___Tell Me the Topic Or Appropriate Site & Links. ?? ---------------Thank You
OPEN INPUT StudentFile READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ PERFORM UNTIL EndOfStudentFile DISPLAY StudentId SPACE StudentName SPACE CourseCode SPACE YOBirth READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ END-PERFORM CLOSE StudentFile STOP RUN what will be output
What is the maximum No of rows per page?
Is it possible to left uncode disp? If yes, how?