Informix

Hmm, that got messed up by the forum software. It should look some thing like this: FRAGMENT BY clause for tables: '-WITH ROWIDS-' |--+-------------+--+- FRAGMENT -+--BY---------------------------> ...

FWIW, here is the text from the SQL Syntax Guide manual page. I have highlighted the contested syntax: FRAGMENT BY clause for tables |--+-------------+--+- FRAGMENT -+--BY---------------------------> '-WITH ROWIDS-' '- PARTITION ' ...

Pradeep: The issue is that the documention says that you can use the keyword PARTITION BY and FRAGMENT BY interchangably and that these two syntaxes areboth acceptable and identical in effect: create table ...( ... ) partition by list ... ...