IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

HILITE Command


IBM Mainframe Forums -> TSO/ISPF
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Wed Jun 29, 2011 4:02 pm
Reply with quote

Hi,

Currently "HILITE SQL" is not available as a language to hilite SQL keywords.
How can we do the customization of HILITE command to include Hi lighting of SQL Keywords?
Back to top
View user's profile Send private message
Dsingh29

Active User


Joined: 16 Dec 2008
Posts: 132
Location: IBM

PostPosted: Wed Jun 29, 2011 4:37 pm
Reply with quote

search for ISRPXASM, the ISPF user-customizable table
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 765
Location: Whitby, ON, Canada

PostPosted: Wed Jun 29, 2011 5:14 pm
Reply with quote

Dsingh29 wrote:
search for ISRPXASM, the ISPF user-customizable table
Alternatively, I find that HILITE REXX is a reasonable though imperfect substitute for a true HILITE SQL.
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Wed Jun 29, 2011 5:54 pm
Reply with quote

Thanks...

I googled it and found that ISRPXASM is present in the IBM-supplied ISPF sample library.

What is that library name? Also making changes at the system library level will affect all the users. Can we not do it at user level?
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 765
Location: Whitby, ON, Canada

PostPosted: Wed Jun 29, 2011 8:09 pm
Reply with quote

The library name depends on your installation standards. You might be able to find it by searching for 'SYS1.*samp'

If you link the ISRPX module into a private load library, you can allocate it to your personal ISPLLIB concatenation and thus avoid affecting anyone else.

I experimented with this today, but was only partially successful. The SQL keywords are highlighted, but it does not recognize the -- comment characters. There must be more to it than just ISRPXASM; looking at the Cobol language definition, for example, I don't see how you would specify that an asterisk in column 7 indicates a comment.
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Thu Jun 30, 2011 12:53 pm
Reply with quote

don.leahy wrote:

If you link the ISRPX module into a private load library, you can allocate it to your personal ISPLLIB concatenation and thus avoid affecting anyone else.


Thanks... I am able to locate the library... Can you tell me how to link ISRPX module into a private load library ?
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 765
Location: Whitby, ON, Canada

PostPosted: Fri Jul 01, 2011 1:55 am
Reply with quote

Assemble and link the source in the normal way, pointing the link edit output to your favourite load library. For link control cards follow the instructions in the comments in ISRPXASM.

If you are not comfortable with assembler, the linkage editor, and ISPF allocations, then I suggest you seek advice from a friendly systems programmer. If you make a mistake you might cripple your ISPF session, and if you don't know how to extricate yourself you will need his/her help.
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Fri Jul 01, 2011 11:27 am
Reply with quote

Thanks don.leahy.....
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> TSO/ISPF

 


Similar Topics
Topic Forum Replies
No new posts RACF - Rebuild SETROPTS command which... All Other Mainframe Topics 3
No new posts HILITE on Browse mode? TSO/ISPF 2
No new posts Routing command Address SDSF to other... TSO/ISPF 2
No new posts DTL - how to define key with stacked ... TSO/ISPF 3
No new posts LTJ command CA Products 4
Search our Forums:

Back to Top