IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Code Multi Row fetch in PL1 program


IBM Mainframe Forums -> PL/I & Assembler
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Kunal Vatsyayan

New User


Joined: 05 Mar 2023
Posts: 1
Location: Belgium

PostPosted: Sun Mar 05, 2023 2:25 am
Reply with quote

Hello,

I am working on creating a solution as a part of that I have written a PL1 program to fetch records from some tables and write it in a PS file and process that file in further programs.
Currently I am using Cursor to fetch the records, I also want to check the performance of the code after using Multi row fetch cursor as I am fetching very high amount of data around 80 million.
I am getting an error while creating arrays to store the data for the columns that will be fetched in Multi row fetch cursor and also how to use these arrays while fetching from cursor. If anyone has experience of using MRF in PL1, It will be really helpful if you can mention how to implement it.

Thanks and Regards,
Kunal
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2030
Location: USA

PostPosted: Sun Mar 05, 2023 4:31 am
Reply with quote

Real sample of your code, please!

P.S.
Do not forget to use the Code button for any sample.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> PL/I & Assembler

 


Similar Topics
Topic Forum Replies
No new posts To fetch records that has Ttamp value... DFSORT/ICETOOL 4
No new posts Using API Gateway from CICS program CICS 0
No new posts run rexx code with jcl CLIST & REXX 15
No new posts Compile rexx code with jcl CLIST & REXX 6
No new posts DB2 Event passed to the Application P... DB2 1
Search our Forums:

Back to Top