Use List Command to sent output into a text file

hew212 · #1 (**permalink**) 07-12-04, 05:13

Can I know use List Command to sent output to a text file?

gurey · #2 (**permalink**) 07-12-04, 08:22

Hi,

OUTPUT TO {"file-name" | PIPE "program-name"}
[WITHOUT HEADINGS] SELECT-statement

hew212 · #3 (**permalink**) 07-13-04, 02:05

can u give me an example?

Quote:

Originally Posted by gurey

Hi,

OUTPUT TO {"file-name" | PIPE "program-name"}
[WITHOUT HEADINGS] SELECT-statement

mjldba · #4 (**permalink**) 07-13-04, 10:02

Hi,

Example of how to generate a pipe "|" delimited text file

unload to "employee_data" delimiter "|"
select name, address,ZIP
from empl_data

tmullins · #5 (**permalink**) 07-13-04, 14:40

Example

OUTPUT TO "table_name.txt" WITHOUT HEADINGS
SELECT tabname
FROM systables
WHERE tabid > 99

hew212 · #6 (**permalink**) 07-14-04, 02:03

Thank you for your help. However, this is the sql Statement.
I wish to know Uniquery "LIST" command. I need to LIST a file call MB.MST and then sent the output to a text file. I can't use SQL cause my unidata does not support the SQL stament.

Quote:

Originally Posted by tmullins

Example

OUTPUT TO "table_name.txt" WITHOUT HEADINGS
SELECT tabname
FROM systables
WHERE tabid > 99

Internet Services

Web Development

Digital Marketing

Consumer Tech