|
View previous topic :: View next topic
|
| Author |
Message |
janmejay
Warnings : 1
New User
Joined: 22 Jun 2007
Posts: 85
Location: bangalore
|
|
|
|
| can we generate a report from a DB2 table using ICETOOL |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| Probably |
|
| Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007
Posts: 2205
Location: San Jose
|
|
|
|
janmejay,
You can unload the DB2 table using DB2 utilities and run the unload file with DFSORT and generate the report. Show us a sample of what the report you want to look like and the table structure. |
|
| Back to top |
|
|
janmejay
Warnings : 1
New User
Joined: 22 Jun 2007
Posts: 85
Location: bangalore
|
|
|
|
Hi
i have a table like which contains employee information.
some of the fields are name , salary , manager name etc. i need to find out the employee names who's comes under every managers. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Sorry, but you have to provide some actual information for people to use to help you.
You need to show the unloaded file layout, some sample data, and the report you want to create.
As Skolusu mentioned, to do this with DFSORT, you must first unload the table. Then a report might be generated from the unloaded data.
Which class might this be homework for? |
|
| Back to top |
|
|
|
|
