refactions1.out

derby database source code.good for you.

C0         |NAME      |MGRNAME   |DNO 
--------------------------------------
1          |ASHOK     |NULL      |K51 
4          |JOE1      |ASHOK     |K51 
5          |JOE2      |ASHOK     |K51 
2          |JOHN      |ASHOK     |K51 
3          |ROBIN     |ASHOK     |K51 
13         |DAN       |ROGER     |K52 
12         |JIM       |ROGER     |K52 
11         |ROGER     |ROBIN     |K52 
14         |SAM1      |ROGER     |K52 
15         |SAM2      |ROGER     |K52 
10         |BOBBIE    |HAMID     |K55 
17         |DON       |GUY       |K55 
16         |GUY       |JOHN      |K55 
6          |HAMID     |JOHN      |K55 
8          |LARRY1    |HAMID     |K55 
9          |LARRY2    |HAMID     |K55 
19         |LILY1     |GUY       |K55 
20         |LILY2     |GUY       |K55 
18         |MONICA    |GUY       |K55 
7          |TRUONG    |HAMID     |K55 
ij> select * from db2test.emp3 order by dno, name, mgrname;
C0         |NAME      |MGRNAME   |DNO 
--------------------------------------
1          |ASHOK     |NULL      |K51 
4          |JOE1      |ASHOK     |K51 
5          |JOE2      |ASHOK     |K51 
2          |JOHN      |ASHOK     |K51 
3          |ROBIN     |ASHOK     |K51 
13         |DAN       |ROGER     |K52 
12         |JIM       |ROGER     |K52 
11         |ROGER     |ROBIN     |K52 
14         |SAM1      |ROGER     |K52 
15         |SAM2      |ROGER     |K52 
10         |BOBBIE    |HAMID     |K55 
17         |DON       |GUY       |K55 
16         |GUY       |JOHN      |K55 
6          |HAMID     |JOHN      |K55 
8          |LARRY1    |HAMID     |K55 
9          |LARRY2    |HAMID     |K55 
19         |LILY1     |GUY       |K55 
20         |LILY2     |GUY       |K55 
18         |MONICA    |GUY       |K55 
7          |TRUONG    |HAMID     |K55 
ij> select * from db2test.emp4 order by dno, name, mgrname;
C0         |NAME      |MGRNAME   |DNO 
--------------------------------------
1          |ASHOK     |NULL      |K51 
4          |JOE1      |ASHOK     |K51 
5          |JOE2      |ASHOK     |K51 
2          |JOHN      |ASHOK     |K51 
3          |ROBIN     |ASHOK     |K51 
13         |DAN       |ROGER     |K52 
12         |JIM       |ROGER     |K52 
11         |ROGER     |ROBIN     |K52 
14         |SAM1      |ROGER     |K52 
15         |SAM2      |ROGER     |K52 
10         |BOBBIE    |HAMID     |K55 
17         |DON       |GUY       |K55 
16         |GUY       |JOHN      |K55 
6          |HAMID     |JOHN      |K55 
8          |LARRY1    |HAMID     |K55 
9          |LARRY2    |HAMID     |K55 
19         |LILY1     |GUY       |K55 
20         |LILY2     |GUY       |K55 
18         |MONICA    |GUY       |K55 
7          |TRUONG    |HAMID     |K55 
ij> select * from db2test.emp5 order by dno, name, mgrname;
C0         |NAME      |MGRNAME   |DNO 
--------------------------------------
1          |ASHOK     |NULL      |K51 
4          |JOE1      |ASHOK     |K51 
5          |JOE2      |ASHOK     |K51 
2          |JOHN      |ASHOK     |K51 
3          |ROBIN     |ASHOK     |K51 
13         |DAN       |ROGER     |K52 
12         |JIM       |ROGER     |K52 
11         |ROGER     |ROBIN     |K52 
14         |SAM1      |ROGER     |K52 
15         |SAM2      |ROGER     |K52 
10         |BOBBIE    |HAMID     |K55 
17         |DON       |GUY       |K55 
16         |GUY       |JOHN      |K55 
6          |HAMID     |JOHN      |K55 
8          |LARRY1    |HAMID     |K55 
9          |LARRY2    |HAMID     |K55 
19         |LILY1     |GUY       |K55 
20         |LILY2     |GUY       |K55 
18         |MONICA    |GUY       |K55 
7          |TRUONG    |HAMID     |K55 
ij> select * from db2test.emp6 order by dno, name, mgrname;
C0         |NAME      |MGRNAME   |DNO 
--------------------------------------
1          |ASHOK     |NULL      |K51 
4          |JOE1      |ASHOK     |K51 
5          |JOE2      |ASHOK     |K51 
2          |JOHN      |ASHOK     |K51 
3          |ROBIN     |ASHOK     |K51 
13         |DAN       |ROGER     |K52 
12         |JIM       |ROGER     |K52 
11         |ROGER     |ROBIN     |K52 
14         |SAM1      |ROGER     |K52 
15         |SAM2      |ROGER     |K52 
10         |BOBBIE    |HAMID     |K55 
17         |DON       |GUY       |K55 
16         |GUY       |JOHN      |K55 
6          |HAMID     |JOHN      |K55 
8          |LARRY1    |HAMID     |K55 
9          |LARRY2    |HAMID     |K55 
19         |LILY1     |GUY       |K55 
20         |LILY2     |GUY       |K55 
18         |MONICA    |GUY       |K55 
7          |TRUONG    |HAMID     |K55 
ij> select * from db2test.emp7 order by dno, name, mgrname;
C0         |NAME      |MGRNAME   |DNO 
--------------------------------------
1          |ASHOK     |NULL      |K51 
4          |JOE1      |ASHOK     |K51 
5          |JOE2      |ASHOK     |K51 
2          |JOHN      |ASHOK     |K51 
3          |ROBIN     |ASHOK     |K51 
13         |DAN       |ROGER     |K52 
12         |JIM       |ROGER     |K52 
11         |ROGER     |ROBIN     |K52 
14         |SAM1      |ROGER     |K52 
15         |SAM2      |ROGER     |K52 
10         |BOBBIE    |HAMID     |K55 
17         |DON       |GUY       |K55 
16         |GUY       |JOHN      |K55 
6          |HAMID     |JOHN      |K55 
8          |LARRY1    |HAMID     |K55 
9          |LARRY2    |HAMID     |K55 
19         |LILY1     |GUY       |K55 
20         |LILY2     |GUY       |K55 
18         |MONICA    |GUY       |K55 
7          |TRUONG    |HAMID     |K55 
ij> select * from db2test.emp8 order by dno, name, mgrname;
C0         |NAME      |MGRNAME   |DNO 
--------------------------------------
1          |ASHOK     |NULL      |K51 
4          |JOE1      |ASHOK     |K51 
5          |JOE2      |ASHOK     |K51 
2          |JOHN      |ASHOK     |K51 
3          |ROBIN     |ASHOK     |K51 
13         |DAN       |ROGER     |K52 
12         |JIM       |ROGER     |K52 
11         |ROGER     |ROBIN     |K52 
14         |SAM1      |ROGER     |K52 
15         |SAM2      |ROGER     |K52 
10         |BOBBIE    |HAMID     |K55 
17         |DON       |GUY       |K55 
16         |GUY       |JOHN      |K55 
6          |HAMID     |JOHN      |K55 
8          |LARRY1    |HAMID     |K55 
9          |LARRY2    |HAMID     |K55 
19         |LILY1     |GUY       |K55 
20         |LILY2     |GUY       |K55 
18         |MONICA    |GUY       |K55 
7          |TRUONG    |HAMID     |K55 
ij> select * from db2test.emp9 order by dno, name, mgrname;
C0         |NAME      |MGRNAME   |DNO 
--------------------------------------
1          |ASHOK     |NULL      |K51 
4          |JOE1      |ASHOK     |K51 
5          |JOE2      |ASHOK     |K51 
2          |JOHN      |ASHOK     |K51 
3          |ROBIN     |ASHOK     |K51 
13         |DAN       |ROGER     |K52 
12         |JIM       |ROGER     |K52 
11         |ROGER     |ROBIN     |K52 
14         |SAM1      |ROGER     |K52 
15         |SAM2      |ROGER     |K52 
10         |BOBBIE    |HAMID     |K55 
17         |DON       |GUY       |K55 
16         |GUY       |JOHN      |K55 
6          |HAMID     |JOHN      |K55 
8          |LARRY1    |HAMID     |K55 
9          |LARRY2    |HAMID     |K55 
19         |LILY1     |GUY       |K55 
20         |LILY2     |GUY       |K55 
18         |MONICA    |GUY       |K55 
7          |TRUONG    |HAMID     |K55 
ij> select * from db2test.emp10 order by dno, name, mgrname;
C0         |NAME      |MGRNAME   |DNO 
--------------------------------------
1          |ASHOK     |NULL      |K51 
4          |JOE1      |ASHOK     |K51 
5          |JOE2      |ASHOK     |K51 
2          |JOHN      |ASHOK     |K51 
3          |ROBIN     |ASHOK     |K51 
13         |DAN       |ROGER     |K52 
12         |JIM       |ROGER     |K52 
11         |ROGER     |ROBIN     |K52 
14         |SAM1      |ROGER     |K52 
15         |SAM2      |ROGER     |K52 
10         |BOBBIE    |HAMID     |K55 
17         |DON       |GUY       |K55 
16         |GUY       |JOHN      |K55 
6          |HAMID     |JOHN      |K55 
8          |LARRY1    |HAMID     |K55 
9          |LARRY2    |HAMID     |K55 
19         |LILY1     |GUY       |K55 
20         |LILY2     |GUY       |K55 
18         |MONICA    |GUY       |K55 
7          |TRUONG    |HAMID     |K55 
ij> select * from db2test.emp11 order by dno, name, mgrname;
C0         |NAME      |MGRNAME   |DNO 
--------------------------------------
1          |ASHOK     |NULL      |K51 
4          |JOE1      |ASHOK     |K51 
5          |JOE2      |ASHOK     |K51 
2          |JOHN      |ASHOK     |K51 
3          |ROBIN     |ASHOK     |K51 
13         |DAN       |ROGER     |K52 
12         |JIM       |ROGER     |K52 
11         |ROGER     |ROBIN     |K52 
14         |SAM1      |ROGER     |K52 
15         |SAM2      |ROGER     |K52 
10         |BOBBIE    |HAMID     |K55 
17         |DON       |GUY       |K55 
16         |GUY       |JOHN      |K55 
6          |HAMID     |JOHN      |K55 
8          |LARRY1    |HAMID     |K55 
9          |LARRY2    |HAMID     |K55 
19         |LILY1     |GUY       |K55 
20         |LILY2     |GUY       |K55 
18         |MONICA    |GUY       |K55 
7          |TRUONG    |HAMID     |K55 
ij> select * from db2test.emp12 order by dno, name, mgrname;
C0         |NAME      |MGRNAME   |DNO 
--------------------------------------
1          |ASHOK     |NULL      |K51 
4          |JOE1      |ASHOK     |K51 
5          |JOE2      |ASHOK     |K51 
2          |JOHN      |ASHOK     |K51 
3          |ROBIN     |ASHOK     |K51 
13         |DAN       |ROGER     |K52 
12         |JIM       |ROGER     |K52 
11         |ROGER     |ROBIN     |K52 
14         |SAM1      |ROGER     |K52 
15         |SAM2      |ROGER     |K52 
10         |BOBBIE    |HAMID     |K55 
17         |DON       |GUY       |K55 
16         |GUY       |JOHN      |K55 
6          |HAMID     |JOHN      |K55 
8          |LARRY1    |HAMID     |K55 
9          |LARRY2    |HAMID     |K55 
19         |LILY1     |GUY       |K55 
20         |LILY2     |GUY       |K55 
18         |MONICA    |GUY       |K55 
7          |TRUONG    |HAMID     |K55 
ij> select * from db2test.emp13 order by dno, name, mgrname;
C0         |NAME      |MGRNAME   |DNO 
--------------------------------------
1          |ASHOK     |NULL      |K51 
4          |JOE1      |ASHOK     |K51 
5          |JOE2      |ASHOK     |K51 
2          |JOHN      |ASHOK     |K51 
3          |ROBIN     |ASHOK     |K51 
13         |DAN       |ROGER     |K52 
12         |JIM       |ROGER     |K52 
11         |ROGER     |ROBIN     |K52 
14         |SAM1      |ROGER     |K52 
15         |SAM2      |ROGER     |K52 
10         |BOBBIE    |HAMID     |K55 
17         |DON       |GUY       |K55 
16         |GUY       |JOHN      |K55 
6          |HAMID     |JOHN      |K55 
8          |LARRY1    |HAMID     |K55 
9          |LARRY2    |HAMID     |K55 
19         |LILY1     |GUY       |K55 
20         |LILY2     |GUY       |K55 
18         |MONICA    |GUY       |K55 
7          |TRUONG    |HAMID     |K55 
ij> select * from db2test.emp14 order by dno, name, mgrname;
C0         |NAME      |MGRNAME   |DNO 
--------------------------------------
1          |ASHOK     |NULL      |K51 
4          |JOE1      |ASHOK     |K51 
5          |JOE2      |ASHOK     |K51 
2          |JOHN      |ASHOK     |K51 
3          |ROBIN     |ASHOK     |K51 
13         |DAN       |ROGER     |K52 
12         |JIM       |ROGER     |K52 
11         |ROGER     |ROBIN     |K52 
14         |SAM1      |ROGER     |K52 
15         |SAM2      |ROGER     |K52 
10         |BOBBIE    |HAMID     |K55 
17         |DON       |GUY       |K55 
16         |GUY       |JOHN      |K55 
6          |HAMID     |JOHN      |K55 
8          |LARRY1    |HAMID     |K55 
9          |LARRY2    |HAMID     |K55 
19         |LILY1     |GUY       |K55