1. Forum
  2. Usenet
  3. COMP.SYS.UNISYS

  • FILEDATA output into CSV format

    From Val@21:1/5 to All on Mon May 24 22:50:33 2021
    Is there a way to read the FILEDATA output generated using the FILENAME attribute into a CSV format file.

    For example: to produce a CODEINFO report where TARGET is reported for the entire pack in an effort to identify objects not LEVEL6

    I was able to do this in PDIR but wanted to know if this is available in FILEDATA

    Thanks
    Val

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Paul Kimpel@21:1/5 to Val on Tue May 25 07:16:18 2021
    On 5/24/2021 10:50 PM, Val wrote:
    Is there a way to read the FILEDATA output generated using the FILENAME attribute into a CSV format file.

    For example: to produce a CODEINFO report where TARGET is reported for the entire pack in an effort to identify objects not LEVEL6

    I was able to do this in PDIR but wanted to know if this is available in FILEDATA

    Thanks
    Val

    As far as I can tell, FILEDATA only outputs line-image data in "report"
    format. You can output the report to a disk file, but the records will
    look like the printed report.

    Paul

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From ramseyhere@21:1/5 to Paul Kimpel on Tue May 25 10:29:31 2021
    On Tuesday, May 25, 2021 at 10:16:21 AM UTC-4, Paul Kimpel wrote:
    On 5/24/2021 10:50 PM, Val wrote:
    Is there a way to read the FILEDATA output generated using the FILENAME attribute into a CSV format file.

    For example: to produce a CODEINFO report where TARGET is reported for the entire pack in an effort to identify objects not LEVEL6

    I was able to do this in PDIR but wanted to know if this is available in FILEDATA

    Thanks
    Val
    As far as I can tell, FILEDATA only outputs line-image data in "report" format. You can output the report to a disk file, but the records will
    look like the printed report.

    Paul
    Rather than use FILEDATA, use *SYSTEM/PDIR. Same type of info, and will output to CSV

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Luis Serrano@21:1/5 to All on Tue May 25 12:38:47 2021
    El martes, 25 de mayo de 2021 a las 11:29:33 UTC-6, ramseyhere escribió:
    On Tuesday, May 25, 2021 at 10:16:21 AM UTC-4, Paul Kimpel wrote:
    On 5/24/2021 10:50 PM, Val wrote:
    Is there a way to read the FILEDATA output generated using the FILENAME attribute into a CSV format file.

    For example: to produce a CODEINFO report where TARGET is reported for the entire pack in an effort to identify objects not LEVEL6

    I was able to do this in PDIR but wanted to know if this is available in FILEDATA

    Thanks
    Val
    As far as I can tell, FILEDATA only outputs line-image data in "report" format. You can output the report to a disk file, but the records will look like the printed report.

    Paul
    Rather than use FILEDATA, use *SYSTEM/PDIR. Same type of info, and will output to CSV

    This is the job I use to get similar info .... User can be "*", "(=)" or any specific usercode between parenthesis ...

    ?BEGIN JOB WFL/PDIR/CODEVERSION (
    STRING USR OPTIONAL DEFAULT = "(=)");
    %FAMILY DISK = DISK ONLY;
    STRING S1, S2, MYPK;

    SUBROUTINE CODEINFO (STRING PK);
    BEGIN
    IF USR = "*" THEN
    S2 := "SYSTEM"
    ELSE
    S2 := "ALLUSR";
    S1 := USR & "= ON " & PK & " SHOW NAME,FILEKIND,CODEV,EXEC " &
    "SELECT FILEKIND = =CODE= SORT +CODEV" &
    ":TABBED """ & PK & "_" & S2 & "_CODEV.TXT""" ON MYPK;
    %DISPLAY (S1);
    RUN *SYSTEM/PDIR (S1);
    END;

    MYPK := "DISK";
    CODEINFO ("SPARE");
    ?END JOB.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Val@21:1/5 to Luis Serrano on Tue Jun 1 10:27:54 2021
    On Tuesday, May 25, 2021 at 3:38:47 PM UTC-4, Luis Serrano wrote:
    El martes, 25 de mayo de 2021 a las 11:29:33 UTC-6, ramseyhere escribió:
    On Tuesday, May 25, 2021 at 10:16:21 AM UTC-4, Paul Kimpel wrote:
    On 5/24/2021 10:50 PM, Val wrote:
    Is there a way to read the FILEDATA output generated using the FILENAME attribute into a CSV format file.

    For example: to produce a CODEINFO report where TARGET is reported for the entire pack in an effort to identify objects not LEVEL6

    I was able to do this in PDIR but wanted to know if this is available in FILEDATA

    Thanks
    Val
    As far as I can tell, FILEDATA only outputs line-image data in "report" format. You can output the report to a disk file, but the records will look like the printed report.

    Paul
    Rather than use FILEDATA, use *SYSTEM/PDIR. Same type of info, and will output to CSV
    This is the job I use to get similar info .... User can be "*", "(=)" or any specific usercode between parenthesis ...

    ?BEGIN JOB WFL/PDIR/CODEVERSION (
    STRING USR OPTIONAL DEFAULT = "(=)");
    %FAMILY DISK = DISK ONLY;
    STRING S1, S2, MYPK;

    SUBROUTINE CODEINFO (STRING PK);
    BEGIN
    IF USR = "*" THEN
    S2 := "SYSTEM"
    ELSE
    S2 := "ALLUSR";
    S1 := USR & "= ON " & PK & " SHOW NAME,FILEKIND,CODEV,EXEC " &
    "SELECT FILEKIND = =CODE= SORT +CODEV" &
    ":TABBED """ & PK & "_" & S2 & "_CODEV.TXT""" ON MYPK;
    %DISPLAY (S1);
    RUN *SYSTEM/PDIR (S1);
    END;

    MYPK := "DISK";
    CODEINFO ("SPARE");
    ?END JOB.


    Than you Luis, Paul, and Larry for the tips, and feedback.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)