Subject | IB_SQL Dialect3 and ib_domain.sql |
---|---|
Author | bmckenna6 |
Post date | 2002-06-10T14:10:43Z |
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.
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.