|
Ricky, Have you looked at the file with DSPPFM and display hex with F10? Perhaps that tells you more. I assume the file has been created with SQL. DDS based files do not support integer data types (, yet). Regards, Carel Teijgeler. *********** REPLY SEPARATOR *********** On 15-11-05 at 12:43 Ricky Thompson wrote: >I created a DB on the ISeries to match a MS SQL Server database so that we >could create a DTS package to transfer data between the two systems. The >problem is the SQL Server number in a integer field is 10 long but when we >transfer it to the AS/400 it drops the first position. If you do a RUNQRY >on the file it replaces the integer value with ******. I thought an integer >was from -2147483648 to +2147483647.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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.