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 9987a 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 8007in 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 9102Suppose 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 8106Suppose 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 8534I'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 11797I'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 23040how 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 10864I encountered an error when I move spaces to a numeric field?What should I do to move spaces on that field?help please.
9 13309In A cobol program , we can use COPY Statement in FILE- SECTION / WORKING-STORAGE SECTION / ENVIRONMENT DIVIION basically what is the difference
IBM,
3 11176
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
pls send the docs of any telecommunication mainframe project
what u mean by csrloc and rtncsrloc in rpgIV in as/400.Give an eg? to do...give some coding...what is row no and column no ???..if possible...give a no of lines coding....please
What is the latest version of ibm db2?
i need a small 3d program using inline and outline.
Is it rquired any server for Ibm framework? Give me list of Ibm framework & recent version IBm framework?
can any body give me any website for getting help on mainframe projectts in banking domain.
List the type of locks and explain each of them.
PLEASE SEND ME THE DOCUMENTS IF ANY ONE HAVE REGARDING THE IMPACT ANALYSYS,REVIEWS
Are you comfortable in cobol or jcl?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2