Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export to ASCII file in SQL statement

Status
Not open for further replies.
stuartd

stuartd

Programmer
Jan 8, 2001
146
US
I am trying to export a table to an ASCII file in Stored procedure using Informix 7.24 on UNIX box.

I found 'OUTPUT TO {file} SELECT statement' and 'UNLOAD TO {file} SELECT statement' on but these both give me errors.

Any ideas?
 
Status
Not open for further replies.

Similar threads

Harami12
  • Locked
  • Question
Where to Next in Programming 2
Replies
2
Views
535
Andrzejek
Andrzejek
LuciusThorne
  • Locked
  • Question
Database Design - Reusing one-to-many relationship in a table?
Replies
4
Views
603
mintjulep
M
RasaBu
  • Locked
  • Question
Hello, I need to create a FoxPro
Replies
1
Views
439
Mike Lewis
Mike Lewis
dwf1962
  • Locked
  • Question
Trying to write a simple Foxpro prog to convert database of probabilities to a life expectancy table
Replies
1
Views
462
SkipVought
S
bghosh
  • Locked
  • Question
Blank Lines in SQLPLUS output.
Replies
0
Views
427
bghosh
bghosh

Part and Inventory Search

Sponsor

Back
Top