RE: SQL select from another database only selecting 80 or so rows.

[Justin Taylor <JUSTIN@xxxxxxxxxxxxx>]

99 times out of 100, that fixes me up.

-----Original Message-----
From: Rob Berendt [mailto:rob@xxxxxxxxx] 
Sent: Sunday, December 04, 2016 4:34 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: SQL select from another database only selecting 80 or so rows.

BTW Justin, this is a query of files created by IBM.  Basically they are the results of http://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/rzajq/rzajqviewptfinfo.htm
and I'd be really dismayed to find non displayable data in that.

But, holy crap, you may be right!

When I replace the asterisk in the select statement with a single column it works.

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to:  2505 Dekko Drive
          Garrett, IN 46738
Ship to:  Dock 108
          6928N 400E
          Kendallville, IN 46755
http://www.dekko.com