Doesn't allow to get tables from Host with key literals
joelgomes85 opened this issue · 4 comments
When pulling, for example, UTBLSEX from profile the following error occurs:
[INFO][11:06:15] … ⇩ UTBLSEX TABLE GET from [environment]
[ERR!][11:06:17] ✖ ⇩ error in [environment] ER1IOOPEN No such file or directory
This happens with every table with key literals.
This works in Eclipse without errors.
The Table Get does a query on DBTBL1D to get the columnList. For UTBLSEX we get:
columnList
Array(4) [""SEX"", "DESC", "FMDESC", "SEX"]
Then it tries to get the corresponding COL for each element in columnList. Obviously this fails on the first column. The simple solution would be to filter out the literals, agreed?
This table contains two keys one "SEX" - literal, and SEX - first KEY1.
Only the second one should be downloaded, as literal keys exist in DBTBL1D but should not be used as .COL elements.
The Table Get does a query on DBTBL1D to get the columnList. For UTBLSEX we get:
columnList Array(4) [""SEX"", "DESC", "FMDESC", "SEX"]Then it tries to get the corresponding COL for each element in columnList. Obviously this fails on the first column. The simple solution would be to filter out the literals, agreed?
Just handle exception returned by host for columns with literals. it will be like this:
FWKINST-E-TYPE, This column "SEX" should be in table header
where "SEX" will be replaced by column name.
This is a response for INITOBJ call :)
Cannot reproduce in version 1.11.4. seems working, either fixed or something else.
`[INFO][12:56:36] … ⇩ UTBLSEX TABLE GET from docker
[INFO][12:56:36] ✔ ⇩ UTBLSEX TABLE GET from docker succeeded`
Closing issue. If still occurring please reopen with details.