Tartan1
Member
"SQL Column Name" Different for F4095.FA@RT Between IBM DB2 & Oracle 12c
We are moving from JDE 8.12 on the AS/400 DB2, to Oracle 12C and upgrading to 9.2.
We did a full database copy of JDE 8.12 back in June, 2016, to Oracle 12C. We have retained a copy of that dataset in 8.12 format.
We are now testing doing a capture of the deltas between June and now, and appending them to a copy of that 8.12 dataset that we captured in June.
We came upon an error when the job that was writing the deltas to the destination tables, failed on the F4096 because a database field name was different between DB2 and Oracle.
I have attached the screen shots to illustrate.
In short, the alias is the same on both platforms, @RT.
However, when I run SQL statements over that table in 8.12, and Oracle, the "SQL Column Names" are different.
On 8.12 from DB2 it is FA@rt which is the same as the alias.
On Oracle, it is FA_1RT. The alias is still FA@RT.
We're just trying to confirm if this is correct on Oracle, as we are not sure how it even came to be changed.
Any input is greatly appreciated!
We are moving from JDE 8.12 on the AS/400 DB2, to Oracle 12C and upgrading to 9.2.
We did a full database copy of JDE 8.12 back in June, 2016, to Oracle 12C. We have retained a copy of that dataset in 8.12 format.
We are now testing doing a capture of the deltas between June and now, and appending them to a copy of that 8.12 dataset that we captured in June.
We came upon an error when the job that was writing the deltas to the destination tables, failed on the F4096 because a database field name was different between DB2 and Oracle.
I have attached the screen shots to illustrate.
In short, the alias is the same on both platforms, @RT.
However, when I run SQL statements over that table in 8.12, and Oracle, the "SQL Column Names" are different.
On 8.12 from DB2 it is FA@rt which is the same as the alias.
On Oracle, it is FA_1RT. The alias is still FA@RT.
We're just trying to confirm if this is correct on Oracle, as we are not sure how it even came to be changed.
Any input is greatly appreciated!