MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Where to start to create M/F PANELS,read/write a dataset

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> TSO and ISPF
View previous topic :: View next topic  
Author Message
shanrice
Beginner


Joined: 04 Nov 2006
Posts: 5
Topics: 2

PostPosted: Sat Nov 04, 2006 8:51 pm    Post subject: Where to start to create M/F PANELS,read/write a dataset Reply with quote

Currently I have a requirement wherein the user edits the data in a spreadsheet and sends the file to me. Using the file transfer, I upload the file to mainframe dataset and read this input data in a Cobol program. Often times the user sends me some weired formatted data and I have to manually correct the file before uploading.

The spread sheet has like 200 rows and only 1 or 2 actual column value changes when I get the spreadsheet. After from the 1 or 2 changes, I get a lot of formatting issues.

Well I am planning to get rid of the upload part and put the 200 records in a dataset and give a panel to the user to edit the data by changing or adding a couple of rows to the input. Where do I start reading to create a panel, read/write the dataset to insert/replace/delete existing rows or columns.

TIA
Back to top
View user's profile Send private message
ofer71
Intermediate


Joined: 12 Feb 2003
Posts: 358
Topics: 4
Location: Israel

PostPosted: Sun Nov 05, 2006 1:09 am    Post subject: Reply with quote

Panels are components of ISPF Dialog, so you need to start by reading ISPF Dialog Developer's Guide.

Handling datasets and interacting with ISPF panels can be done in any Z/os language, but for your request, I think REXX would be perfect. You may want to read about it in TSO/E REXX Reference.

O.
________
Suzuki GSV-R history


Last edited by ofer71 on Sat Feb 05, 2011 11:52 am; edited 1 time in total
Back to top
View user's profile Send private message Send e-mail
shanrice
Beginner


Joined: 04 Nov 2006
Posts: 5
Topics: 2

PostPosted: Sun Nov 05, 2006 7:51 pm    Post subject: Reply with quote

Appreciate your help! I have a long drive ahead to complete my task.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> TSO and ISPF All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group