Talk About Network

Google




Programming > Cobol Misc > Re: SQL Command...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 3 Topic 117 of 183
Post > Topic >>

Re: SQL Commands

by "Oliver Wong" <owong@[EMAIL PROTECTED] > Apr 7, 2006 at 03:55 PM

"Servizio Tecnico" <robertob68(nospam)@[EMAIL PROTECTED]
> wrote in message 
news:44363661$0$36935$4fafbaef@[EMAIL PROTECTED]
> Hi, I use Fujitsu v7 with Embedded SQL but when I write the command
"DROP 
> TABLE" and "CREATE TABLE" return a error in compilation like this:
> SQL STATEMENT IS INVALID - ODBC 7600E NOT EXECUTABLE SQL STATEMENT
>
> Someone can helpme?

    For "DROP TABLE", you have to then specify which table you want to
drop. 
For "CREATE TABLE", you then have to specify column names and their data 
type. See

http://www.w3schools.com/sql/sql_create.asp
http://www.w3schools.com/sql/sql_drop.asp

    - Oliver
 




 3 Posts in Topic:
SQL Commands
"Servizio Tecnico&qu  2006-04-07 11:53:03 
Re: SQL Commands
"Oliver Wong" &  2006-04-07 15:55:16 
Re: SQL Commands
"Servizio Tecnico&qu  2006-04-07 18:33:52 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
localhost-V2008-12-19 Tue Jan 6 7:43:10 PST 2009.