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 Send Private Message
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 Send Private Message
Posts: 477
Veteran Member
3/15/2012 2:50 PM
Do you mean double quotes around each line or each field?
Demi
Veteran Member Send Private Message
Posts: 67
Veteran Member
3/15/2012 3:03 PM
Double quotes around each line.
Ragu Raghavan
Veteran Member Send Private Message
Posts: 477
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 Send Private Message
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 Send Private Message
Posts: 477
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 Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 67
Veteran Member
3/16/2012 6:53 PM
Worked like a charm. Thank-you!