deleting all non-exclude X ALL lines in ISPF

How to delete all Un-Excluded Lines in ISPF

Generally you would have used :
x all; find all <criteria>; del x all

It deletes all lines you have excluded (and don’t need any more) in your dataset.

Here we have different scenario:

We want to exclude all lines that meets a <criteria> and then delete all lines that don’t meet the <criteria> …

steps :

[1] x all <criteria>

It will exclude all lines having the <criteria>

Now read carefully

Now you want to delete all visible lines and keep all excluded lines (which meets your <criteria>)…………..

and unwanted lines are now visible to you.

you want to delete these all visible (unwanted) lines.

the command you have to issue is :

[2] del all nx

it will keep all excluded lines and delete all visible lines.

You will see all the lines are excluded in your dataset,

Just issue reset command and view the result..

Got it ??? !!!!

“RFIND is not active” in the SDSF

RFind PF5/PF6 is not working in my SDSF

In SDSF  the Repeat find command is not available as the application ID is different and do not share the same keys listing as ISPF….

We have to change the keys list for SDSF (one time setting –of course in one shop)

1. Go to SDSF;ST
2. Select all of any JOB
3. Type ‘keys’ and hit return key
4. On PF5 (or PF6) type IFIND in stead of RFIND
5. Hit PF3 

VOILA… WE are done…!!!

Now WE can repeat find using the same PF5 (or PF6) as we do in ISPF……..

+++++++++++++++++++++++++++++++++++++++++++++++++

Courtesy: 

+++++++++++++++++++++++++++++++++++++++++++++++++

I got the information from following websites:

http://www.davar.net/MF/REFER/FAQ.HTM

http://www.mvshelp.net/vbforums/showthread.php?p=206522

Steve,
SDSF runs under a unique Application ID so the PFkey definitions are separate from ISPF. Enter KEYS when in SDSF to verify the value for PF5.

__________________
Regards,
Bill Dennis

+++++++++++++++++++++++++++++++++++++++++++++++++

also read this 

+++++++++++++++++++++++++++++++++++++++++++++++++

Hi I found the following statement in the appendix of the sdsf manual … maybe it helps       

If you use the Repeat-Find PF keys under ISPF and they don’t invoke the 
Repeat Find function, the problem may be that the SDSF table library was 
not concatenated correctly with the ISPF table libraries. You may also see 
the ISPF message RFIND NOT ACTIVE to indicate this. The SDSF Repeat-Find key should be defined as IFIND.

+++++++++++++++++++++++++++++++++++++++++++++++++

One trick in MS OFFICE for Find and Replace

 

One trick in MS OFFICE for Find and Replace

MS Office 2003 allows find and replacing dependent vowel symbols like hrswa i deergha ee hrswa u deergha oo etc.
I had discovered this trick at the time when I was doing all data corrections after converting the lexicon-data to Unicode.
For example if you want to convert a document typed in SARTH to UNZA…
You can replace all hrswa i to deergha ee as well as all deergha oo to hrswa u

We have to type the dependant i vowel symbol in a notepad and then copy and paste to find and replace window like shown below

Then only the buttons (replace/replace all and find next) will be activated.
If you click replace all, it will replace all hrswa I with deergha ee…..
Similarly for hrswa u and deergha oo
See the picture below

 all the best

Hyperlink in ms excel – use of JCL PARM, SYSIN

How to provide hyperlink in Microsoft Excel:

Function =HYPERLINK(“url_link”, “display_name”) is used in MS Excel for creating hyperlinks.

If we have created all the links using Microsoft word — it replaces simple quotes with smart quotes — which excel doesn’t take for hyperlink function. We have to replace all smart-quotes (“”) with simple quotes (“”).

Mainframe Tips:

If we are passing data from JCL PARM=”data” then we have to take care in linkage section for removing the wrapper using picture s9(04) comp. and then the catch the real data.

The data we pass through SYSIN can be read by ACCEPT statements in COBOL