Oracle on VMS - Spooled output, three lines per row
Date: Tue, 23 Feb 1999 17:11:30 GMT
Message-ID: <36d2dbd5.1594142_at_news.abbott.com>
I'm running Oracle 7.1.5 and SQL/Plus 3.1 and trying to solve a problem creating a VMS file while spooling table rows from SQL/Plus.
This table has column widths totalling 396 characters (398 in the file because the date field is 7 chars table width but prints/displays 9 chars) due mainly to a 360 character wide comment column. When I spool the rows I get three lines in the file per row of the table and I want only one line per row.
The first few columns and the comment are on the first line of the file, the second line has 9 spaces (which I don't understand) and then the data from the remaining two columns. The third line is all spaces.
My SQL routine has the usual things:
set newpage 0, space 0, linesize 398, pagesize 0, echo off, feedback
off, heading off, and term off. Then spool filename; select * from
table; truncate table; and commit.
The VMS file that gets created is stream-lf, no max record size, longest record 32,767 bytes (which I don't quite understand). When I set my physical terminal for nowrap and set term/width=400 and I type the file I see three lines of output for each table row. The set linesize command dutifully puts space fill in up to the 398th character position. I wish set trimout on worked with spooled output.
Using the dump command I see no record terminators except a line-feed character after each 398th character.
I FTP-ed the file to my PC and used a text editor (TextPad) which can handle rows of up to 4096 characters. In both ascii mode and binary mode (like dump) I see the same things I see in VMS.
The table description and exact SQL statements can be supplied.
Does anyone know why this is and how to solve the problem?
TIA,
Jim Jelke
Received on Tue Feb 23 1999 - 18:11:30 CET