|
If your input file has a field that is already packed, do this trick and see what happens: a) Go to "Define Result Fields" b) Define a field c) Use one of the already packed fields you have on the input file (ex. PCKFLD) and do: (PCKFLD * 0) + (Your math expression) d) Run query and create the database. The only note here is that you must allow the query to define the field length it likes. If you set the length (like 11/4) it will create a signed field instead of packed... Peter Vidal PALL Corporation / SR Programmer Analyst, IT Development Group 10540 Ridge Rd., Ste 203, New Port Richey, FL 34654-5111 http://www.pall.com "The leading rule for a man of every calling is diligence; never put off until tomorrow what you can do today" Abraham Lincoln
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
