mandar


{ City } pune
< Country > india
* Profession * associate consultant
User No # 33886
Total Questions Posted # 0
Total Answers Posted # 4

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 16
Users Marked my Answers as Wrong # 3
Questions / { mandar }
Questions Answers Category Views Company eMail




Answers / { mandar }

Question { IBM, 4076 }

What are the 3 working storage fields used for every field
on the map?


Answer

length, attribute and field

Is This Answer Correct ?    7 Yes 0 No

Question { IBM, 4697 }

What is the difference between using the READ command with
INTO option and SET option?


Answer

When READ is issued with INTO option, the copybook needs to
be mentioned as parameter to INTO option. whereas for SET
option, pointer name needs to be mentioned.

Is This Answer Correct ?    1 Yes 0 No


Question { IBM, 5022 }

What is some of the information available in the EIB area?


Answer

Basically it is an Extended Interface Block which gives
some important information to the program like, date and
time the transaction triggred, transaction ID, the data
passed to the program and so on....

Is This Answer Correct ?    0 Yes 2 No

Question { iGate, 7589 }

in 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.


Answer

Before opening this cursor thru OPEN . because
when we open the cursor, it fetches all matching records
from table and stores them in buffer. so it evaluates that
where clause while opening the cursor.

Is This Answer Correct ?    8 Yes 1 No