Re: Trying to use a SELECT ...INTO Command with InterBase, Sybase, and Informix

Apparently, I need to do sp_dboptions <database_name> ,"select into/bulkcopy", true

But with Sybase it doesn't appear to take.

Is something similar required in Informix or InterBase??

Oracle actually provides a better solution:

Oracle allows you to do the following:

CREATE Table <Table_Name>
AS
Select

    From
    Where

This does not appear to work in other database engines.

If I could use something similar to this syntax in all databases it would be useful, due to some of the problems people have indicated with SELECT...INTO... Peter

--
++++++++++++++++++++++++++++++++++++++++++++++

Peter DeSimone
Email Address: desimonp_at_gte.net
Web Address:  http://home1.gte.net/desimonp

++++++++++++++++++++++++++++++++++++++++++++++
Peter DeSimone wrote in message <6v3fuk$g08$1_at_news-2.news.gte.net>...


>The second SQL statement I using has that syntax.  It still doesn't work.

>

>Peter

>

>

>fred wrote in message <907359367.364194_at_tango.news.big-orange.net>...

>>The right syntax is:

>>SELECT .....

>>      INTO ......

>>    FROM .......

>> WHERE .......

>>

>>Good luck,

>>

>>fred

>>

>>

>>Peter DeSimone wrote in message <6v31d6$e$1_at_news-2.news.gte.net>...

>>>I am trying to run the following command:

>>>

>>>SELECT TSP_COMPONENTS.ID LEVEL0ID, TSP_COMPONENTS.NAME LEVEL0NAME,

>>>TSP_COMPONENTS.ABBREVIATION LEVEL0Abbreviation

>>>FROM TSP_COMPONENTS

>>>WHERE (((TSP_COMPONENTS.COMPONENT_LEVEL)=0))

>>>INTO Level_0

>>>

>>>I want to take the data from the SELECT…FROM…WHERE SQL Statement and put

 it


>>>into a new table called LEVEL_0.  The Interactive SQL tool doesn’t like

 the


>>>INTO command.  Everything else in that SQL statement works fine.

>>>

>>>This statement works fine in Access and SQL:

>>>

>>>SELECT TSP_COMPONENTS.ID AS LEVEL9ID, TSP_COMPONENTS.NAME AS LEVEL9NAME,

>>>TSP_COMPONENTS.ABBREVIATION AS LEVEL9Abbreviation INTO Level_9

>>>FROM TSP_COMPONENTS

>>>WHERE (((TSP_COMPONENTS.COMPONENT_LEVEL)=9))

>>>

>>>Any help would be appreciated.

>>>

>>>In the end I need the following script to work:

>>>

>>>DROP TABLE Level_0

>>>SELECT TSP_COMPONENTS.ID AS LEVEL0ID, TSP_COMPONENTS.NAME AS LEVEL0NAME,

>>>TSP_COMPONENTS.ABBREVIATION AS LEVEL0Abbreviation INTO Level_0

>>>FROM TSP_COMPONENTS

>>>WHERE (((TSP_COMPONENTS.COMPONENT_LEVEL)=0))

>>>DROP TABLE Level_1

>>>SELECT TSP_COMPONENTS.ID AS LEVEL1ID, TSP_COMPONENTS.NAME AS LEVEL1NAME,

>>>TSP_COMPONENTS.ABBREVIATION AS LEVEL1Abbreviation INTO Level_1

>>>FROM TSP_COMPONENTS

>>>WHERE (((TSP_COMPONENTS.COMPONENT_LEVEL)=1))

>>>DROP TABLE Level_2

>>>SELECT TSP_COMPONENTS.ID AS LEVEL2ID, TSP_COMPONENTS.NAME AS LEVEL2NAME,

>>>TSP_COMPONENTS.ABBREVIATION AS LEVEL2Abbreviation INTO Level_2

>>>FROM TSP_COMPONENTS

>>>WHERE (((TSP_COMPONENTS.COMPONENT_LEVEL)=2))

>>>DROP TABLE Level_3

>>>SELECT TSP_COMPONENTS.ID AS LEVEL3ID, TSP_COMPONENTS.NAME AS LEVEL3NAME,

>>>TSP_COMPONENTS.ABBREVIATION AS LEVEL3Abbreviation INTO Level_3

>>>FROM TSP_COMPONENTS

>>>WHERE (((TSP_COMPONENTS.COMPONENT_LEVEL)=3))

>>>DROP TABLE Level_4

>>>SELECT TSP_COMPONENTS.ID AS LEVEL4ID, TSP_COMPONENTS.NAME AS LEVEL4NAME,

>>>TSP_COMPONENTS.ABBREVIATION AS LEVEL4Abbreviation INTO Level_4

>>>FROM TSP_COMPONENTS

>>>WHERE (((TSP_COMPONENTS.COMPONENT_LEVEL)=4))

>>>DROP TABLE Level_5

>>>SELECT TSP_COMPONENTS.ID AS LEVEL5ID, TSP_COMPONENTS.NAME AS LEVEL5NAME,

>>>TSP_COMPONENTS.ABBREVIATION AS LEVEL5Abbreviation INTO Level_5

>>>FROM TSP_COMPONENTS

>>>WHERE (((TSP_COMPONENTS.COMPONENT_LEVEL)=5))

>>>DROP TABLE Level_6

>>>SELECT TSP_COMPONENTS.ID AS LEVEL6ID, TSP_COMPONENTS.NAME AS LEVEL6NAME,

>>>TSP_COMPONENTS.ABBREVIATION AS LEVEL6Abbreviation INTO Level_6

>>>FROM TSP_COMPONENTS

>>>WHERE (((TSP_COMPONENTS.COMPONENT_LEVEL)=6))

>>>DROP TABLE Level_7

>>>SELECT TSP_COMPONENTS.ID AS LEVEL7ID, TSP_COMPONENTS.NAME AS LEVEL7NAME,

>>>TSP_COMPONENTS.ABBREVIATION AS LEVEL7Abbreviation INTO Level_7

>>>FROM TSP_COMPONENTS

>>>WHERE (((TSP_COMPONENTS.COMPONENT_LEVEL)=7))

>>>DROP TABLE Level_8

>>>SELECT TSP_COMPONENTS.ID AS LEVEL8ID, TSP_COMPONENTS.NAME AS LEVEL8NAME,

>>>TSP_COMPONENTS.ABBREVIATION AS LEVEL8Abbreviation INTO Level_8

>>>FROM TSP_COMPONENTS

>>>WHERE (((TSP_COMPONENTS.COMPONENT_LEVEL)=8))

>>>DROP TABLE Level_9

>>>SELECT TSP_COMPONENTS.ID AS LEVEL9ID, TSP_COMPONENTS.NAME AS LEVEL9NAME,

>>>TSP_COMPONENTS.ABBREVIATION AS LEVEL9Abbreviation INTO Level_9

>>>FROM TSP_COMPONENTS

>>>WHERE (((TSP_COMPONENTS.COMPONENT_LEVEL)=9))

>>>

>>>Peter DeSimone

>>>pdesimone_at_sageus.com

>>>

>>>

>>>

>>>

>>>

>>

>>

>

>