CLIST vs REXX & Executing SQL Query using CLIST

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...

expat · Posted: Tue Aug 11, 2009 4:02 pm

REXX will be by far the better option.

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???

expat · Posted: Tue Aug 11, 2009 4:20 pm

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

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...

Marso · Posted: Tue Aug 11, 2009 8:07 pm

There are at least 10 differences between these 2 pictures: CLIST and REXX

enrico-sorichetti · Posted: Tue Aug 11, 2009 8:17 pm

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....

expat · Posted: Wed Aug 12, 2009 11:16 am

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

expat · Posted: Wed Aug 12, 2009 11:26 am

Why not just browse the dataset created either by the fetch, or a reformatted version, and use the built in PF keys asis.

prino · Posted: Wed Aug 12, 2009 11:28 am

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...

expat · Posted: Wed Aug 12, 2009 11:48 am

What have you tried so far and which problems have you encountered.

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..

expat · Posted: Wed Aug 12, 2009 12:12 pm

I would guess that the problem may be in the panel definition.
Can you post that too.

Marso · Posted: Thu Aug 13, 2009 1:54 am

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.