RPG400-L Thread Index -- August 2021

Re: Worksheet failing when reaching a large number of rows-Using SXSSFWorkbook , Jorge Ubeda Re: Worksheet failing when reaching a large number of rows-Using SXSSFWorkbook , Don Brown Re: Embedded Exec SQL versus SQL-CLI Performance (Link?) , Niels Liisberg <Possible follow-ups> Re: Embedded Exec SQL versus SQL-CLI Performance (Link?) , D*B Re: Embedded Exec SQL versus SQL-CLI Performance (Link?) , Alan Campin Re: Embedded Exec SQL versus SQL-CLI Performance (Link?) , Alan Campin Re: Embedded Exec SQL versus SQL-CLI Performance (Link?) , Alan Campin Re: Embedded Exec SQL versus SQL-CLI Performance (Link?) , Alan Campin Re: Embedded Exec SQL versus SQL-CLI Performance (Link?) , D*B Re: Embedded Exec SQL versus SQL-CLI Performance (Link?) , D*B Re: Embedded Exec SQL versus SQL-CLI Performance (Link?) , Reeve Re: Embedded Exec SQL versus SQL-CLI Performance (Link?) , Alan Campin SQL Error - which program , Mitch Gallman RE: SQL Error - which program , Tyler, Matt Re: SQL Error - which program , x y RE: SQL Error - which program , Hudson, Ron Re: SQL Error - which program , Charles Wilt RE: Residential Delivery Indicator , Greg Wilburn Re: Residential Delivery Indicator , Jim Oberholtzer Page Group API , Ben Hoipkemier Re: Page Group API , Brad Stone Re: Page Group API , Charles Wilt Re: Page Group API , Charles Wilt RE: Pointer Reset operation? , Hiebert, Chris Re: Worksheet failing when reaching a large number of rows , Jorge Ubeda Using a timeout with display files , Javier Sanchez RE: Using a timeout with display files , John Rusling Re: Using a timeout with display files , Daniel Gross RE: Using a timeout with display files , Francois Lavoie RE: Using a timeout with display files , Francois Lavoie Write a record at a specific RRN , Paul Nicolay Re: Write a record at a specific RRN , x y RE: Write a record at a specific RRN , Francois Lavoie Re: Write a record at a specific RRN , x y RE: Write a record at a specific RRN , Francois Lavoie Re: Write a record at a specific RRN , Paul Nicolay Re: Write a record at a specific RRN , Carel Re: Write a record at a specific RRN , Paul Nicolay Re: Write a record at a specific RRN , Brian Parkins Re: Write a record at a specific RRN , x y Re: Write a record at a specific RRN , Paul Nicolay Re: Write a record at a specific RRN , x y Re: Write a record at a specific RRN , Alan Campin Re: Write a record at a specific RRN , Paul Nicolay RE: Write a record at a specific RRN , Francois Lavoie Re: Write a record at a specific RRN , Paul Nicolay Re: Write a record at a specific RRN , x y RE: Write a record at a specific RRN , Francois Lavoie Re: Write a record at a specific RRN , John Yeung Re: Write a record at a specific RRN , Paul Nicolay Re: Write a record at a specific RRN , John Yeung RE: Write a record at a specific RRN , Birgitta Hauser Re: Write a record at a specific RRN , Paul Nicolay Re: Write a record at a specific RRN , Charles Wilt Re: Write a record at a specific RRN , Paul Nicolay Re: Write a record at a specific RRN , John Yeung Re: Write a record at a specific RRN , Paul Nicolay Re: Write a record at a specific RRN , Charles Wilt Re: Write a record at a specific RRN , Jim Oberholtzer Re: Write a record at a specific RRN , Charles Wilt Re: Write a record at a specific RRN , Paul Nicolay Re: Write a record at a specific RRN , Paul Nicolay Overriding system value with native IO , Paul Nicolay Re: Overriding system value with native IO , Jon Paris Re: Overriding system value with native IO , Paul Nicolay Re: Overriding system value with native IO , Jon Paris <Possible follow-ups> Re: Using a timeout with display files , Javier Sanchez Re: Using a timeout with display files , Daniel Gross Re: Using a timeout with display files , Peter Dow Re: Using a timeout with display files , Jon Paris Re: Using a timeout with display files , Peter Dow Re: Using a timeout with display files , Jon Paris Re: Using a timeout with display files , Peter Dow Re: Using a timeout with display files , Jon Paris RE: Using a timeout with display files , John Rusling RE: Using a timeout with display files , Javier Sanchez RE: Using a timeout with display files , Tom Daly RE: Using a timeout with display files , Javier Sanchez Re: Using a timeout with display files , Peter Dow Re: Using a timeout with display files , Javier Sanchez Re: Write a record at a specific RRN , D*B Re: Write a record at a specific RRN , Paul Nicolay <Possible follow-ups> RE: Write a record at a specific RRN , Timothy Feldmeier Re: Write a record at a specific RRN , D*B Re: Write a record at a specific RRN , D*B Re: Write a record at a specific RRN , x y How to fetch into an array using dynamic SQL , mlazarus RE: How to fetch into an array using dynamic SQL , smith5646midrange Re: How to fetch into an array using dynamic SQL , mlazarus RE: How to fetch into an array using dynamic SQL , Birgitta Hauser Re: How to fetch into an array using dynamic SQL , mlazarus RE: How to fetch into an array using dynamic SQL , stefan RE: How to fetch into an array using dynamic SQL , Birgitta Hauser Re: How to fetch into an array using dynamic SQL , mlazarus RE: How to fetch into an array using dynamic SQL , dfreinkel Re: How to fetch into an array using dynamic SQL , mlazarus FW: How to fetch into an array using dynamic SQL , Birgitta Hauser Re: FW: How to fetch into an array using dynamic SQL , mlazarus RE: FW: How to fetch into an array using dynamic SQL , Birgitta Hauser RE: How to fetch into an array using dynamic SQL , Tyler, Matt web services parameters limitation , Jean-Marc DUVAL RE: web services parameters limitation , Alan Shore TR: web services parameters limitation , Jean-Marc DUVAL RE: web services parameters limitation , Jean-Marc DUVAL RE: web services parameters limitation , Alan Shore RE: web services parameters limitation , Jean-Marc DUVAL Re: web services parameters limitation , Jon Paris Re: web services parameters limitation , David Gibbs Re: web services parameters limitation , Marco Facchinetti Re: web services parameters limitation , Maria Lucia Stoppa Re: web services parameters limitation , Marco Facchinetti RE: web services parameters limitation , Jean-Marc DUVAL Re: web services parameters limitation , Maria Lucia Stoppa RE: web services parameters limitation , Jean-Marc DUVAL DS argument list for i/o vs. listing the arguments at the i/o statement , Alan Cassidy Re: DS argument list for i/o vs. listing the arguments at the i/o statement , David Gibbs Re: DS argument list for i/o vs. listing the arguments at the i/o statement , Vern Hamberg RE: DS argument list for i/o vs. listing the arguments at the i/o statement , Roger Harman RE: DS argument list for i/o vs. listing the arguments at the i/o statement , dfreinkel Re: DS argument list for i/o vs. listing the arguments at the i/o statement , Vern Hamberg Re: DS argument list for i/o vs. listing the arguments at the i/o statement , Jon Paris Re: DS argument list for i/o vs. listing the arguments at the i/o statement , Brian Parkins Re: DS argument list for i/o vs. listing the arguments at the i/o statement , Jon Paris Re: DS argument list for i/o vs. listing the arguments at the i/o statement , Brian Parkins *** ADMIN: Reminder email address harvesting is FORBIDDEN , midrange-announce Re: DS argument list for i/o vs. listing the arguments at the i/o statement , Javier Sanchez Re: DS argument list for i/o vs. listing the arguments at the i/o statement , Jon Paris Here's an interesting RPG parameter Issue , Brad Stone RE: Here's an interesting RPG parameter Issue , Tyler, Matt Re: Here's an interesting RPG parameter Issue , Brad Stone Re: Here's an interesting RPG parameter Issue , Jay Re: Here's an interesting RPG parameter Issue , Brian Parkins Re: Here's an interesting RPG parameter Issue , Brad Stone Re: Here's an interesting RPG parameter Issue , Brian Parkins Re: Here's an interesting RPG parameter Issue , Brad Stone Re: Here's an interesting RPG parameter Issue , Jeff Crosby Re: Here's an interesting RPG parameter Issue , Jay Data-Into using YAJLINTO question , Greg Wilburn Re: Data-Into using YAJLINTO question , Tim Fathers RE: Data-Into using YAJLINTO question , Greg Wilburn Re: Data-Into using YAJLINTO question , Tim Fathers RE: Data-Into using YAJLINTO question , Greg Wilburn Re: Data-Into using YAJLINTO question , Jon Paris RE: Data-Into using YAJLINTO question , Greg Wilburn Re: Data-Into using YAJLINTO question , Jon Paris RE: Data-Into using YAJLINTO question , Greg Wilburn Re: Data-Into using YAJLINTO question , Jon Paris RE: Data-Into using YAJLINTO question , Greg Wilburn Re: Data-Into using YAJLINTO question , Jon Paris Embedded SQL issue , Brian Garland RE: Embedded SQL issue , Paul Therrien <Possible follow-ups> RE: Embedded SQL issue , Brian Garland RE: Embedded SQL issue , Ellen Eliason RE: Embedded SQL issue , Brian Garland Re: Embedded SQL issue , Justin Taylor RE: Embeddded SQL issue , Brian Garland Sharing access paths , dfreinkel RE: [EXTERNAL] Sharing access paths , Alan Shore RE: [EXTERNAL] Sharing access paths , dfreinkel Re: Sharing access paths , Patrik Schindler Re: Sharing access paths , Vern Hamberg RE: Sharing access paths , dfreinkel copy/include in QSYSINC in **FREE format , midrangel RE: copy/include in QSYSINC in **FREE format , stefan Re: copy/include in QSYSINC in **FREE format , Roberto De Pedrini Re: copy/include in QSYSINC in **FREE format , Charles Wilt RE: copy/include in QSYSINC in **FREE format , midrangel Re: copy/include in QSYSINC in **FREE format , Barbara Morris Re: copy/include in QSYSINC in **FREE format , Bruce Vining large difference in job run times between bound procedure call, and procedure call from within program. , Gerald Magnuson Re: large difference in job run times between bound procedure call, and procedure call from within program. , Ali Ekinci Re: large difference in job run times between bound procedure call, and procedure call from within program. , Gerald Magnuson Re: large difference in job run times between bound procedure call, and procedure call from within program. , Alan Campin Re: large difference in job run times between bound procedure call, and procedure call from within program. , Gerald Magnuson Re: large difference in job run times between bound procedure call, and procedure call from within program. , Alan Campin Re: large difference in job run times between bound procedure call, and procedure call from within program. , Gerald Magnuson Re: large difference in job run times between bound procedure call, and procedure call from within program. , Barbara Morris Re: large difference in job run times between bound procedure call, and procedure call from within program. , Alan Campin Re: large difference in job run times between bound procedure call, and procedure call from within program. , Brian Parkins Re: large difference in job run times between bound procedure call, and procedure call from within program. , Barbara Morris Re: large difference in job run times between bound procedure call, and procedure call from within program. , Daniel Gross Re: large difference in job run times between bound procedure call, and procedure call from within program. , Jay Vaughn Re: large difference in job run times between bound procedure call, and procedure call from within program. , Alan Campin RE: large difference in job run times between bound procedure call, and procedure call from within program. , dfreinkel Re: large difference in job run times between bound procedure call, and procedure call from within program. , Alan Campin Re: large difference in job run times between bound procedure call, and procedure call from within program. , Charles Wilt RD: Embedded SQL issue , Brian Garland RE: RD: Embedded SQL issue , Therrien, Paul bnddir *SRVPGM *IMMED vs *DEFER , Jay Vaughn Re: bnddir *SRVPGM *IMMED vs *DEFER , Brad Stone Re: bnddir *SRVPGM *IMMED vs *DEFER , Jay Vaughn Re: bnddir *SRVPGM *IMMED vs *DEFER , Mark Waterbury Re: bnddir *SRVPGM *IMMED vs *DEFER , Don Brown AW: bnddir *SRVPGM *IMMED vs *DEFER , Thomas Raddatz Re: bnddir *SRVPGM *IMMED vs *DEFER , Jay Vaughn Re: bnddir *SRVPGM *IMMED vs *DEFER , Mark Waterbury Re: bnddir *SRVPGM *IMMED vs *DEFER , x y SQL call qsys2.qcmdexc , smith5646midrange Re: SQL call qsys2.qcmdexc , Raul Alberto Jager Weiler Re: SQL call qsys2.qcmdexc , Barbara Morris Re: SQL call qsys2.qcmdexc , Bryan Dietz subject: Re: Worksheet failing when reaching a large number of rows-Using SXSSFWorkbook Hello Jorge, I think POI 3.9 should work as I believe the streaming was added to 3.8 beta 3. However if it is failing I would suggest installing the 3.14 version and adjusting your classpath to test with the later version. We have successfully created spreadsheets with close to a million records maybe even over the million, the spreadhseet was fine. But we did then have a problem emailing the spreadsheet as it was too big. Hope this helps. Thanks Don , Jorge Ubeda Re: subject: Re: Worksheet failing when reaching a large number of rows-Using SXSSFWorkbook Hello Jorge, I think POI 3.9 should work as I believe the streaming was added to 3.8 beta 3. However if it is failing I would suggest installing the 3.14 version and adjusting your classpath to test with the later version. We have successfully created spreadsheets with close to a million records maybe even over the million, the spreadhseet was fine. But we did then have a problem emailing the spreadsheet as it was too big. Hope this helps. Thanks Don , Don Brown subject: Re: Worksheet failing when reaching a large number of rows-Using SXSSFWorkbook , Jorge Ubeda <Possible follow-ups> Re: subject: Re: Worksheet failing when reaching a large number of rows-Using SXSSFWorkbook , Jorge Ubeda Re: subject: Re: Worksheet failing when reaching a large number of rows-Using SXSSFWorkbook , Don Brown SQLRPGLE Cast Lose Zeros , gio.cot RE: [EXTERNAL] SQLRPGLE Cast Lose Zeros , Alan Shore RE: SQLRPGLE Cast Lose Zeros , Therrien, Paul Re: SQLRPGLE Cast Lose Zeros , erifam DDL table add key column? , Justin Taylor Re: DDL table add key column? , Mark Waterbury RE: DDL table add key column? , Birgitta Hauser Re: DDL table add key column? , Brian Johnson Re: DDL table add key column? , Jay Vaughn <Possible follow-ups> Re: DDL table add key column? , Justin Taylor QLICHGLL api APIError , midrangel RE: QLICHGLL api APIError , Tyler, Matt RE: QLICHGLL api APIError , midrangel YAJLDTAGEN question , Greg Wilburn Re: YAJLDTAGEN question , Charles Wilt RE: YAJLDTAGEN question , Greg Wilburn Re: YAJLDTAGEN question , Jon Paris CPF2217 running on FTP exit program , gio.cot Re: CPF2217 running on FTP exit program , Jim Oberholtzer Re: CPF2217 running on FTP exit program , Bruce Vining *** ADMIN: Replying to digest messages , midrange-announce