|
Phil, The problem is small integer and 4 digit binary look the same on the physical file (2 byte binary data) The DSPFFD while show a 2 byte binary field as a 4 digit binary field Prompt this same field within ISQL and it is a Small Integer Operations Navigator will show this field as a Small Integer Place this in your h-spec in your RPG program and they will see 2 byte binary as small integer and 4 byte binary as Integer H EXTBININT(*YES) AND work with them as (5 I 0) and (10 I 0) A small integer WILL hold 32767 A Integer WILL hold 2147483647 I can work with these data types successfully with RPGLE and SQL NOT the DAM SQL pre-compiler >>> sublime78ska@yahoo.com 03/11/02 06:15PM >>> The file created with CREATE TABLE defines the INTEGER data type as 9B 0. Try it out, then do DSPFFD. I don't think it's the precompiler. Phil > -----Original Message----- > From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]On > Behalf Of Andrew Lutz > Sent: Monday, March 11, 2002 4:12 PM > To: < > Subject: Integers with embedded SQL problem > > > > All, > > I have this situation where the pre-compiler insists that small > integer is 4B0 and interger is 9B0 > > Has anyone found out how to insert the value that a small integer > is capable of (32676) via embedded SQL? > > > > > _______________________________________________ > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list > To post a message email: RPG400-L@midrange.com > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l > or email: RPG400-L-request@midrange.com > Before posting, please take a moment to review the archives > at http://archive.midrange.com/rpg400-l. > _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com _______________________________________________ This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l or email: RPG400-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.
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.