|
Hey out there. Was wondering if someone can take a look at this and see where I messed up at? Thank you Could not execute statement. syntax error near ',' on line 14 SQLCODE=-131, ODBC 3 STATE="42000" Line 26, column 1
/* FileVersion=3.14.101 */
-------------------------------------------------------------------------------
-- DT8281 - Trent 2016.07.27
-- 1. Create table PUBLIC_EMAIL_DOMAIN
-- 2. Insert records into table PUBLIC_EMAIL_DOMAIN
-------------------------------------------------------------------------------
-- 1. Create table PUBLIC_EMAIL_DOMAIN
IF NOT EXISTS
(SELECT 1
FROM SYSTABLE
WHERE table_name = 'PUBLIC_EMAIL_DOMAIN'
)
BEGIN
CREATE TABLE "DBA"."PUBLIC_EMAIL_DOMAIN"(
"email_domain_name" CHAR(50) NOT NULL
,PRIMARY KEY ("email_domain_name" ASC)
)
END
GO
-- 2. Insert records into table PUBLIC_EMAIL_DOMAIN
IF EXISTS
(SELECT 1
FROM SYSTABLE
WHERE table_name = 'PUBLIC_EMAIL_DOMAIN'
)
IF (Select count(*) FROM PUBLIC_EMAIL_DOMAIN) = 0
BEGIN
INSERT INTO "DBA"."PUBLIC_EMAIL_DOMAIN"
(email_domain_name)
VALUES
('007addict.com') ,
('020.co.uk') ,
('123.com') ,
('123box.net') ,
('123india.com') ,
('123qwe.co.uk') ,
END
|
|
Just omit the last comma before the "END", i.e. close the SQL batch with ...
('123india.com') ,
('123qwe.co.uk')
END
Aside: Unless you need T-SQL compatibility, I'd recommend to use SQL Anywhere with the original Watcom-SQL dialect instead of T-SQL. IMHO it makes nested IF statements easier to read (and check). |