View previous topic :: View next topic
|
Author |
Message |
suresh111
New User
Joined: 14 Feb 2005 Posts: 17
|
|
|
|
Hi,
I have a large Query in my PS. I want to copy that SQL to SQL QUERY in QMF for execute that query. Could you please suggest me How can I retrieve My Query from PS to QMF.
Thanks for your help in advance.
Regards,
Suresh |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
Hi,
Open the PS which contains the query; Copy it using CUT command. In QMF, issue "EDIT QUERY" on command line and there just PASTE it. And press PF3 to come back...
Makes any sense? |
|
Back to top |
|
|
prem_ibm
New User
Joined: 15 Sep 2007 Posts: 31 Location: Chennai
|
|
|
|
Hi
in QMF give below on command line
IMPORT SQL FROM 'PS NAME' enter.....
it will take that SQL Query in QMF pannel....hope it wil help to u.
Thanks
Prem |
|
Back to top |
|
|
suresh111
New User
Joined: 14 Feb 2005 Posts: 17
|
|
|
|
Hi Gnana Sekaran,
Thanks a lot, it is working fine.
Regards,
Suresh |
|
Back to top |
|
|
suresh111
New User
Joined: 14 Feb 2005 Posts: 17
|
|
|
|
Hi Prem,
As you said that I tried but it is showing that "SQL cannot be imported"
Regards,
Suresh |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Use "IMPORT QUERY FROM 'PS NAME' ".
"SQL" is not a valid object-name in this context. Only QUERY, FORM, PROC, TABLE, or DATA can be imported. |
|
Back to top |
|
|
suresh111
New User
Joined: 14 Feb 2005 Posts: 17
|
|
|
|
Hi Anju,
Thank You.
It is working fine.
Regards,
Suresh |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
You're welcome ..
PS> Spelling of my name is Anuj. |
|
Back to top |
|
|
|