Prev
Next
Forums Integration / Customization S3 Customization/Development

custom 4GLs

 8 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
Demi
Veteran Member
Posts: 67
Veteran Member
3/15/2012 1:19 PM
    Can anyone tell me where, why and how to correct this? We've recently upgraded both our apps (9.0.0.6 to 9.0.1.7) and our env (9.0.0.8 to 9.0.1.9). I'm working on several of our custom delivered 4GLs and have found that our CSV output files are now being generated with quotations around each line.
    Ragu Raghavan
    Veteran Member
    Posts: 476
    Veteran Member
    3/15/2012 2:50 PM
      Do you mean double quotes around each line or each field?
      Demi
      Veteran Member
      Posts: 67
      Veteran Member
      3/15/2012 3:03 PM
        Double quotes around each line.
        Ragu Raghavan
        Veteran Member
        Posts: 476
        Veteran Member
        3/15/2012 5:18 PM
          Apologies for asking dumb questions. Are the files defined as CSV in workdef ? When populating the fields in the file, is it a simple MOVE or does the logic use a STRING function? Does the workdef layout have multiple fields or is is just one large field that has a WS record layout being moved to ?
          Demi
          Veteran Member
          Posts: 67
          Veteran Member
          3/16/2012 12:27 PM
            Yes, my file is defined as a CSV with only the REC defined; no individual fields; and I am using the 'STRING into' WS command along with a move into one large field.  If it helps, it is a customized version  of BN106.
            Ragu Raghavan
            Veteran Member
            Posts: 476
            Veteran Member
            3/16/2012 12:48 PM
              In workdef, F6 - B (defined file attributes) see if the quote character is set to ".
              Blank that out and see if it gives you the desired results. (you will need to recompile after the change)
              Demi
              Veteran Member
              Posts: 67
              Veteran Member
              3/16/2012 2:19 PM
                Unfortunitely, I'm not sure why yet; when I go into the workdef and then F6; my define file attributes option is blue and unselectable. I can't even get into them to see what they are set at. Any suggestions?
                Demi
                Veteran Member
                Posts: 67
                Veteran Member
                3/16/2012 2:32 PM
                  Wait a minute; I had changed the file type to be tape in an attempt the troubleshoot. Once I changed the file type back to CSV, I can now access the file attributes. I will follow through with these settings and hopefully this will correct my issue.
                  Demi
                  Veteran Member
                  Posts: 67
                  Veteran Member
                  3/16/2012 6:53 PM
                    Worked like a charm. Thank-you!