RE: SQLRPGLE

That won't work...%EDITC converts the number to a character.  Any
numeric field MUST use a numeric value any attempt to add the numeric to
the string will cause SQL precompile to fail since '000002' is not the
same as 2. 


Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Michael_Schutte@xxxxxxxxxxxx
Sent: Monday, August 14, 2006 9:25 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: SQLRPGLE

%EditC should work... maybe you're just not using it right, make sure
it's
outside of the string.

SQLString = 'Select * from file where number = ' +
%EditC(hostnumber:'Z');

Then for executing it, please look into the SQL reference manual using
the
PREPARE statement.  The manual can be found on the IBM website.

Thanks.

Try our New Country Benedicts -- Breakfast with a Bob Evans twist!



 

             Matt Gross

             <prrgg1@sbcglobal

             .net>
To 
             Sent by:                  Post AS-400 Language Questions

             rpg400-l-bounces@         <rpg400-l@xxxxxxxxxxxx>

             midrange.com
cc 
 

 
Subject 
             08/14/2006 10:10          SQLRPGLE

             AM

 

 

             Please respond to

              RPG programming

              on the AS400 /

                  iSeries

             <rpg400-l@midrang

                  e.com>

 

 





I am trying to build a string containing an SQL statement, which will be
doing an INSERT INTO operation.

  I'm running into a problem when one of the fields will contain numeric
data.  The compile error is that "Operands are not compatible".

  I've tried a number of techniques to use the syntax with %NUM and
%EDITC,
but I'm still having problems.

  Any help/example appreciated.

  Also, on the EXEC SQL statement, how would I execute a string?

  Thanks,

  Matt
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.