krishna


{ City } hyderbad
< Country > india
* Profession * system anallyst
User No # 71080
Total Questions Posted # 8
Total Answers Posted # 15

Total Answers Posted for My Questions # 16
Total Views for My Questions # 56747

Users Marked my Answers as Correct # 21
Users Marked my Answers as Wrong # 32
Questions / { krishna }
Questions Answers Category Views Company eMail

how to edit a tape dataset ? asked in wipro

Wipro,

1 JCL 6037

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

IBM,

DB2 1698

what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx

IBM,

2 DB2 5342

can we view the access paths created by dbrm ? how ? thx

IBM,

2 DB2 6211

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

IBM,

5 DB2 8964

i have a ps with two columns eno and ename , i need to copy eno column values in one ps and ename column values in one Ps ? is it possible through iebgener . how ? thx in advance

IBM, TCS,

1 JCL 6013

Suppose i have a variable with s9(18)v99 comp3 . what is the size of variable . If s9(18) comp3 is 10 bytes . There should be some difference between two allocations ? Thanks krishna chaitanya

CSC,

2 COBOL 13906

I have a File that has duplicate records. I need only those records that occur more than thrice.?

IBM, Wipro,

3 COBOL 8576



Answers / { krishna }

Question { 18277 }

COMP-3 field occupy ?


Answer

Comp3 will occupy from s9(1) to s9(18) . it wont exceed more
than it . So max value of comp3 is 10 bytes

i.e, 18/2 +1 = 9 + 1 = 10 bytes .

I thk i am correct .

Is This Answer Correct ?    1 Yes 2 No

Question { IBM, 17524 }

What is CECI?


Answer

ceci is used to send map

command is ceci send map(mapname ) mapset(mapsetname )

thanks for giving ths time

krishna

Is This Answer Correct ?    0 Yes 1 No


Question { IBM, 15997 }

How would you resolve an ASRA abend?


Answer

we can debug thru intertest we can find the particular error . so we can find line number . solve it manually

Is This Answer Correct ?    2 Yes 1 No

Question { 7267 }

What will happen if we move SPACES to numeric field and
ZEROES to alphabetic field?


Answer

soc7 may occur

Is This Answer Correct ?    0 Yes 1 No

Question { Principal Finance, 11328 }

Can we create VSAM file by using IEBGENER?


Answer

HI PALS I THINK WE CAN CREATE . DSORG =KS/ES/RR IS USED TO DO THAT .

PLEASE TELL ME IF I AM WRONG

Is This Answer Correct ?    3 Yes 5 No

Question { IBM, 11993 }

how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE


Answer

Delete from TAb1
Where Rowcount(*)=3

i hope this is Correct

Is This Answer Correct ?    5 Yes 1 No

Question { Steria, 9219 }

01 x pic s9(8) comp.
How will the following value be internally allocated
'18787'


Answer

the answer one is correct . he asked a question , how to
override 3 rd step .

we can do lik ths

step3.ddname which will override the DS .

if any wrong correct me .

Is This Answer Correct ?    0 Yes 1 No

Question { Patni, 16286 }

can you declare redefine in level 01?


Answer

Yes WE can use REdefines in cobol ,

Is This Answer Correct ?    2 Yes 0 No

Question { Cap Gemini, 19570 }

what is the coding difference between COBOL and CICS.


Answer

Hi all

cobol is a high Level language . we can also call it as
programming lang .

CICS is a Language which is used to Develop the Screens .
its just like Scripting lang .

Ex : HTML

Its a lang which deals with assembler level Macros like
DFhmdf,dfhmdi,dfhmsd , dfhpct ........

Cics is a core for mainframes

Is This Answer Correct ?    1 Yes 1 No

Question { 4171 }

maximum of how many screens we can open in emulator


Answer

THE ANSWER IS MAXUSER PARAMETER IN A PARM LIB . wHICH LOCATED IN CPAC.PROCLIB .

IF MAXUSER 10 ONLY 10 SCREENS

Is This Answer Correct ?    0 Yes 0 No

Question { IBM, 6686 }

why we are using set in searchall?


Answer

In searchALL We Dont use any Set Verb . But in Search we
will use

Is This Answer Correct ?    0 Yes 0 No

Question { Mind Tree, 6405 }

01 text-data pic x(100).
move 'xyzdbfrjjg u' to text-data.
how to find the value of last index of text-data?


Answer

cana ny one post a code for that ,

thanks in advance

krishna

Is This Answer Correct ?    0 Yes 0 No

Question { IBM, 5909 }

what is the difference between Plan & package


Answer

Package is a collection of several plans . package is not a
executable form , so we are going to plan for execute the
SQL terms . Plan releases the Timestamp . Plan is a
executable form .

Is This Answer Correct ?    3 Yes 5 No

Question { IBM, 5909 }

what is the difference between Plan & package


Answer

ya i got u Muthaiah

Package is a collection of plans .

Thanks

Is This Answer Correct ?    0 Yes 12 No

Question { HCL, 9797 }

i have mainprogram and subgram...if i compile mainprogram
without stop run..what will u get in compilation time?


Answer

WE will get a Abend su4038

Is This Answer Correct ?    4 Yes 2 No