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

REXX SDSF filtering


IBM Mainframe Forums -> CLIST & REXX
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Ken Wong

New User


Joined: 15 Jan 2013
Posts: 5
Location: Hong Kong

PostPosted: Tue Jul 27, 2021 2:09 pm
Reply with quote

I am now learning how to get job information from SDSF using REXX. I have read some IBM manuals and found that there is a RGEN command that can generate a REXX exec for the current SDSF panel with all the option like prefix and filter.

I have input the following commands in SDSF:
ST
PRE *I
FIL JOBCRDATE GT 07/27/2021 08:00:00

I got what I wanted in SDSF and then I enter the RGEN command hoping it will generate a functioning REXX exec for me but the exec failed at the filter step:

Code:

sdsffiltermode = 'AND'
sdsffilter = 'JOBCRDATE LT 7/27/2021 08:00:00'


and the result from the TRACE O command inside the REXX is:
.
..
...
ISF741E Error processing command 'FIL JOBCRDATE LT 7/27/2021' associated with variable SDSFFILTER, reason: PARM INVALID.
.....
** ISFEXEC failed with rc=08.

Seems like the parm cannot have space in between. (7/27/2021 08:00:00)

I have searched online and searched IBM manuals and found no mentioning of the above problem.

Is there anyone have the same experience can share some ideas?
Back to top
View user's profile Send private message
Joerg.Findeisen

Active Member


Joined: 15 Aug 2015
Posts: 607
Location: Bamberg, Germany

PostPosted: Tue Jul 27, 2021 2:48 pm
Reply with quote

Try if this sample works (note that it's YY and NOT CCYY):
Code:
sdsffilter = 'JOBCRDATE LE 07/26/21 07:48:00'
Back to top
View user's profile Send private message
Ken Wong

New User


Joined: 15 Jan 2013
Posts: 5
Location: Hong Kong

PostPosted: Tue Jul 27, 2021 3:20 pm
Reply with quote

Actually, I have tried many date and time format combination including your suggestion. It still failed with the same error.

I have tried to copy the command 'FIL JOBCRDATE LT 07/27/2021 08:00:00' and paste it in SDSF ST panel and the result is positive. The filter can be set up properly in SDSF but failed in REXX.

It always failed with 'PARM INVALID' and I noticed that the error returned always quoted 'FIL JOBCRDATE LT 07/27/2021'. It only captured the date without the time.

That's why I doubt the parm cannot have space in between. I even tried something like:
"FIL JOBCRDATE LT '07/27/2021 08:00:00'"
'FIL JOBCRDATE LT ''07/27/2021 08:00:00'''

but still failed to have a proper setup.
Back to top
View user's profile Send private message
Joerg.Findeisen

Active Member


Joined: 15 Aug 2015
Posts: 607
Location: Bamberg, Germany

PostPosted: Tue Jul 27, 2021 4:00 pm
Reply with quote

As I have written, please try the Year as two digits only.
Back to top
View user's profile Send private message
Ken Wong

New User


Joined: 15 Jan 2013
Posts: 5
Location: Hong Kong

PostPosted: Tue Jul 27, 2021 4:45 pm
Reply with quote

Tried but no lucky
Back to top
View user's profile Send private message
Willy Jensen

Active User


Joined: 01 Sep 2015
Posts: 495
Location: Denmark

PostPosted: Tue Jul 27, 2021 9:13 pm
Reply with quote

Sems that job creation time is not selectable. When I do
isfprefix='*'
isffiltermode = 'AND'
isffilter = 'JOBCRDATE LT 7/26/2021'
address SDSF "ISFEXEC ST"
I get a number of job variables listed, but no JOBCRTIME, actually no *TIME* at all.
I can do multiple date creation tests like isffilter = 'JOBCRDATE LT 7/26/2021 JOBCRDATE GT 1/1/2021' , but not by time.
Note that ISFFILTER is an alias to SDSFFILTER (or vice versa).
Back to top
View user's profile Send private message
Ken Wong

New User


Joined: 15 Jan 2013
Posts: 5
Location: Hong Kong

PostPosted: Tue Jul 27, 2021 9:38 pm
Reply with quote

I am now using DATEN and TIMEN filter combination to get my result and it is okay now.
Back to top
View user's profile Send private message
Willy Jensen

Active User


Joined: 01 Sep 2015
Posts: 495
Location: Denmark

PostPosted: Tue Jul 27, 2021 9:45 pm
Reply with quote

Good, besides I was wrong, there is a TIMER.n generated.
Back to top
View user's profile Send private message
Pedro

Global Moderator


Joined: 01 Sep 2006
Posts: 2258
Location: Silicon Valley

PostPosted: Wed Jul 28, 2021 2:34 am
Reply with quote

If the RGEN command generates the JOBCRDATE and it is not a valid parameter, you should open a PMR with IBM.
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 -> CLIST & REXX

 


Similar Topics
Topic Forum Replies
No new posts How to modify file content using REXX CLIST & REXX 3
No new posts Same command as on commandline in REX... TSO/ISPF 6
No new posts process statement for SUPREC, CMPCOLM... TSO/ISPF 4
No new posts Trying to reference a javascript glob... CLIST & REXX 7
No new posts REXX - Adding variables CLIST & REXX 8
Search our Forums:

Back to Top