Capture IBM i Db2 SQL "Alternative file names"

Question

I would like to capture all the "Alternative file names" (SQL table name), as opposed to the the short 10 character IBM i "SYSTEM" name for a specific IBM i library. I can see the value using the DSPFD command, but can't seem to capture it in an DSPFD to OUTFILE. Is there a command to do this, or an API?

 DSPFD FILE(MYSQL_LIB/*ALL) TYPE(*BASATR) OUTPUT(*OUTFILE) OUTFILE(QTEMP/TEMP)

jmarkmurphy · Accepted Answer · 2019-07-19 15:26:00Z

3

You can get all this information from SQL using qsys2.systables. Please see these links IBM link and RPG blog link

EDIT: I have never used this but there is also this QUSLMBR API. I have always done this using systables.

Here's an example:

SELECT table_name 
FROM qsys2.systables
WHERE system_table_name = 'MYTABLE'
  AND table_schema = 'MYLIB'

The table name and schema must be in upper case.

edited Jul 19, 2019 at 15:26

jmarkmurphy

11.6k37 silver badges62 bronze badges

answered Jul 19, 2019 at 13:41

GenericDisplayName

4632 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Charles Over a year ago

for future reference, try to include the gist of the link, or in this case example code in your answer in case the link goes bad.

Collectives™ on Stack Overflow

Capture IBM i Db2 SQL "Alternative file names"

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related