Re: Database related SQL question

} } In article <1osc15INNe40@emory.mathcs.emory.edu> you wrote: } : > with new database name? In this procedure lot of steps are involved, } : > please advise if there is any shourtcut/fast method. } : Unfortunately, you cannot rename a database name. You can do some copies } : to get the same results. I frequently copy databases thru a named pipe. } : } : As Informix: } : mknod pipename p } : chmod 777 pipename } : tbunload -t pipename fromdbname } : on another window: } : tbload -t pipename newdbname } : } : Works like a charm, and is *very* fast! } } Thanks for posting this tip. I think this is dependent on Xwindows, tho, } isn't it? I don't have my System V manuals and my system isn't available to } me right now, so I can't check this out just yet. But the concept can be } implemented with a C program which makes this even more fascinating } to play with. John, I have a PC in my office that connects me to our lan through FTP to our Pyramid MIS-S servers, NCR boxes, AST400's, and the like. I frequently have many sessions running on differnt platforms. To accomplish the copy, I just pull up two sessions on one machine. I cant remember your hardware platform, but you could always just use two terminals (though inconvenient). -- Naomi Walker (aka N7FSA) naomi@anasazi.com Phoenix, Arizona To get the full value of joy, you must have someone to divide it with. ---Mark Twain