HP3000-L Archives

September 2009, Week 2

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Catherine Litten <[log in to unmask]>
Reply To:
Catherine Litten <[log in to unmask]>
Date:
Thu, 10 Sep 2009 15:48:54 -0700
Content-Type:
text/plain
Parts/Attachments:
text/plain (30 lines)
Error:  Illegal packed decimal encountered. Please check all data sources
Input File record number:  5413                                                 
ut DBPA203Q.SUPRDATA  
*****
The above is the message I am getting from STExport and it saves 5415 lines (one would be the header).

I know how to look for a specific record line but how do I ignore a line?

I am trying to mass extracts of data and formate them to prn using Suprtool and Stexport - I do this all the time - no problems.

However there are usually criteria for extracting the data.  This time there is no criteria, I basicially want a data dump.  Once again simple.

  {Export Data to Formated File}
exp input SEXTJ1.SUPRDATA
exp Set Ignore On
exp date mmddyyyy
exp delimiter "|"
exp heading fieldnames
exp output DBPA203Q.SUPRDATA
exp xeq

Since I want all the data in the database - someone else on the sql side is weeding out the junk - at this point I would just be happy to skip this record and continue on with the data file build.

________________________________

Catherine Litten , Senior Programmer/Analyst  (818-902-2911  *[log in to unmask]

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2