Subject IB_SQL Dialect3 and ib_domain.sql
Author bmckenna6
I'm new to IB.

I'm porting a pdox level 7 to ib w/ib_sql & pdox2ib.

I need 'Time' and 'TimeStamp,' so it appears I need
dialect3.

'pdox2ib_info.rtf' tells me to 'run the script
named 'ib_domain.sql' from IB_SQL.

I can only presume that 'run the script' =
click the 'Execute Script' button and load the
'ib_domain.sql' file, which I do.

When my gdb file is specified as SQL Dialect 1,
'Execute' in the Script window appears to run OK,
but the 'Commit/Rollback' icons never appear active.

When my gdb file is specified as SQL Dialect 3,
which is what I need, I believe, 'Execute' in the
Script window returns an error, 'Token Unknown' on
all the UDF functions.

If I click 'Yes' on these errors for 'Continue
Executing Script?', the Script statusbar returns
the message 'Script completed without exceptions.'

The 'Commit/Rollback' icons appear active only
occasionally, as a result of processes or patterns
which I cannot discern, but never when it seems
relevant to my next step, according to 'pdox2ib_info.rtf.'

...and what are the 'Yield' and 'Store' checkboxes
about, and do they have any relevance to what I'm
attempting. Help gives no info I can find.

These are apparently symptoms of my beginners angst,
which perhaps a little more documentation might help.