Answer / raj

Q1:

Q2: select max(SAL) from EMP_TAB where SAL < (select max
(SAL) from EMP_TAB

Answer / vaishali zindal

2)select Max(salary)from Employee where salary NOT IN
(select Max (salary)from Emaployee)

Answer / 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

Answer / s kumar

Q1:select Emp_name from Table-Name group by Emp_name having
count(Phone)=2

Hope it'll work out.

When it is desirable to describe files Internally?

0 Answers  

---

thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400

0 Answers   iGate,

---

1. What is bound-by-call and bound-by-reference? 2. Where and why is *Nomain used? 3. What are the difficulties faced by programmers when using service programs? 4. Explain the different ways of parsing and compiling XML in iSeries.

2 Answers  

---

what is *place and *auto keyword in prtf ?plz explain

0 Answers   CSC,

---

How to check which are the pgms using 1 perticulate file.? I know there is many tool available for X-reference...but need to know is there any command available in the system...?

4 Answers   IBM,

---

What does Implicit Open means with respect to a file ? What about the Explicit Open?..what are the major differences between these two?

1 Answers   IBM,

---

The PGMA calls PGMB.PGMB generates a report.The report should contain the called program name(PGMA).How do i get the called program name in PGMB to print it on the spool file?(calling program name should NOT be hard coded or passed as parameter to called program?

6 Answers  

---

What is I90(Insure 90)?

1 Answers  

---

What is Multi Occurrence Data Structure(MODS)?

1 Answers   CTS,

---

Hi, Can anybody give me real sinario for SFLRCDNBR?with example?

2 Answers  

---

can you debug ile rpg program using isdb?

0 Answers   IBM,

---

what is the use of sflnxtchg?

0 Answers   IBM,

---