View previous topic :: View next topic
|
Author |
Message |
usharaniA
New User
Joined: 22 Jan 2008 Posts: 85 Location: India
|
|
|
|
HI,
I want to add set of Sql queries into the ISPF tables and depending on my requirement i want to execute the queries.
Now my problems is ,if my query is too lengthier it will be inserted in more than one row.And in ISPf tables we can invoke the datas only in row wise.
so how to achieve on adding Lengthier queries in ISPf tables and how to invoke them. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
It is not quite clear what you want to do. Do you want to use the output of an SQL query to be loaded into an ISPF table, or use SQL to access an ISPF table. |
|
Back to top |
|
|
usharaniA
New User
Joined: 22 Jan 2008 Posts: 85 Location: India
|
|
|
|
I want to store the Sql queries inside the ISPF tables. |
|
Back to top |
|
|
usharaniA
New User
Joined: 22 Jan 2008 Posts: 85 Location: India
|
|
|
|
My requirement is i want to get ,a set of SQL query from the user using ISPF panels and want to store these queries inside some tables or flat files.(as i want, one time user entry i want to store it some where)
Then depending on the user requirement i want to execute the queries by retrieving from the stored area. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Why not use a PDS to store the queries ? |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
why re-invent spufi and/or QMF with ISPF Tables?
How are you going to execute the SQL? |
|
Back to top |
|
|
|