John L. Singleton wrote > > Hi Elke, > > I get the same result in sqlcli and SQL Studio. This output, however, is > from SQL Studio. > > Kernel Version: 7.5.05
Aaah, here we are. You are using 7.5.00.05, but this feature was implemented with 7.5.00.11. With your version it can't do. Please upgrade to a newer one. Elke SAP Labs Berlin > > 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]
