List AS400 files

Good evening,

It seems to me that the following file can help you: QSYS/QADBXREF
If I remember correctly, it gathers all the files from your AS400

Gwénaël

hello hi I am an independent expert on AS400
you can contact me by email.
I respond to all questions.
Best regards RC.

Hello,
You type this command and press F4 to change the name of the library (MABIB) and the output file (MONFIC)
DSPOBJD OBJ(mabib/*ALL) OBJTYPE(*FILE) DETAIL(*FULL) OUTPUT(*OUTFILE) OUTFILE(QTEMP/monfic)
Good luck

Hi,
it’s been almost 3 years since I last touched an AS400, so thanks for being understanding... let’s see if I haven’t lost my memory.
You start with the DSPLIBL command which displays all the libraries in your environment.
Then for each library (non-system of course) you do a WRKOBJ with *FILE as the object type.
And there you go, you’ll eventually find the library that contains your files...
If needed, I still have some old documentation... don’t hesitate to ask me questions.
A++
------------------------------------------------------------------
If there’s no solution, there’s no problem!

Thank you very much, I have what I want.
;)

Hello!!!

I currently have to run SQL queries on an AS400, but it is not on our premises (remote site and no possibility to access the "terminal")
My question is as follows: Can we run the command DSPLIBL via an SQL query????

Thank you in advance.

Founnz

Hello!

Why don’t you work on a 5250 terminal?
--
The wolf, solitary and mysterious.

AS400 is not software; it is an IBM machine running OS 400. Not the same thing at all.

Wolf.
--

The wolf, solitary and mysterious.

Je voudrais savoir comment modifier un programme AS/400.

```c
#include <stdio.h>
#include <stdlib.h>
#include <dirent.h>
#include <string.h>

int compare(const void *a, const void *b) {
return strcmp(*(const char **)a, *(const char **)b);
}

int main() {
DIR *dir;
struct dirent *ent;
char *files[100];
int count = 0;

if ((dir = opendir(".")) != NULL) {
while ((ent = readdir(dir)) != NULL) {
files[count] = malloc(strlen(ent->d_name) + 1);
strcpy(files[count], ent->d_name);
count++;
}
closedir(dir);

qsort(files, count, sizeof(char *), compare);

printf("Contents of the directory:\n");
for (int i = 0; i < count; i++) {
printf("%s\n", files[i]);
free(files[i]);
}
} else {
perror("Could not open directory");
return EXIT_FAILURE;
}

return EXIT_SUCCESS;
}
```</string.h></dirent.h></stdlib.h></stdio.h>

Hello, is it possible to automatically feed a database in Excel from AS400? Can I go through an email? Thank you for your help.

Hello
I work on AS400 and I would like to have the command that can give me for a PF file
ZONE, ATTRIBUTE, LENGTH, TYPE, DESCRIPTION.
But the DSPFFD command does not meet my needs; I need this in a list.
Thank you in advance.