Split Terminal windows on Snow Leopard

Question

I have a problem writing HQL. The problem is that I want something like this to be transferred to HQL

 select 
   tb.aca_year, 
   (case when tw.isfulltime = 1 then count(te) end) as fulltime,
   (case when tw.isfulltime = 0 then count(te) end) as parttime
 from timetable tb, teacher te, teacherworktype tw 
  where .............
  group by tb.aca_year
 ................

any suggestion please?

Best Regards,

Solution 1

You're misinterpreting the feature. It's not meant for two separate terminals. It's intended to allow a user to see two different view points in the same terminal. For instance, if you have 3000 files in a directory, and you perform an ls command, that output is going to be very long.

If you use the split pane, you can scroll through that long output without having to flip back and forth, possibly losing your place along the way.

If you want two terminals, use tabs, or separate windows.

Solution 2

I think what you are looking for is the 'screen' command. Take a look at its man page. It basically allows you to have several virtual "screens" within one terminal window (without tabs or multiple windows).

Quick start: execute command 'screen' in your terminal, press return, then press CTRL+A CTRL+C to open a new screen, then press CTRL+A CTRL+A to switch between the 2 screens you just created.

Take a look at this podcast for a nice explanation (the stuff about 'screen' is at 3:10 in the video): http://movies.apple.com/datapub/us/podcasts/leopardserverquicktours/quicktours-31-terminal_tips.m4v

Solution 3

The split pane function does exactly what it does in a text editor: splits your current terminal window in half and lets you scroll each half separately.

It's extremely useful when you want to look at the output of an earlier command while continuing to interact with the command line. Much easier than scrolling up and down between two sections!

Comments

[Stefan Steinegger]

You can't write HQL without knowing the class model. So tell us something about your classes...

[Nathanphan]

Thank for concerning my question. However, those classes are very long. could you please base on my question to help me?

[Stefan Steinegger]

I'm confused. How can case when tw.isfulltime actually work when it is neither in an aggregate function nor is tw.isfulltime in the group by clause ... ?

[alexus]

right, although i can't control each half of the terminal separately, for me it works like a mirror, whatever i do in one part it does same thing in another... how can I actually control each of them separately?

[alexus]

i hope apple make it both of them to act as in depended from each other

[s4y]

It's only useful when one pane is scrolled up. What else do you want to control separately?

[kkyy]

It is clearly for when you want to see something you have done earlier, and enter new commands at the same time.

[Dan Rosenstark]

This is the best guide to using screen EVER. Anything else is just too complex to even try it out.

[Chris Page]

Please file an enhancement request at bugreport.apple.com if you want to let Apple know that "tiled" terminals is an important feature to you.