View previous topic :: View next topic
|
Author |
Message |
MFSubbu
New User
Joined: 16 Feb 2008 Posts: 19 Location: Bangalore
|
|
|
|
Hi All,
I have a good knowledge in REXX and I am very new to CLIST. I have to develop a tool. I have few questions...
1) I have to read a table, display the data in panel and do scrolling(PF7, PF8, PF10 etc...).. Which will be a better option CLIST or REXX...
2) Can we execute a SQL Query using CLIST.. if yes,, can you provide me with a sample program... |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8796 Location: Welsh Wales
|
|
|
|
REXX will be by far the better option. |
|
Back to top |
|
|
MFSubbu
New User
Joined: 16 Feb 2008 Posts: 19 Location: Bangalore
|
|
|
|
Thanks expat... Just feeling curious to know the reason behind REXX as the better option...
Any answer for the second question??? |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8796 Location: Welsh Wales
|
|
|
|
REXX is far easier to code, and to maintain, has more functionality, has its own DB2 interface.
2nd question - probably, but I wouldn't even consider looking for it.
Have you tried google |
|
Back to top |
|
|
MFSubbu
New User
Joined: 16 Feb 2008 Posts: 19 Location: Bangalore
|
|
|
|
Yes i tried that as well.. It didnt fetch valuable result... and hence i thought of asking the experts here... |
|
Back to top |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006 Posts: 1353 Location: Israel
|
|
|
|
There are at least 10 differences between these 2 pictures: CLIST and REXX |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10886 Location: italy
|
|
|
|
Quote: |
Can we execute a SQL Query using CLIST.. |
NO |
|
Back to top |
|
|
MFSubbu
New User
Joined: 16 Feb 2008 Posts: 19 Location: Bangalore
|
|
|
|
Thanks to all for ur response..
In my first question - "I have to read a table, display the data in panel and do scrolling(PF7, PF8, PF10 etc...).. ".. How can i implement scrolling in REXX...
Any sample program will be so helpful.... |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8796 Location: Welsh Wales
|
|
|
|
Quote: |
How can i implement scrolling in REXX... |
Please explain in detail what this means. |
|
Back to top |
|
|
MFSubbu
New User
Joined: 16 Feb 2008 Posts: 19 Location: Bangalore
|
|
|
|
I need to fetch data from DB2 Table... and should display it in panel...
The table is huge with large no of data... and so i should be able to use PF7,PF8,PF10,PF11 keys to scroll through the data in the panel....
Sample program to implement PF keys funtionality will be very helpful |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8796 Location: Welsh Wales
|
|
|
|
Why not just browse the dataset created either by the fetch, or a reformatted version, and use the built in PF keys asis. |
|
Back to top |
|
|
prino
Senior Member
Joined: 07 Feb 2009 Posts: 1314 Location: Vilnius, Lithuania
|
|
|
|
MFSubbu wrote: |
The table is huge with large no of data... |
Are you aware that you can use ISPF panels in compiled languages, REXX is good for working with small amounts of data, not huge DB2 tables... |
|
Back to top |
|
|
MFSubbu
New User
Joined: 16 Feb 2008 Posts: 19 Location: Bangalore
|
|
|
|
expat: after displaying the data in the panel.. i need to do further processing by selecting any row.... so for that i need the data to be displayed in the panel...
prino: Thanks for suggestion to improve performance.. What i said is one of module.. which i can try that with any compiled language... but i have few more requirement with small no of data.. but the no of data will not fit in one screen(panel).. so i need to have PF7, PF8, PF10,PF11 funtionality in my panel...
Please help... |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8796 Location: Welsh Wales
|
|
|
|
What have you tried so far and which problems have you encountered. |
|
Back to top |
|
|
MFSubbu
New User
Joined: 16 Feb 2008 Posts: 19 Location: Bangalore
|
|
|
|
to start with.. i created my own ISPF table and tried using TBDISPL to display the data in the table..( I am not sure if this is the efficient method)... I have 30 records in the table.. and it is displyaing first 10 records in my panel and if I use the DOWN command it is returning with RC 8. Just today i started working on ISPF tables.. following is the prog i coded..
Code: |
CALL OPEN_TABLE
'TBDISPL' EMP 'PANEL('TBPANEL')'
'TBDISPL' EMP
CALL CLOSE_TABLE
CALL END_PROCESS
EXIT
OPEN_TABLE:
"TBCLOSE" EMP
"TBOPEN" EMP
IF RC = 8 THEN SAY 'TABLE DOES NOT EXIST'
RETURN
CLOSE_TABLE:
"TBCLOSE" EMP
RETURN
END_PROCESS:
RETURN
|
Please let me know what changes to be done to display all the records. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8796 Location: Welsh Wales
|
|
|
|
I would guess that the problem may be in the panel definition.
Can you post that too. |
|
Back to top |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006 Posts: 1353 Location: Israel
|
|
|
|
Download this file
Print it, try the examples (mostly the Dynamic area example)...
...then you'll see why it is not made for "huge table with large no of data"...
...but maybe it is possible to fetch only the rows for the current page?
That would make it possible. More complex but possible, I think. |
|
Back to top |
|
|
|