sulbha bakshi


{ City }
< Country > india
* Profession *
User No # 107421
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 # 0
Users Marked my Answers as Wrong # 0
Questions / { sulbha bakshi }
Questions Answers Category Views Company eMail




Answers / { sulbha bakshi }

Question { IBM, 29383 }

1) How to retrieve RRN through RPG ?
2) How to pass parameter by value ?
3) How to trap the error through the RPG/400


Answer

useing below query:

select rrn(a),a.* from Lib_name/File_name a

Is This Answer Correct ?    0 Yes 0 No

Question { Wipro, 8313 }

how to retrieve particular field records from a physical
file,say i have a physical file called 'employee' in it i
have to retrieve the records of a field 'admin' present in
pf 'employee' using rpg,but i should not use logical file
or openquery file.


Answer

The Opcode Except can be used to partially write the file .It is mainly used to printer files .

Is This Answer Correct ?    0 Yes 0 No


Question { 9967 }

Need a sql query: retrive all duplicate records in table


Answer

File name : FLNM
Field name : FLD

Query :
SELECT FLD ,COUNT(*) FROM FLNM GROUP BY FLD HAVING COUNT(*) > 1

This will give the field values repeatation with the number of times it is been duplicated.

Is This Answer Correct ?    0 Yes 0 No

Question { 2511 }

while i am using the dspmsg command on comman line in Mocha
am getting error like Not authorized to message queue
message my messagequeue Name? can anybody help me how to
change my message queue Am anable to see my messages in
message queue


Answer

Use DSPOBJAUT command to check whether the correct autority has been given to the object.

Is This Answer Correct ?    0 Yes 0 No