Midrange News for the IBM i Community

Posted by: rpgprogrammer
Vancouver, BC
has no ratings.
Published: 31 Jul 2012
Revised: 23 Jan 2013 - 3448 days ago
Last viewed on: 27 Jun 2022 (4986 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.

SQLRPG Published by: rpgprogrammer on 31 Jul 2012 view comments(6)


I am trying to execute below command through SQLRPGLE I get below error

Data mapping error on member SRC1.

C                  EVAL      W0STAMT = 'CREATE ALIAS QTEMP/TEMPFILE1 FOR '      
C                                   + %TRIM(MLLIBN) + '/' + %TRIM(MLSFIL)       
C                                     + ' (' + %TRIM(MLNAME) + ')'              


In Debug mode once the above command is executed, I go to STRSQL and do a Runqry in TEMPFILE1 I see above error message.

What I notice is for other source SRCDAT has some value while for the source in error the value of SRCDAT = ++++++ as seen above.

Can some one help to know why I am getting Data Mapping Error for this source(SRC1)?  For other sources it is working file.

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