When a user with S36 rights runs a query the result files are all combined into one field. Take away the S36 rights...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
and the same user will get the correct results. What could make this happen?
When operating in S36 mode, query assumes that a flat-file would need to be the default output. Changing to non-S36 mode will cause query to create a normal DB2/400 output file.
MORE INFORMATION ON THIS TOPIC
The Best Web Links: tips, tutorials and more.
Ask your OS/400 questions--or help out your peers by answering them--in our live OS/400 discussion forums.
Dig Deeper on Past Releases
Related Q&A from John Brandt
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.