Program
--------
> project <- odbcConnect("spds.project", believeNRows=FALSE, colQuote=NULL, uid=spdsuser, pwd=spdspw)
> pccf<-sqlQuery(common,"select postal, lat, long  from pccf_1996")
> newpccf<-data.frame(pccf[1:10,1:3])
> colnames(newpccf) <- c("postal","long","lat")
> View(newpccf)
> sqlSave(project,newpccf,"project.testpccf", rownames=FALSE, fast=FALSE)
> sqlDrop(project,"project.testpccf")

R Console Log with SPDS returned errors and notes.
-------------------

> project <- odbcConnect("spds.project", believeNRows=FALSE, colQuote=NULL, uid=spdsuser, pwd=spdspw)
> pccf<-sqlQuery(common,"select postal, lat, long  from pccf_1996")

> newpccf<-data.frame(pccf[1:10,1:3])
> colnames(newpccf) <- c("postal","long","lat")
> View(newpccf)
> sqlSave(project,newpccf,"project.testpccf", rownames=FALSE, fast=FALSE)
  SPDS_ERROR: Parse Failure: invalid dictionary member
  SPDS_NOTE: Correct Syntax for select expression is:
  SPDS_NOTE: SELECT objlist 
             FROM tablelist 
             [ WHERE boolean_expr ] 
             [ GROUP BY scalar_expr { ',' scalar_expr }*  ] 
             [ HAVING boolean_expr ] 
             [ ORDER BY atomic_expr [ ASC | DESC ] 
                  { ',' atomic_expr [ ASC | DESC ] }* ]
  SPDS_ERROR: Parse Failure: select value from #dictionary.macros where (name = 'SYSVLONG');
 
 SPDS_ERROR: SQL passthru expression contained errors.
  SPDS_ERROR: Parse Failure: invalid dictionary member
  SPDS_NOTE: Correct Syntax for select expression is:
  SPDS_NOTE: SELECT objlist 
             FROM tablelist 
             [ WHERE boolean_expr ] 
             [ GROUP BY scalar_expr { ',' scalar_expr }*  ] 
             [ HAVING boolean_expr ] 
             [ ORDER BY atomic_expr [ ASC | DESC ] 
                  { ',' atomic_expr [ ASC | DESC ] }* ]
  SPDS_ERROR: Parse Failure: select "&sysvlong" as version from #dictionary.options where optname='LINESIZE';
 
 SPDS_ERROR: SQL passthru expression contained errors.
  SPDS_ERROR: Parse Failure: invalid dictionary member
  SPDS_NOTE: Correct Syntax for select expression is:
  SPDS_NOTE: SELECT objlist 
             FROM tablelist 
             [ WHERE boolean_expr ] 
             [ GROUP BY scalar_expr { ',' scalar_expr }*  ] 
             [ HAVING boolean_expr ] 
             [ ORDER BY atomic_expr [ ASC | DESC ] 
                  { ',' atomic_expr [ ASC | DESC ] }* ]
  SPDS_ERROR: Parse Failure: select value from #dictionary.macros where (name = 'SYSVLONG');
 
 SPDS_ERROR: SQL passthru expression contained errors.
  SPDS_ERROR: Parse Failure: invalid dictionary member
  SPDS_NOTE: Correct Syntax for select expression is:
  SPDS_NOTE: SELECT objlist 
             FROM tablelist 
             [ WHERE boolean_expr ] 
             [ GROUP BY scalar_expr { ',' scalar_expr }*  ] 
             [ HAVING boolean_expr ] 
             [ ORDER BY atomic_expr [ ASC | DESC ] 
                  { ',' atomic_expr [ ASC | DESC ] }* ]
  SPDS_ERROR: Parse Failure: select "&sysvlong" as version from #dictionary.options where optname='LINESIZE';
 
 SPDS_ERROR: SQL passthru expression contained errors.
  SPDS_NOTE: Table PROJECT.TESTPCCF created, with 0 rows and 3 columns.
 
  SPDS_ERROR: Parse Failure: invalid dictionary member
  SPDS_NOTE: Correct Syntax for select expression is:
  SPDS_NOTE: SELECT objlist 
             FROM tablelist 
             [ WHERE boolean_expr ] 
             [ GROUP BY scalar_expr { ',' scalar_expr }*  ] 
             [ HAVING boolean_expr ] 
             [ ORDER BY atomic_expr [ ASC | DESC ] 
                  { ',' atomic_expr [ ASC | DESC ] }* ]
  SPDS_ERROR: Parse Failure: select value from #dictionary.macros where (name = 'SYSVLONG');
 
 SPDS_ERROR: SQL passthru expression contained errors.
  SPDS_ERROR: Parse Failure: invalid dictionary member
  SPDS_NOTE: Correct Syntax for select expression is:
  SPDS_NOTE: SELECT objlist 
             FROM tablelist 
             [ WHERE boolean_expr ] 
             [ GROUP BY scalar_expr { ',' scalar_expr }*  ] 
             [ HAVING boolean_expr ] 
             [ ORDER BY atomic_expr [ ASC | DESC ] 
                  { ',' atomic_expr [ ASC | DESC ] }* ]
  SPDS_ERROR: Parse Failure: select "&sysvlong" as version from #dictionary.options where optname='LINESIZE';
 
 SPDS_ERROR: SQL passthru expression contained errors.
  SPDS_ERROR: Parse Failure: invalid dictionary member
  SPDS_NOTE: Correct Syntax for select expression is:
  SPDS_NOTE: SELECT objlist 
             FROM tablelist 
             [ WHERE boolean_expr ] 
             [ GROUP BY scalar_expr { ',' scalar_expr }*  ] 
             [ HAVING boolean_expr ] 
             [ ORDER BY atomic_expr [ ASC | DESC ] 
                  { ',' atomic_expr [ ASC | DESC ] }* ]
  SPDS_ERROR: Parse Failure: select value from #dictionary.macros where (name = 'SYSVLONG');
 
 SPDS_ERROR: SQL passthru expression contained errors.
  SPDS_ERROR: Parse Failure: invalid dictionary member
  SPDS_NOTE: Correct Syntax for select expression is:
  SPDS_NOTE: SELECT objlist 
             FROM tablelist 
             [ WHERE boolean_expr ] 
             [ GROUP BY scalar_expr { ',' scalar_expr }*  ] 
             [ HAVING boolean_expr ] 
             [ ORDER BY atomic_expr [ ASC | DESC ] 
                  { ',' atomic_expr [ ASC | DESC ] }* ]
  SPDS_ERROR: Parse Failure: select "&sysvlong" as version from #dictionary.options where optname='LINESIZE';
 
 SPDS_ERROR: SQL passthru expression contained errors.
  SPDS_WARNING: The SQL option UNDO_POLICY=REQUIRED is not in effect. If an error is detected when processing this INSERT statement, that error will not cause the entire statement to fail.
  SPDS_NOTE: 1 row was inserted into PROJECT.TESTPCCF.



> sqlDrop(project,"project.testpccf")
  SPDS_ERROR: Parse Failure: invalid dictionary member
  SPDS_NOTE: Correct Syntax for select expression is:
  SPDS_NOTE: SELECT objlist 
             FROM tablelist 
             [ WHERE boolean_expr ] 
             [ GROUP BY scalar_expr { ',' scalar_expr }*  ] 
             [ HAVING boolean_expr ] 
             [ ORDER BY atomic_expr [ ASC | DESC ] 
                  { ',' atomic_expr [ ASC | DESC ] }* ]
  SPDS_ERROR: Parse Failure: select value from #dictionary.macros where (name = 'SYSVLONG');
 
 SPDS_ERROR: SQL passthru expression contained errors.
  SPDS_ERROR: Parse Failure: invalid dictionary member
  SPDS_NOTE: Correct Syntax for select expression is:
  SPDS_NOTE: SELECT objlist 
             FROM tablelist 
             [ WHERE boolean_expr ] 
             [ GROUP BY scalar_expr { ',' scalar_expr }*  ] 
             [ HAVING boolean_expr ] 
             [ ORDER BY atomic_expr [ ASC | DESC ] 
                  { ',' atomic_expr [ ASC | DESC ] }* ]
  SPDS_ERROR: Parse Failure: select "&sysvlong" as version from #dictionary.options where optname='LINESIZE';
 
 SPDS_ERROR: SQL passthru expression contained errors.
  SPDS_NOTE: Table PROJECT.TESTPCCF has been dropped.