Informix - Problem description
Problem IT28015 | Status: Closed |
STORED PROCEDURE TO CREATE EXTERNAL TABLE FAILS WITH ERROR -26180 ON IDS 12.10.FC12 | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
A CREATE EXTERNAL TABLE statement fails from within an SPL, but succeeds when run from an SQL command line. The problem and how to duplicate are described immediately below. First, consider the following SQL: CREATE EXTERNAL TABLE ext_tbl( data_row CHAR(978) EXTERNAL CHAR(978) ) USING ( FORMAT 'FIXED', DATAFILES ("DISK:/home/informix/ext_tbl.file") ); It executes from an SQL command line with no error reported. Now, consider the following SPL (which includes the same SQL, but in an SPL "wrapper"): CREATE PROCEDURE ext_tbl_tst() CREATE EXTERNAL TABLE ext_tbl( data_row CHAR(978) EXTERNAL CHAR(978) ) USING ( FORMAT 'FIXED', DATAFILES ("DISK:/home/informix/ext_tbl.file") ); END PROCEDURE; It compiles. But, when EXECUTED, it fails, reporting a -26180 error and specifying "data_row" as the culprit: 26180: Missing external column type data_row. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 12.10.xC13. * **************************************************************** * PROBLEM DESCRIPTION: * * Stored Procedure to create external table fails with error * * -26180. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 06.02.2019 24.09.2019 24.09.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC13 | |
Problem solved according to the fixlist(s) of the following version(s) |