Re: Backspacing in input

In article <C6yFps.85C@informatik.uni-muenchen.de> spitz@ana.med.uni-muenchen.de writes: > >One other SINIX enhancement in 2.1 that was dropped in 4.0 was the >load from/unload to PIPE. I really liked that nifty feature, since >it allowed statements like > > load from pipe "rsh remotehost file | awk 'something' | sed 'anything' "> >and so on. Is there a chance to include that in future versions of >INFORMIX? Does SINIX have named pipes? If so, they could achieve the same effect. In case you're not familiar with them (I just learned about them myself from the recent thread on unattended backups :-), here's how to do what you want in SCO. (In SCO, named pipes are created with "mkfifo", and "rsh" is called "rcmd"). <from the shell> mkfifo /tmp/my_fifo rcmd remotehost "file | awk 'something' | sed 'anything'" > /tmp/my_fifo & isql load from pipe "/tmp/my_fifo" insert into ... <exit isql> rm /tmp/my_fifo This is not an excuse for "load from pipe ..." not being part of isql. It seems like an obvious feature (and it should only take Informix a line or two of code to implement). -- Bill Foote bill@pds.com PDS Corp, Los Angeles, CA USA uunet!promdist!bill