Here we do a lot of extractor/load programs, so I’m doing a few utility programs for the team.
I did one that looks into a workfile in CSV format and create a draft program in development library with the simplest structure (define data with file and layout, read work file, move fields from file to draft fields, store draft view and end)
I did another one that you define how many work files you gonna generate, with or without headers and it make another draft program in dev lib with the basics, so you lose less time with the mechanic part.
You will find them attached to this post, but they are in portuguese. Feel free to suggest any improvement or fix any bug I didn’t catch yet
One of the devs asked me to make an extractor based on a view. He said it would be nice if a program could ask for a view name, and then he chooses the fields to export (like when you put a .V(SYS-VIEW) in a local/parameter module) and then it creates a draft program exporting these fields in csv format.
I took a look in a few views here, and the one that caught my attention was SYSDIC-FI-ADA.
There I found the list of views we have here, but I couldn’t manage to find the fields, neither the field attributes (format/size).
I don’t have admin profile. I don’t have access to dba libs and I can’t access any USRxxxxx modules.
Is there a way to have what I want? If there is, please help