Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 10781 Views
- I also Faced
- E-Mail Answers
Answer Posted / naga srinivas.kattula
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 |
Post New Answer View All Answers
what is the use of sflnxtchg?
are there any useful c runtime apis that I can call from rpg iv?
Please tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.
What is difference between bind by copy and bind by reference?
during execution, an rpg/400 program automatically follows a sequence of operations for each record that is processed. The built-in program cycle includes the following logical steps.
If my rpg program has a date field, what extra care I have to take while compiling that rpg program? If the file is keyed and I have declared the file as well as key list properly in my program. Still am getting an error message like "chain/reade operation is not allowed" what may be the case?
Interviewer asked me write down DDS for load all subfile .can anybody write dds
Explain mdt?
How to write record if no field or the field are different in physical file in rpgle ?
What is a record lock error?
how can I tell when to replace the array?
How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...
what is a rpg?
explain sflclr, sflend, sfldlt, and sflcsrrrn?
what do you mean by an input subfile, what are the keywords required?
