prasenjit


{ City } noida
< Country > india
* Profession *
User No # 14242
Total Questions Posted # 2
Total Answers Posted # 21

Total Answers Posted for My Questions # 20
Total Views for My Questions # 33722

Users Marked my Answers as Correct # 180
Users Marked my Answers as Wrong # 55
Answers / { prasenjit }

Question { 9562 }

What will happen if a variable is declared as below..
Explain with an example?

Working storage section:-
01 WS-VARX PIC X(9) VALUE SPACES.
01 WS-VARN REDEFINES WS-VARX PIC 9(9).


Answer

if you perform any arithmetic operation than comes the
question of any abend

Is This Answer Correct ?    4 Yes 0 No

Question { Tech Mahindra, 22455 }

I have a table which has thousand of records i want to
fetch only record num 100 to record num 200. Write a query
that satisfies this criteria.(Cant use any keys)
Anyone please reply ASAP!


Answer

With reference to Mr.Om......
In the question itself i had mentioned that you are not
supposed to use any keys....so that negates your query
where u have used empno as a key!

Arent there any solution for this?

Is This Answer Correct ?    1 Yes 2 No


Question { Tech Mahindra, 22455 }

I have a table which has thousand of records i want to
fetch only record num 100 to record num 200. Write a query
that satisfies this criteria.(Cant use any keys)
Anyone please reply ASAP!


Answer

Yes and no in both ways.
I know there is a Roid() Over() function DB2 release 7
onwards and that shld solve the problem.
But what if there was condition that you cant use these
functions.
Cant there be any query that can produce the req result.

Is This Answer Correct ?    1 Yes 1 No

Question { 7401 }

Can there be 2 job statements in a JCL?
If yes what is the purpose of doing tha?


Answer

Yes definately....For example you can combine both the
compile jcl and run jcl under one common jcl..

Regarding your 2nd question its quite childish to put up
such questions. You can tell that maybe saving some time
and space.

Is This Answer Correct ?    6 Yes 0 No

Question { Accenture, 17595 }

can we have more than one job in a single job card that is
we are specifying only one 'job' statement in the jcl.


Answer

Why not after the null statement i mean after specifying
end of job we can have another job statement and so on.

Is This Answer Correct ?    4 Yes 3 No

Question { BirlaSoft, 11267 }

What is the difference beetween Arrays and Tables in Cobol?
please dont give the answer that arrays in cobol
terminology is called tables......


Answer

Arrays are basically used to store data which are of
similar type in contiguos memory locations.
Tables on the other hand you can think it as a list which
is used for lookup/referencing, for example when doing a
SEARCH/SEARCH ALL.

Is This Answer Correct ?    7 Yes 4 No

Prev    1    [2]