Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2003
    Posts
    26

    Question Unanswered: Use List Command to sent output into a text file

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

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

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

  3. #3
    Join Date
    Dec 2003
    Posts
    26
    can u give me an example?

    Quote Originally Posted by gurey
    Hi,

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

  4. #4
    Join Date
    Dec 2003
    Location
    North America
    Posts
    146

    example

    Hi,

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

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

  5. #5
    Join Date
    Aug 2003
    Posts
    68
    Example

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

  6. #6
    Join Date
    Dec 2003
    Posts
    26
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •