Re: [How do I] export to tab delimited file? Sorry to ask.

Hi, Under dbaccess, run a SQL statement like this: UNLOAD TO '<filename>' DELIMITER '<delimiter>' SELECT * FROM myTable; I'm by no mean Informix people... I'm a humble MSSQL guy just happened to come across the need to dump an Informix table to delimited text file this morning. :-) Thanks, tata. robk@hotmail.com wrote: > Sorry, I am not in the informix groove, so I don't know how to do this, > checked as many places as I could: > > I just want a delimited (I know you informix people are partial to |, but any > delimiter will do for me) select of my table output so I can use it in perl, > but with dbaccess and dbexport I can't figure how to do it. BTW, the table > has a blob field that I need the lvarchar of and I know how to get that, but > then I get field labels for each record in the output from dbaccess. > > Thank you, > > Rob @ > rkasper montgomery.com > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum