Index: rules/annotations/database_general.rules
===================================================================
--- rules/annotations/database_general.rules	(revision 2287)
+++ rules/annotations/database_general.rules	(working copy)
@@ -215,6 +215,12 @@
    <variable name="supConnOpts"     type="java.util.Map" />
    <variable name="iter"            type="java.util.Iterator" />
    
+   <variable name="createAndAssign"         type="com.goldencode.ast.Aast" />
+   <variable name="createAndAssignBuf"      type="java.lang.String" />
+   <variable name="createAndAssignFields"   type="java.util.List" />
+   <variable name="createAndAssignLiterals" type="java.util.List" />
+   <variable name="idx"                     type="java.lang.Integer" />
+
    <!-- expression libraries -->
    <include name="common-progress" />
    
@@ -315,6 +321,10 @@
       
       <rule>connOpts = create("java.util.ArrayList")</rule>
       
+      <rule>createAndAssign = null</rule>
+      <rule>createAndAssignBuf = null</rule>
+      <rule>createAndAssignFields = null</rule>
+      <rule>createAndAssignLiterals = null</rule>
    </init-rules>
    
    <walk-rules>
@@ -975,10 +985,67 @@
          <action>copy.remove()</action>
       </rule>
       
+      <!-- special processing for this template, where 'tt1' is a temp-table:
+           create tt1. assign tt1.f1 = 1 tt1.f2 = "a" t1.f3 = no.
+           -->
+      <rule>this.type == prog.kw_create and parent.type == prog.statement
+         <action>ref = this.firstChild</action>
+         <rule>ref.type == prog.temp_table
+            <action>ref2 = parent.parent.getChildAt(parent.indexPos + 1)</action>
+            <rule>ref2.type == prog.statement and ref2.downPath("KW_ASSIGN/ASSIGN")
+               <action>createAndAssign = copy</action>
+               <action>createAndAssignBuf = ref.getAnnotation("bufname")</action>
+               <action>createAndAssignFields = create("java.util.ArrayList")</action>
+               <action>createAndAssignLiterals = create("java.util.ArrayList")</action>
+            </rule>
+         </rule>
+      </rule>
+      
+      <rule>createAndAssign != null              and 
+            evalLib("fields")                    and
+            upPath("STATEMENT/KW_ASSIGN/ASSIGN") and
+            getNoteString("bufname") == createAndAssignBuf
+         <action>createAndAssignFields.add(this.id)</action>
+         
+         <action>ref = this.parent.getChildAt(1)</action>
+         <rule>ref.type == prog.expression
+            <action>ref = ref.firstChild</action>
+            <rule>evalLib("literals", ref.type)
+               <!-- only assign to literal works -->
+               <action>createAndAssignLiterals.add(ref.id)</action>
+               
+               <action on="false">createAndAssign = null</action>
+               <action on="false">createAndAssignBuf = null</action>
+               <action on="false">createAndAssignFields = null</action>
+               <action on="false">createAndAssignLiterals = null</action>
+            </rule>
+         </rule>
+      </rule>
    </walk-rules>
    
    <ascent-rules>
-   
+      <rule>createAndAssign != null and relativePath("STATEMENT/KW_ASSIGN")
+         <!-- save as annotations all the field and literal AST IDs -->
+         <action>copy.parent.setHidden(true)</action>
+         
+         <action>idx = 0</action>
+         <while>idx &lt; createAndAssignFields.size()
+            <action>
+               createAndAssign.putAnnotation("create_and_assign_fields", 
+                                             #(java.lang.Long) createAndAssignFields.get(idx), 
+                                             -1)
+            </action>
+            <action>ref = getAst(#(java.lang.Long) createAndAssignLiterals.get(idx))</action>
+            <action>ref.move(createAndAssign, -1)</action>
+            <action>idx = idx + 1</action>
+         </while>
+         
+         <action>createAndAssign = null</action>
+         <action>createAndAssignFields = null</action>
+         <action>createAndAssignLiterals = null</action>
+         <action>createAndAssignBuf = null</action>
+      </rule>
+      
       <rule>(type == prog.kw_for and getNoteBoolean("quick_delete")) or type == prog.embedded_sql
          <action>unqualFields = false</action>
       </rule>
Index: rules/convert/database_access.rules
===================================================================
--- rules/convert/database_access.rules	(revision 2287)
+++ rules/convert/database_access.rules	(working copy)
@@ -840,7 +840,11 @@
               by database_references.rules), no kw_using support at this time -->
          <rule>type == prog.kw_create
             <action>methodtype = java.method_call</action>
-            <action>methodtxt = "create"</action>
+            
+            <rule>isNote("create_and_assign_fields")
+               <action>methodtxt = "createAndAssign"</action>
+               <action on="false">methodtxt = "create"</action>
+            </rule>
          </rule>
          
          <!-- delete language statement (record parameter will be emitted
@@ -2288,6 +2292,22 @@
    </next-child-rules>
    
    <ascent-rules>
+      <rule>type == prog.kw_create and isNote("create_and_assign_fields")
+         <!-- emit the field names followed by the literals -->
+         <action>idx = 0</action>
+         <while>idx &lt; this.annotationSize("create_and_assign_fields")
+            <action>
+               ref = getAst(#(java.lang.Long) this.getAnnotation("create_and_assign_fields", idx))
+            </action>
+            <action>
+               createJavaAst(java.string, 
+                             #(java.lang.String) ref.getAnnotation("fieldname"),
+                             closestPeerId,
+                             idx + 1)
+            </action>
+            <action>idx = idx + 1</action>
+         </while>
+      </rule>
       
       <!-- restore query name state at top level can-find -->
       <rule>(type == prog.func_logical and getNoteLong("oldtype") == prog.kw_can_find)
Index: src/com/goldencode/p2j/persist/Buffer.java
===================================================================
--- src/com/goldencode/p2j/persist/Buffer.java	(revision 2287)
+++ src/com/goldencode/p2j/persist/Buffer.java	(working copy)
@@ -519,6 +519,8 @@
     */
    public void create();
    
+   public void createAndAssign(Object... fieldsAndLiterals);
+   
    /**
     * Delete the record currently in the buffer, if any.
     *
Index: src/com/goldencode/p2j/persist/BufferImpl.java
===================================================================
--- src/com/goldencode/p2j/persist/BufferImpl.java	(revision 2287)
+++ src/com/goldencode/p2j/persist/BufferImpl.java	(working copy)
@@ -1244,6 +1244,24 @@
       buffer().create();
    }
    
+   @Override
+   public void createAndAssign(Object... fieldsAndLiterals)
+   {
+      RecordBuffer buffer = buffer();
+      buffer.create();
+      RecordBuffer.batch(() ->
+      {
+         int size = fieldsAndLiterals.length / 2;
+         for (int i = 0; i < size; i++)
+         {
+            String field = (String) fieldsAndLiterals[i];
+            Object value = fieldsAndLiterals[i + size];
+            
+            // TODO: field is DMO property... not legacy
+         }
+      });
+   }
+   
    /**
     * Delete the record currently in the buffer, if any.
     *