ALIAS command not working for Oracle Tables
Posted 16 November 2003 - 02:17 AM
Kernel Version: 5.5r308
Fixed in: 5.5r323
The ALIAS command does not work for Oracle Tables.
It will work the first time a table is ALIASed in a ProIV session, then after that the ALIAS command is ignored for that table.
Posted 17 November 2003 - 09:45 AM
The ALIAS command
I've used it quite often, but only ever issue it once in the Def Lgc of LS1/LU1 of function.
I only ever thought ALIAS could be executed in the DEF LGC LS1 - in the early days od PRO-IV the usage of ALIAS was undocumented.
Where a function is to process many files by usage of ALIAS command, I'd precede the function with a function which selected the filename and then pass the file name in Comm Var to the function where the ALIAS and file processing is to occur
I've generally been using the ALIAS command of INPUT or OUTPUT of external ASCII files
Have also used it for the Create and ALIAS of pro-isam / c-isam workfile - but only ever needing to use the ALIAS once in the function
Posted 17 November 2003 - 09:55 AM
I know that the ALIAS command should only be used in Function entry logic.
The ALIAS command has stopped working for ORACLE tables in Function entry logic.
When I state 'once', I mean each Oracle table can be ALIASed once within a ProIV session, and then it does not work again until you logout and back into ProIV. Not once per function.
ProIV LTD have acknowledged that it is a bug....
Posted 17 November 2003 - 01:57 PM
Pro-iv does not detect that changing an ALIAS requires reparsing the SQL statement, so it re-uses
the first query each time.
Yes, REPARSE=Y makes things run slower, but it has the benefit of pro-iv actually doing what you tell it to do
Posted 26 November 2003 - 01:44 PM
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users