Hi Elke,
I get the same result in sqlcli and SQL Studio. This output, however, is from SQL Studio.
Kernel Version: 7.5.05
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed Syntax error or access violation;-3014 POS(46) Invalid end of SQL statement. create table nflc_test (foo int PRIMARY KEY) NO FIXED LENGTH COLUMN
To save you time, the POS(46) points to "NO."
Thanks, JLS
Zabach, Elke wrote:
John L. Singleton wrote:
Hello all,
Does MaxDB still support the NO FIXED LENGTH COLUMN clause? I've tried several variations of this statement, but with no luck.
For example: create table nflc_test (foo int PRIMARY KEY) NO FIXED LENGTH COLUMN -3014: Invalid end of SQL statement SQLSTATE: 42000
I'm sure it's something really simple that I'm missing. Any ideas?
No idea, too, as it works fine for me. Which kernel-version are you using? Which tool are you using? Which sqlmode are you using? Which errorposition is given (position in the statement where the error was found)? Maybe a funny char is behind the correct statement? (We had this here in private scripts, just an idea)
Elke SAP Labs Berlin
Cheers, JLS
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
