Re: Queries crashing

Chris,
I am also seeing this condition.
I was told that IBM had addressed this in a prior release, but it still
occurs.
I have kept the old Personal Communications 6.0 version for just this
condition. When I need to query a file where I know this exists, I switch
to that emulator and then run my SQL.

Jeff Young
Sr. Programmer Analyst

On Fri, Feb 24, 2017 at 6:23 PM, Chris Bipes <chris.bipes@xxxxxxxxxxxxxxx>
wrote:

I have started using the new java based emulator and .hod files. Guess
what I found out. If you query a file with binary data in a text field, it
creates several dumps and the query crashes. If you use the older Personal
Communications 6.0, it will display the binary data as Asterisks with a
line over the top and NOT create dumps or crash the query. Love it when
the new latest and greatest software does not work as well as the older and
more stable software.

Errors in the log:
System failure on device DSP05 with feedback code 00002301.
Function check. CPF5411 unmonitored by QWSGET at statement *N, instruction
X'3478'.
Dump output directed to spooled file 5, job 999999/User1/DSP05 created
on system Power8 on 02/24/17 15:18:10.
Failure for device or member SCHRISBB file QDQUWSRUN in library QSYS.
Dump output directed to spooled file 7, job 999999/User1/DSP05 created
on system Power8 on 02/24/17 15:18:10.
Function check. CPF5257 unmonitored by QQURB at statement *N, instruction
X'050E'.
Query cannot be run. See lower level messages.

Chris Bipes
Director of Information Services
CrossCheck, Inc.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD