title: RUNSQLSTM - on IBM i - create or append data
body: <p>Is there syntax to perform a create or append in single statement.</p>
  
  <pre><code>CREATE TABLE MYLIB/MYFILE AS (                   
  
       SELECT                                            
       FIELD12,
       FIELD22,
       FIELD02,                                           
       FIELD23
      FROM MYLIB/MYDATA )
  WITH DATA;   
  
  
  RUNSQLSTM SRCFILE(MYLIB/QSQLSRC) SRCMBR(MYSQLSRC) 
  </code></pre>