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 *