4GL CSV file name truncated

 3 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
Karen Sheridan
Veteran Member
Posts: 142
Veteran Member

    I cloned a custom 4gl extract program that is working correctly.  I changed the hard coded file name in the program.  The display statement show the correct file name, but the actual file name is being truncated.

    ws-filename pic x(80)
    its defined in workdef as a CSV file
    Program Messages:
                    ** Creating .prt and .dtl files
                    Processing ZR210 - VHM pedometer Deduction
                    *** WS-FILENAME=/lawdev/law/testhcm/work/VHM/TheChristHospital_1389347_GWS_20120308.csv
                    **** File Attributes Set For File: ZR210OUT   ****
                      File Path Name was taken from the Work File Name
                      File Options were taken from Users Locale
                      File PathName: /lawdev/law/testhcm/work/VHM/TheChristHospital_1389347_GWS_2

    Any ideas?

    Thanks,
    Karen
    Ragu Raghavan
    Veteran Member
    Posts: 476
    Veteran Member
      I did come across this limitaion before. I worked around it by creating the fille with a dummy name, then after the 800-CLOSECSV, do a CALL "system" to a "cp " command to copy the file to whatever I needed.
      Karen Sheridan
      Veteran Member
      Posts: 142
      Veteran Member
        That worked - Thanks
        Demi
        Veteran Member
        Posts: 67
        Veteran Member
          Sorry for jumping in late but I've been in the process of upgrading several custom programs and I've run into a related dilema. We have many programs that use the CALL "system" to do a "cp " command to copy(& rename) our output files. Since our upgrade, all of our CALL "system" commands no longer work. We are a Windows NT environment running core 9.0.1.9 with apps 9.0.1.7. All of our command lines use the format: sh -c "cp D:\FTP\OUT\file1 cp D:\FTP\OUT\archive\file1Date&Time". The response is ... /dev/fs/D/FTP/OUT/file1[#]: : not found. Any ideas that could help me get this working?