Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to do a calculation from two different tables during data load editor, so I used the resident table.
It works when I tested with some small size dummy data. However, when using the same logic to do the calculation from two resident tables with more than 100MB, there would be error.
The error says the resident table is not found.
Any suggestion is appreciated!
There is no limit
The error means the table you were trying to create has not been created , probably you have tried to do resident load immediately after loading the table
Write keyword NOCONCATENATE
before the load statement of your resident table.
There is no limit
The error means the table you were trying to create has not been created , probably you have tried to do resident load immediately after loading the table
Write keyword NOCONCATENATE
before the load statement of your resident table.
Hey Vineeth, thanks so much for your help!
I nearly forget the CONCATENATE issue between two tables. This is very possible the reason. Let me check.
Thanks again!