Thanks Neil - I'm trying this.
________________________________
Catherine Litten , Senior Programmer/Analyst (818-902-2911 *[log in to unmask]
Please consider the environment before printing this email.
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf Of Neil Armstrong
Sent: Thursday, September 10, 2009 5:10 PM
To: [log in to unmask]
Subject: Re: Suprtool / STExport Illegal Packed Decimal
At 06:48 PM 10/09/2009, Catherine Litten wrote:
My suggestion would be to fix the data at the source as we have no way of skipping data inside STExport, but rather on the initial Suprtool extract. I would look to the packed fields and just use Suprtool output,prn to weed out the records, I added set zonedfix to do some data fixups, I can look at extending to packed, but at this time you would need to use Suprtool to skip the records. Having said that I always advocate fixing at the source as the "sql side"
typically imports all the data more than once. :)
Sincerely,
Neil
>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 *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
