Midrange News for the IBM i Community

Posted by: Ralph Miller
Contract RPG Legacy Programmer
Franklin, TN
has no ratings.
Published: 02 Feb 2014
Revised: 03 Feb 2014 - 1773 days ago
Last viewed on: 11 Dec 2018 (3755 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

SQL7008 Published by: Ralph Miller on 02 Feb 2014 view comments(4)

We are experiencing an issue with tables created on the iSeries using sql and a pc connection(ODBC).
The table gets created but the programmer gets an error msg sql7008 when trying to update(insert) the table.
If the table is recreated using DDS instead of sql - the problem goes away. This seems to only occur
when the table contains integer fields. If all the fields are char, no problem. Thanks. (V7R1)

Return to midrangenews.com home page.
Sort Ascend | Descend