• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Trap: TC on coexistant table

DRezanka

Reputable Poster
A word of caution when creating or using a Table Conversion against a table used coexistantly with WorldSoftware: The TC copies, deletes, then rebuilds the existing table using SQL statements. What that means is, the table will no longer be usable by AS400 RPG programs.

Doug
dougrezanka@eaton.com

Xe SP13.1, AS400 V4R3, CO-Oracle806, Co-A73c10, Citrix, NT JAS
 

owguru

Well Known Member
Great Tip, Doug!

As an addition, this is something to keep in mind for everyone running coexistent. Any table accessed by World must be created by World (ie, with proper RPG format) in order for the RPG programs to access it. When OneWorld creates a table (via table conversion, create table, any number of UBE's like the R98403, etc.) it creates in an SQL format...unreadable to World programs.

This is also something to keep in mind when updating and upgrading the World side. If a World upgrade delivers what it thinks are new tables and OneWorld has already created these tables (as OW only tables), then the upgrade does not recreate the tables for World. Here again the formatting is a problem. Always check with JDE to find out if tables are being delivered for a World update or upgrade to see if your coexistence install may create this issue.

owguru (at least I'm trying :)
>all versions
>all platforms
 
Top