All Forums Tools
andgreen 3 posts Joined 04/07
19 Apr 2007
Creating a new Table

Sorry about this but I'm a bit green to using Terdata SQL assistant,I'm trying to create a table using the SQL as below:Create Table xw55.temp_prods As (Select *From dxwi_prod_roi_view_Access.VWI0BPR_BASE_PRODUCTWhere product_sub_group_code = 'W31AA' )But I'm getting an error message saying:3706: Syntax error: expected something between ')' and ';'What is it expecting ?? (I'm tearing my hair out with this one!)Hope someone can help.Thanks.

al1_24 39 posts Joined 11/04
19 Apr 2007

...with [no] datawith no data : creates only the structurewith data : creates the structure and insert lines from the SELECT query

Fred 1096 posts Joined 08/04
19 Apr 2007

And you generally should also specify a PI, otherwise it will default to NUPI on the first column only.

You must sign in to leave a comment.