>I have a Create table statement which creates a table of about 200 fields. I keep getting a syntax error and I'm guessing it is because the line is so long. How do I use create table when I have a long list of fields?
In addition to the other methods, you could break your create table into 2 or more statements. Then create the final table by combining the two with a select statement.
create table table1 (fld1 as ...)
create table table2 (fld101 as ...)
select * from table1, table2 into finaltable
Used this often with FP 2.6 for large mainframe tables.
Michael McLain