Hi all, Here's a small change to sapdb.sql script found in /castor/src/tests/jdo. Here's a unified diff file (Bruce, I hope this time I made it right :-)). I've changed semicolon to 'sapdb native' double slash (//) on a single line. I didn't manage to run the old version of script in SAPDB 7.4 SQL Studio, not even in Oracle SQL mode - there were a lot of syntax errors. Another change is that I dropped out the 'if exists' from the drop table statement. This either didn't work when I've tried within my SQL Studio editor - syntax error again. BTW, the script can not be run at all in Oracle mode, due to the use of timestamp SQL data type (unknown datatype is reported), so we're judged to run it in SAPDB internal sql mode which I personally prefer.
Nevertheless, I would like to hear from someone more knowledgeable about the SAPDB SQL internal and Oracle mode to comment on this change. My reason for changing is rather simple: I've tried the old script - it didn't work, so I've made this one and it works. :-) Best regards, Emir
sapdb.diff
Description: Binary data
