Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
create table from structure of another table in DB2.
This is a discussion on create table from structure of another table in DB2. within the DB2 forums, part of the Databases category; how to create a table by having the same schema of another table. i tried this create table target name1 as(select * from name2 where 1=2) but am getting the ...
|
|||||||
09-09-2009
|
|||
|
|||
|
create table from structure of another table in DB2.
how to create a table by having the same schema of another table.
i tried this create table target name1 as(select * from name2 where 1=2) but am getting the following error sqlcode: -104 sqlstate: 42601 please help its urgent, thanks in advance. 
|
| Sponsored Links |
|
09-09-2009
|
|||
|
|||
|
Re: create table from structure of another table in DB2.
IIRC, this problem was fixed in FP3 .. What fixpak are you on ??
to know the fix pack ----------db2level (from the command line). the following link might be helpful for you.
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Query to find structure of a table | Geek_Guest | SQL | 16 | 07-07-2009 04:35 AM |
| Query to get table structure | Divya.B.V | DB2 | 4 | 05-26-2008 04:15 PM |
| Table structure copying | krishnaindia2007 | Oracle | 1 | 11-28-2007 03:13 AM |
| How to view the structure of the table | Subashini.Ramasamy | SQL Server | 14 | 11-26-2007 07:58 AM |
| copy the Table Structure | vcyogi | SQL Server | 3 | 08-04-2007 02:43 AM |
All times are GMT -4. The time now is 05:58 AM.
