What is the difference between m_mkfs and m_touch. Both create a MFS how do they differ ? Also what is the syntax for creating MFS using m_touch

balu

• Oct 6th, 2012

M_mkfs: to create a multifie system
m_touch: to create a empty file system

RAM

• Aug 17th, 2012

M_mkfs will creates a multifile system
M_touch will creates empty multifile

Answer Question  Select Best Answer

Hi, I have 3 files each having 2 cols e.g File1 empid deptid 1 100 2 200 3 200 4 100 5 300 File2 empid salary 1 10 2 20 3 30 4 40 5 50 6 60 File3 deptid deptname 100 A 200 B 300...

chandrasekhar

• May 10th, 2012

1.Perform inner join for both file1 & file2
2.perform sort on dept id then do Roll up
3.perform inner join for roll up o/p and file3
4.finally you will get required result

Answer Question  Select Best Answer

Hi, I have 3 files each having 2 cols e.g File1 empid deptid 1 100 2 200 3 200 4 100 5 300 File2 empid salary 1 10 2 20 3 30 4 40 5 50 6 60 File3 deptid deptname 100 A 200 B 300...

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Mar 2nd, 2012

I believe what you are looking for is a query like this:

select f3.deptname dept_name, sum(isnull(f2.salary,0)) amt_spent_each_dept
from file3 f3 left join file1 f1 on (f3.deptid = f1.deptid)
left join file2 f2 on (f1.empid = f2.empid)
group by f3.deptname
order by f3.deptname

Answer Question  Select Best Answer

Hi, I have 3 files each having 2 cols e.g File1 empid deptid 1 100 2 200 3 200 4 100 5 300 File2 empid salary 1 10 2 20 3 30 4 40 5 50 6 60 File3 deptid deptname 100 A 200 B 300...

PLMS

• Mar 29th, 2013

Step 1: File1 - left outer Join {Key- empid} with -File2 Step 2: The above output flow should be sort{PBKS-if multifile} based on key empid Step 3: The step 2s o/p flow to be left outer joi...

Malini

• Apr 3rd, 2012

Code
  SELECT C.DEPTNAME,sum(B.SALARY) FROM FILE1 A ,FILE2 B ,FILE3 C
  WHERE A.EMPLID=B.EMPLID AND A.DEPTID=C.DEPTID
  GROUP BY C.DEPTNAME

Answer Question  Select Best Answer