How to create a pipe delimited file using WebFOCUS

How to create a pipe delimited file using WebFOCUS

book

Article ID: KB0070555

calendar_today

Updated On:

Products Versions
ibi WebFOCUS 8105 and above

Description

How to create a pipe delimited file using WebFOCUS

Issue/Introduction

How to create a pipe delimited file using WebFOCUS

Environment

Any

Resolution

To add a pipe separator between fields in an alpha hold file use the following command.
ON TABLE PCHOLD AS PIPE1 FORMAT DFIX DELIMITER | ENCLOSURE "

EX: 

TABLE FILE CAR
SUM SALES
BY COUNTRY
ON TABLE PCHOLD AS PIPE1 FORMAT DFIX DELIMITER | ENCLOSURE "
END