Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

how to comment all queries in spufi?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
gvt460

New User


Joined: 04 Mar 2005
Posts: 23

PostPosted: Thu May 05, 2005 4:14 pm    Post subject: how to comment all queries in spufi?
Reply with quote

hai
i like to know how to comment all quiries all quiries in spufi?
let me know
Back to top
View user's profile Send private message

avm

New User


Joined: 20 Apr 2005
Posts: 6

PostPosted: Thu May 05, 2005 5:21 pm    Post subject: Re: how to comment all queries in spufi?
Reply with quote

gvt460 wrote:
hai
i like to know how to comment all quiries all quiries in spufi?
let me know


Hi

To comment any query in spufi give two hyphens before the query in the spufi. This will comment that line.

Bye

AVM.
Back to top
View user's profile Send private message
gvt460

New User


Joined: 04 Mar 2005
Posts: 23

PostPosted: Thu May 05, 2005 5:27 pm    Post subject: Re: how to comment all queries in spufi?
Reply with quote

i want to comment all quiries at a time?
is there any way let me know.
Back to top
View user's profile Send private message
arasu1982

New User


Joined: 05 Mar 2005
Posts: 7
Location: Bangalore

PostPosted: Thu May 05, 2005 5:45 pm    Post subject: Re: how to comment all queries in spufi?
Reply with quote

[quote="gvt460"]i want to comment all quiries at a time?
is there any way let me know.[/quote]


Hi,
just give double hyphens(--) in new line and copy that line using command (c).
Using overlay(o) with no. of lines u can comment how much lines u want to comment.
Back to top
View user's profile Send private message
ovreddy

Active User


Joined: 06 Dec 2004
Posts: 211
Location: Keane Inc., Minneapolis USA.

PostPosted: Thu May 05, 2005 5:49 pm    Post subject: Re: how to comment all queries in spufi?
Reply with quote

Hi GVT,

We can comment all queries in SPUFI in one step as follows.

- First Move all queries into second column using )) line command.

at begining give )) in first column. give ))1 at end

))01
0002
0003
0004
))105

- Then give change command as follows

C ' ' '--' 1 all ( in command line and press enter)

Thanks,
Reddy.
Back to top
View user's profile Send private message
gvt460

New User


Joined: 04 Mar 2005
Posts: 23

PostPosted: Fri May 06, 2005 11:21 am    Post subject: Re: how to comment all queries in spufi?
Reply with quote

thanks for u r fast reply reddy
but it is not working properly.
could u explain me once again.
Back to top
View user's profile Send private message
David P

Active User


Joined: 11 Apr 2005
Posts: 106
Location: Cincinnati Ohio

PostPosted: Fri May 06, 2005 11:51 am    Post subject:
Reply with quote

Hi all,
I agree with the solution provided by ovreddy but I would like to know in what situation you want to comment all the quries, What I understand by this is you do not want to execute any of the quries then why are you worried if they are commented or not.

please let me know in case of any concens.
regards,
David.
Back to top
View user's profile Send private message
ovreddy

Active User


Joined: 06 Dec 2004
Posts: 211
Location: Keane Inc., Minneapolis USA.

PostPosted: Sun May 15, 2005 12:54 pm    Post subject:
Reply with quote

Hi GVT & David,

As I know it will work. I tried it many times infact i am using it daily. U may be mistaken in giving replace command once again i will give syntax for replace.

C ' ' '--' 1 all ( in command line and press enter
C 'blanksapce' 'dash dash' 1 all (ENTER)
Before that u need to put (( in the begining of first and last lines.

David,

There are situations we need to comment all queries. Already i have some 10 queries in SPUFI. Now I want to write one more single line SELECT in the same SPUFI Input file and execute. So first we will comment all then insert new query in the first line.

Thanks,
Reddy.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Problems in File-Aid / DB2 Spufi whil... amitc23 CLIST & REXX 6 Fri Feb 12, 2016 1:59 pm
No new posts Not able to access the DB2 via SPUFI sakthikumarT DB2 6 Sat Nov 28, 2015 1:52 am
No new posts Running queries against OLTP Database A_programmers DB2 3 Tue Jul 14, 2015 4:51 pm
No new posts DB2 program returned data is dif than... pradeepkit DB2 1 Tue Mar 03, 2015 5:39 am
No new posts Selective execution of a queries Delip DB2 9 Fri Jan 16, 2015 3:51 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us