Skip to content

Sometimes GetMemberInfo throws an SQL error #2524

@worksofliam

Description

@worksofliam

This input statement:

create table QTEMP.MEMBERINFO as (select * from table(ILEDITOR.GETMBRINFO('SNDBX3', 'QRPGLESRC', '#HELLO'))) with data;
select * from QTEMP.MEMBERINFO

Throws this result:

 **** CLI ERROR *****
         SQLSTATE: 22007
NATIVE ERROR CODE: -20448
Expression not valid using format string specified for TIMESTAMP_FORMAT. 

 **** CLI ERROR *****
         SQLSTATE: 42704
NATIVE ERROR CODE: -204
MEMBERINFO in QTEMP type *FILE not found.

Metadata

Metadata

Assignees

Labels

bugA confirmed issue when something isn't working as intendedneeds-investigationThe team should look into this

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions