db2/400 how to use SELECT command in files that have several members?

[lucianoww]

In Dbeaver 7.1.3 in connection db2 / 400 how is the SELECT command in files that have several members?

Example file FI739U, member B033003091

[kseniiaguzeeva]

Could you please clarify what is your problem? If you need to execute Select query, use:
Select * from FI739U

[JMarkMurphy]

SQL does not support multi member files, directly. That is a DB2 for IBM i database construct. However, there are two solutions. You can spend $$$$$ and get DB2 Multi-system. That treats members as partitions, and then allows you to access those members. Or, you can use an alias to access a single member of a multi-member file.

CREATE OR REPLACE ALIAS alias name FOR table name (member name);

The documentation for this statement is found here: IBM i Knowledge Center

Alas, this is not a dBeaver issue.

[kseniiaguzeeva]

Unfortunately it cannot be resolved from our side.