createview

createview productline lawsonfilename sqltblname

Generates a SQL statement that creates a view with the fields that Lawson programs require and the correct order for the fields. The statement createview creates is stored in a text file in the current directory. You can edit the statement to handle any data conversions that must be performed. You can then execute the generated statement at your convenience, using your favorite Informix, Oracle, or Sybase utility.