MVSFORUMS.com

[abc2000]

Using SPUFI or DSNTIAUL , Does a SQL statmement output a row in Multiple line ?

IN SYBASE, we can use char(13) produce newline, for example

select name ,char(13), dbid from sysdatabases

master
1
model
3
sybsystemdb
31513
sybsystemprocs
31514
tempdb
2


select name , dbid from sysdatabases
master 1
model 3
sybsystemdb 31513
sybsystemprocs 31514
tempdb 2

[CZerfas]

The "SPUFI Batch program" DSNTEP2 gives you a formatted report with a line width of 133; therefor you get multiple lines for one data row, if it's length exceeds the output area.

DSNTIAUL gives you one output line per data row.

regards
Christian

[abc2000]

I want a record ouput in contiguous lines, like my example above,
but DSNTEP2 does not


if a field length exceed 133 char, DSNTEP2 will truncate it to 133 chars

Can you tell me some about text format utility for os/390, Thake you!!

[CZerfas]

Well, don't use DSNTEP2, since this program is designed to write output to SYSOUT with all it's characteristics.

Instead of "SPUFI in batch", you can use the unload program DSNTIAUL or you try QMF in batch mode. QMF with it's many format options is quite complicate to use, but gives optimal designed results.

To keep the effort reasonable, I suggest to look at DSNTIAUL.

regards
Christian