Query help-all columns are not coming over

5 pts.
Tags:
AS/400 queries
AS/400 Query
When I look at query on define query it has all columns. When I actually run it to spool file its missing columns.

Thanks

Pam



Software/Hardware used:
AS400
ASKED: December 22, 2009  2:50 AM
UPDATED: December 22, 2009  9:49 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

if you’re using WRKQRY, press F5 to display your query …
note the report width in the upper right hand corner of the display …
does it match the report form width on your output selections ? …
if it is greater than form width, which defaults ton 132 characters,
you will lose the rightmost columns …

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Meandyou
    Interesting phenomenon - are you getting any error messages, codes, communication of any kind? Which columns are missing? the first column selected, or the second, or is it the last few columns? Is your spool file "wide" enough?
    5,220 pointsBadges:
    report
  • Whatis23
    The report width is probably no wide enough. Select output type and output form, on form size, the width defaults to 132. Try 198 and increase accordingly until it fits to your liking. Or remove some extraneous columns in Select and sequence fields.
    5,665 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following