Nicholas Bunton

Thanks again Bruce, i was able to have success creating the file and I used the alternative solution you provided using the AbstractLineWriter. My only concern is that the setField method was marked as deprecated in my IDE for AbstractLineWriter, but it appears to be working fine.

Hello again Bruce, I'm now trying to write to an ASCII file and was trying to use the code you gave me above (a few messages up there) for writing to an ASCII file. I also added my own code as well. Some of the code is pseudo code for simplicity. The while loop is going through the data set and creating a new line for each record, and i'm just hard coding the values in there right now to make sure the file is being created as expected. However, while viewing this file, it is writing everything to...

Hello again Bruce, I'm now trying to write to an ASCII file and was trying to use the code you gave me above (a few messages up there) for writing to an ASCII file. I also added my own code as well. Some of the code is pseudo code fpr simplicity. The while loop is going through the data set and creating a new line for each record, and i'm just hard coding the values in there right now to make sure the file is being created as expected. However, while viewing this file, it is writing everything to...

Hello again Bruce, I'm now trying to write to an ASCII file and was trying to use the code you gave me above (a few messages up there) for writing to an ASCII file. I also added my own code as well. Some of the code is pseudo code from simplicity. The while loop is going through the data set and creating a new line for each record, and i'm just hard coding the values in there right now to make sure the file is being created as expected. However, while viewing this file, it is writing everything to...

I've attached the view I'm looking at. I blacked out the values just to hide the data I'm viewing. Let me know if you need any more information.

Hello, I was looking too see if you could export a selected record from JRecord Record Editor to spreadsheet or CSV with all columns attached (Field, Start, Len, Type, Text, Data, and Hex). I went through some of the options in the editor and found an option to export the record but it only included the Data column. Is this type of export possible? ** I would attach a screenshot to this to help explain the view I'm looking at (if you need that) but I can figure out how to add an image.

Got it! Turns out I was setting the 'CBFIELD' instead of 'CBFIELDTWO'. So I take it it wasn't doing the conversion for the PIC X(9) field. Thanks Bruce!

Ok< I think the problem might be within the data then. I have been adding zeroes to the front of the column in the SQL table if the weren't of the necessary length of the COBOL field. So for example, if I have a COBOL field, 02 CBFIELD PIC X(9). 02 CBFIELDTWO REDEFINES CBFIELD PIC S9(9). and i have the value -197. I would want the value to have length of 9, so in the SQL table after doing a transformation to get to length 9, it would have the value 00000-197. Then in the Java code, I am taking that...