Track ID: BUG00001
Kernel Version: 5.5r308
Platform: Any
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.
ALIAS command not working for Oracle Tables
Started by Rob Donovan, Nov 16 2003 02:17 AM
5 replies to this topic
#1
Posted 16 November 2003 - 02:17 AM
#2
Posted 17 November 2003 - 09:45 AM
Rob
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
hth
George
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
hth
George
#3
Posted 17 November 2003 - 09:55 AM
Hi,
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....
Thanks,
Rob D
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....
Thanks,
Rob D
#4
Posted 17 November 2003 - 01:57 PM
This has been posted in other areas as well, but using the environment variable REPARSE=Y resolves this.
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
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
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users