• Search Forums
    Advanced Search
Prev
Next
Forums Integration / Customization S3 Customization/Development

custom 4GLs

 8 Replies
 0 Subscribed to this topic
 19 Subscribed to this forum
Sort:
Author
Messages
Demichener
New Member
Posts: 0
New 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: 477
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Poster
Engaged Poster
Wow, you're on a roll!
Avid Poster
Avid Poster
Seriously, you're a posting maniac!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
3/15/2012 2:50 PM
Do you mean double quotes around each line or each field?
Demichener
New Member
Posts: 0
New Member
3/15/2012 3:03 PM
Double quotes around each line.
Ragu Raghavan
Veteran Member
Posts: 477
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Poster
Engaged Poster
Wow, you're on a roll!
Avid Poster
Avid Poster
Seriously, you're a posting maniac!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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 ?
Demichener
New Member
Posts: 0
New 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: 477
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Poster
Engaged Poster
Wow, you're on a roll!
Avid Poster
Avid Poster
Seriously, you're a posting maniac!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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)
Demichener
New Member
Posts: 0
New 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?
Demichener
New Member
Posts: 0
New 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.
Demichener
New Member
Posts: 0
New Member
3/16/2012 6:53 PM
Worked like a charm. Thank-you!