naga srinivas.kattula


{ City } bapat;a
< Country > india
* Profession * software engineer
User No # 82306
Total Questions Posted # 0
Total Answers Posted # 9

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

Users Marked my Answers as Correct # 7
Users Marked my Answers as Wrong # 4
Questions / { naga srinivas.kattula }
Questions Answers Category Views Company eMail




Answers / { naga srinivas.kattula }

Question { Four soft, 14054 }

i'm working on progA , in that program i want to see the
userids of the users who work on this program?


Answer

WRKOBJLCK and then F6, then u can see the workstations which
are using that pgm.

Based on the WORKSTATION ID, u can use DSPUSRPRF, u can get
the details of USER

Is This Answer Correct ?    1 Yes 0 No

Question { IBM, 58828 }

How I can reread the physical file in CL program once the
end of file reached in same CL program.


Answer

WE can't read the file again once you reached end of file.
If you want to use the POSDBF command before reaching the
end of file you make to position to starting.Use RTVMBRD, we
get the number of records in the file.Count the number of
records retrieved.When the count becomes equal to number of
records in PF..use POSDBF and make the cursor position to
intial record

Is This Answer Correct ?    0 Yes 0 No


Question { IBM, 58828 }

How I can reread the physical file in CL program once the
end of file reached in same CL program.


Answer

Ovrdbf file name with share

rtvmbrd to get the number of recoeds of file

Pos: Posdbf with positon *first

RCVf file name

count the loops

If no of records of file is equal to no of loops

goto POS

enddo

count+

Is This Answer Correct ?    0 Yes 0 No

Question { IBM, 58828 }

How I can reread the physical file in CL program once the
end of file reached in same CL program.


Answer

Why u need POSDBF? whether u are checking the record in
first file is in second file?

Is This Answer Correct ?    1 Yes 1 No

Question { 7529 }

One of the job in subsystem is in Running status,expected
time to complete this job is 2 minutes.

But from last 5 -10 minutes this job is still in running
status....What are the possible reasons...and What are the
actions i need to perform to check this...?


Answer

1) there may be possibility of depending jobs to be
completed be fore processing the conditions inside the pgm.

For example a printer job have to complete within 2 mins
means inside the file which is updating job have to complete
first.So we need to check the pgm any delay wait
conditions are there inside the pgm and check the jobs of
that pgm completed.

Is This Answer Correct ?    0 Yes 0 No

Question { 6512 }

How do you find whether a record is locked or not?


Answer

using WRKOBJLCK we can check which workstation and pgm
locking the file

Is This Answer Correct ?    3 Yes 1 No

Question { 9289 }

1..Write an sql query to find the employee name who is
having 2 phone numebr?
2.Write an sql query to the the second highest salary of
the employee?


Answer

1. select * from filemame phn1 ne ' ' and phm2 ne ' '
Using above query u can get the which employee have 2 phone
numbers

Is This Answer Correct ?    1 Yes 0 No

Question { Manhattan, 19795 }

1.If *HIVAL SETGT is used what opcode is used to read a
record?
A:READ
B:READPE
C:CHAIN
D:READP
2.How to pass numeric parameter to the rpg pgm from the
command line?
3.What keyword is used on the rpg 4 definition
specification to rename a subfile in an externally
definition data structure?

A:RENAME
B;LIKE
C:EXTNAME
D:EXTFLD


Answer

1)We can use both READP and READPE ..bcz REAP is used to
read the records from bottom to top and READPE reads the
records which are equal to KEY in facor1 from bottom to
top(we get equal records of key value from bottom to top)

Is This Answer Correct ?    0 Yes 1 No

Question { Virtusa, 9435 }

1.Suppose my file has 10 fields and I want to make the 2nd
field Zeros in all records. And assume I have millions of
records and I dont want to read each record and update the
desired field with 0. Any other way to do this in one step
operation?
2. Assume my file has 100 records and I want to see only
first 10 records. Is this possible through LF?
3.I have 3 jobs A B and C. I want to submit B after
successful completion of A and want to submit C after
successful completion of B. Without using job scheduler or
job queue, how can i do that through CL program?
4.What is difference between Bind by copy and bind by reference?


Answer

1)Using SQL, we can set second field value as '0'

2)Based on RRN number we can retrieve the first 10 records
or otherwise copy the first 10 records using CPYF command
and you can use RUNQRY for new created file

3)Write a CL program in which u have to submit the 'A' job
after completion you can write code for 'B' and after 'C'

Is This Answer Correct ?    1 Yes 1 No