IBM®
Skip to main content
    Country/region [select]      Terms of use
 
 
      
     Home      Products      Services & solutions      Support & downloads      My account     

developerWorks > Sample IT projects >
developerWorks
Using XML and XSL for code generation
Listing 1

Return to article.

 <?xml version="1.0" encoding="UTF-8"?> 
<Project name="PersonList" Dir="C:\DB2 Everyplace\ApplicationBuilder\Samples\PersonList\" version="7.1.1"> 
 <Tables name="Tables"> 
   <Table name="VNPerson" DatabaseName="Database" DatabaseType="DB2"> 
     <Column name="ID" DataType="Char" DataLength="9" PrimaryKey="yes"/> 
     <Column name="Name" DataType="Varchar" DataLength="40" PrimaryKey="no"/> 
     <Column name="Address" DataType="Varchar" DataLength="50" PrimaryKey="no"/> 
     <Column name="City" DataType="Varchar" DataLength="25" PrimaryKey="no"/> 
     <Column name="HomePhone" DataType="Varchar" DataLength="20" PrimaryKey="no"/> 
     <Column name="WorkPhone" DataType="Varchar" DataLength="20" PrimaryKey="no"/> 
     <Column name="MobilePhone" DataType="Varchar" DataLength="20" PrimaryKey="no"/> 
   </Table> 
 </Tables> 
 <Application name="Palm OS" Target="Palm OS" StartupForm="Person " ApplID="DBA2"> 
   <Forms name="Forms"> 
     <Form name="Person "> 
       <Property name="Name" Value="Person_" ValueType="Name"/> 
       <Property name="Caption" Value="Person "/> 
       <Property name="Left" Value="0" ValueType="Integer"/> 
       <Property name="Top" Value="0" ValueType="Integer"/> 
       <Property name="Width" Value="160" ValueType="Integer"/> 
       <Property name="Height" Value="160" ValueType="Integer"/> 
       <Property name="Modal" Value="False" ValueType="Boolean"/> 
       <Property name="MenuID" Value="" ValueType="Default"/> 
       <Property name="DataSource" Value="" ValueType="DynamicChoice"/> 
       <Property name="DataField" Value="" ValueType="DynamicChoice"/> 
       <Property name="LinkSource" Value="" ValueType="DynamicChoice"/> 
       <Property name="LinkField" Value="" ValueType="DynamicChoice"/> 
       <Event name="Form Init" Action="No Action" Value="Form Init"/> 
       <ControlInstance name="Label1Form3" type="Label"> 
         <Property name="Name" Value="Label1Form3" ValueType="Name"/> 
         <Property name="Caption" Value="ID" ValueType="" Constraints=""/> 
         <Property name="Font" Value="FONT 0" ValueType="PalmFont" Constraints=""/> 
         <Property name="Usable" Value="USABLE" ValueType="Usable" Constraints=""/> 
         <Property name="Left" ValueType="Integer" Constraints="0-158" Value="11"/> 
         <Property name="Top" ValueType="Integer" Constraints="0-158" Value="18"/> 
         <Property name="Width" ValueType="Integer" Constraints="2-160" Value="53"/> 
         <Property name="Height" ValueType="Integer" Constraints="2-160" Value="11"/> 
    </Form> 
   </Forms> 
   <Scripts name="Global Scripts"/> 
   <Alerts name="Alerts"/> 
   <Strings name="Strings"/> 
   <Menus name="Menus"/> 
   <Menubars name="MenuBars"/> 
   <Icon name="Icon"> 
     <Property name="Name" Value="Icon" ValueType="Name"/> 
     <Property name="IconFileName" Value="pabappic.bmp" ValueType="Default"/> 
   </Icon> 
   <Bitmaps name="Bitmaps"/> 
   <Preferences name="Preferences"> 
     <Preference name="Build" buildMode="debug" multicode="true" copyProtection="false"/> 
   </Preferences> 
   <SQL name="DefaultSelectTable1" generated="yes"> 
     <![CDATA[SELECT ID, Name, Address, City, HomePhone, WorkPhone, MobilePhone FROM VNPerson ]]> 
   </SQL> 
   <SQL name="DeleteTable1" generated="yes"> 
     <![CDATA[DELETE FROM VNPerson WHERE ID=? AND Name=? AND Address=? AND City=? AND HomePhone=? AND WorkPhone=? AND MobilePhone=? ]]> 
   </SQL> 
   <SQL name="CreateTable1" generated="yes"> 
     <![CDATA[INSERT INTO VNPerson (ID,Name,Address,City,HomePhone,WorkPhone,MobilePhone) VALUES (?,?,?,?,?,?,?) ]]> 
   </SQL> 
   <SQL name="UpdateTable1" generated="yes"> 
     <![CDATA[UPDATE VNPerson SET Name=?,Address=?,City=?,HomePhone=?,WorkPhone=?,MobilePhone=? WHERE ID=? ]]>   </SQL> 
 </Application> 
</Project> 



developerWorks > Sample IT projects >
developerWorks
  About IBM  |  Privacy  |  Terms of use  |  Contact