This one's bugging me probably because it's the end of the day but see if you can sort this.
I'm using a dyamic query to query a database with the purpose to output the values of the data into a flat file, using the PUT UNFORMATTED statement through an OUTPUT STREAM. Some of the data is larger than the field format so I'm getting error such as ** Value <value> cannot be displayed using <format>. (74).
It's blatantly obvious that the code i'm using is trying to use the field format but I'm struggling to override it.
I'm trying to use BUFFER-FIELD:STRING-VALUE so my attempt looks like this:
I've also tried
and
In all instances PROGRESS cries like a girl (sorry girls) with the same error message. This should be schoolboy stuff but I'm having a serious brainfart.
Any suggestions on how do get rid of that error message and override the field format?
I'm using a dyamic query to query a database with the purpose to output the values of the data into a flat file, using the PUT UNFORMATTED statement through an OUTPUT STREAM. Some of the data is larger than the field format so I'm getting error such as ** Value <value> cannot be displayed using <format>. (74).
It's blatantly obvious that the code i'm using is trying to use the field format but I'm struggling to override it.
I'm trying to use BUFFER-FIELD:STRING-VALUE so my attempt looks like this:
Code:
PUT STREAM sOut UNFORMATTED hField:STRING-VALUE.
I've also tried
Code:
PUT STREAM sOut UNFORMATTED hField:BUFFER-VALUE.
and
Code:
PUT STREAM sOut UNFORMATTED string(hField:BUFFER-VALUE, ">>>>>>>>>>9").
In all instances PROGRESS cries like a girl (sorry girls) with the same error message. This should be schoolboy stuff but I'm having a serious brainfart.
Any suggestions on how do get rid of that error message and override the field format?