10 pts.
 Does anybody knows any API, which will extend the size of Display File in AS/400 (making bigger than 132), like Excel ..
Does anybody knows any API, which will extend the size of Display File in AS/400 (making bigger than 132), like Excel ..

Software/Hardware used:
ASKED: February 20, 2009  3:37 PM
UPDATED: February 21, 2009  12:07 AM

Answer Wiki:
Hi, I don't think there is such a thing. The display sizes on the AS400 are based around the 5250 data stream - I don't think there's ever been 5250 based hardware that could handle more than 132 columns. How would you format the data on the AS400? Using a display file? You may be able to achieve similar effects using the Client Access API's - like the screen scraper GUI's work (JWalk, Rumba, etc), but it's probably a lot easier to just retrieve the necessary data from the AS400 (using ODBC or JDBC, etc) and present it on the PC. Regards, Martin Gilbert. ////////////////////////////////// Or download it in .CSV format -- which can be opened by EXCEL. Phil /////////////////////////////////// You could "simulate" the wide screen by having a number of different formats Fmt1 is first 80(or 132) Fmt2 columns 40-120 (or 60-192) Fmt3 columns 80-160 -- they can have the same field names Initially show Fmt1 and on some function key exfmt Fmt2, next press of that function exfmt Fmt3 the same could be donw with subfiles -- when writing the subfile record write all three formats then exFmt Ctl1 .F10. CTL2 F10 CTL3. Phil ////////////////////////////////////// ==================== Take a look at Limona Surveyor/400 or Prodata DBU.
Last Wiki Answer Submitted:  February 21, 2009  12:07 am  by  mshen   27,310 pts.
All Answer Wiki Contributors:  mshen   27,310 pts. , philpl1jb   44,220 pts. , Gilly400   23,625 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _