Re: SQLRPGLE

I think what you need to do is declare numeric fields to receive the numeric 
data. Built-in functions can't be used in SQL statements.

To execute a string you would use the PREPARE SQL statement.
  ----- Original Message ----- 
  From: Matt Gross 
  To: Post AS-400 Language Questions 
  Sent: Monday, August 14, 2006 10:10 AM
  Subject: SQLRPGLE 


  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.