Hi All,

While extracting the data fron the FOCUS database and put into the flat file, I want delimit each field with delimiter"~". Can any one help me, how to separate the data with delimiter in the O/P file. I am extracting the data with segment wise.

TABLE FILE EMPLOYEE
PRINT EMPNBR
SEG.EMPNBR
SEG.EMPNAME
SEG.EMPNAM1
SEG.EMPBRANCH

Thanks,
Rajesh

Should be pretty straightforward. Here's one solution:

DEFINE FILE EMPLOYEE
DELIM/A1='~';
END
TABLE FILE EMPLOYEE
PRINT
EMPNBR DELIM
EMPNAME DELIM
EMPNAM1 DELIM
.
.
ON TABLE HOLD FORMAT ALPHA
END

If I print Field by Field its creating some issue when the number of fields are more. Hence I wanted to print all the fields in the segment using seg.. In this scenario is there any command to delimit the fields in the segment, even though I am printing the whole segment at once.

Thanks
Rajesh

I don't think so. The only way to get something in between fields in a flat file is to put it there yourself. If this is relating to your other post on getting data into SQL server, just try
TABLE FILE filename
PRINT *
ON TABLE HOLD FORMAT SQLMSS
END

without knowing limitations of your platforms or environments, of course.

Another way, is do a HOLDFORAT TAB or COM. Then have a .MAS that describes the data as one field. Use the CTRAN function to convert the tabs or commas to ~.