Search found 45 matches

by sivasaras
Tue Nov 01, 2016 7:26 pm
Forum: TSO, CLIST & REXX
Topic: how to restrict access in REXX
Replies: 0
Views: 4271

how to restrict access in REXX

hi,

i want to do access control for my REXX code to use only a set of peoples assigned to the group.

EMPSAL - 3 members added to that group.

how to restrict access only to this group in REXX.

Thanks
siva
by sivasaras
Wed Sep 21, 2016 5:54 pm
Forum: COBOL
Topic: Cobol program to get data from Large table
Replies: 2
Views: 4403

Cobol program to get data from Large table

I have a table having 7 million records but I want to get only the 2016 data for the employees having the grade from 1 TO 100 . Is that possible to get total count of each grade through a DB2 query. I have a program which I have to run 100 times to get the total count for a grade. Is there any simpl...
by sivasaras
Wed Sep 23, 2015 7:32 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: joinkeys in sort
Replies: 2
Views: 3035

joinkeys in sort

hi, I have 2 files OF SAME LRECL . 1st file LRECL=255,BLKSIZE=27795 aaa BA.BSV.jK KRITHIKA 2nd file LRECL=255,BLKSIZE=27795 krithika MBBS ABCDFG now i want the report in the single line with the comparison of 2 files like AAA BA.BSV.JK KRITHIKA MBBS ABCDFG please let me know how to do that?
by sivasaras
Wed Mar 28, 2012 7:26 pm
Forum: IMS DB
Topic: SPA SIZE ISSUE
Replies: 13
Views: 15453

this is the error code for the abend *************************************************************************** DFS555I TRAN tttttttt ABEND (SYSID sss); MSG IN PROCESS: xxxx (up to 78 bytes of data) time- stamp Explanation: An application program abend occurred during the processing of transaction ...
by sivasaras
Wed Mar 28, 2012 7:22 pm
Forum: IMS DB
Topic: SPA SIZE ISSUE
Replies: 13
Views: 15453

Hi,

I am getting IMs error in the online screen while pressing PF8.

when the account number exceeds 41 components it is showing the eror.

Thanks
Siva
by sivasaras
Mon Mar 12, 2012 9:47 pm
Forum: IMS DB
Topic: SPA SIZE ISSUE
Replies: 13
Views: 15453

Hi,

If the fields are more than 42 then it is showing Error in the screen.

only upto 42 fields it is accepting.

please guide me

Thanks
Siva
by sivasaras
Fri Mar 09, 2012 8:43 pm
Forum: IMS DB
Topic: SPA SIZE ISSUE
Replies: 13
Views: 15453

My problem is solved.

I have given Endif after the each press count and it is working fine.

Thanks
Siva
by sivasaras
Fri Mar 09, 2012 7:39 pm
Forum: IMS DB
Topic: SPA SIZE ISSUE
Replies: 13
Views: 15453

Hi,

Sorry for the late reply.

My problem is while pressing PF8 third time it is displaying the first 13 components again instead of displaying the last components.

Pleae guide me

Thanks
Siva
by sivasaras
Wed Mar 07, 2012 9:56 pm
Forum: IMS DB
Topic: SPA SIZE ISSUE
Replies: 13
Views: 15453

SPA SIZE ISSUE

Hi, Problem: In the online Screen for a Account Number it will display around 40 list of fields like FN,LN,MN,ADD,PH,MOB etc... If we give this Acc358768543 in the screen it will display like LN KUMAR MN SUNDAR FN SHYAM now the issue is while pressing PF8 key to view the next screen it is displaying...
by sivasaras
Wed Jan 04, 2012 3:03 pm
Forum: IMS DB
Topic: Need Information about the SPA size in IMS program
Replies: 8
Views: 10521

Hi,

Please guide me to solve this issue.

Thanks
Siva
by sivasaras
Fri Oct 21, 2011 8:15 pm
Forum: IMS DB
Topic: Need Information about the SPA size in IMS program
Replies: 8
Views: 10521

this is the error code for the abend even if i change as 40 or 50 the same kind of problem only i am facing it 033 residence instead of RD Residence *************************************************************************** DFS555I TRAN tttttttt ABEND (SYSID sss); MSG IN PROCESS: xxxx (up to 78 byt...
by sivasaras
Thu Oct 20, 2011 3:09 pm
Forum: IMS DB
Topic: Need Information about the SPA size in IMS program
Replies: 8
Views: 10521

Please find my answers for the below questions. How/why should 33 be shown as RD? I have changed the occurs clause to 50 times and the second spa-press-count > 50, Ans: IF SPA-PF8-PRESS-COUNT = 2 PERFORM 37500-MOVE-SPA-TO-IO-AREA VARYING SUB1 FROM 27 BY 1 UNTIL SUB1 >= REST-OF-LINES OR SUB1 > 50 MOV...
by sivasaras
Wed Oct 19, 2011 6:36 pm
Forum: IMS DB
Topic: Need Information about the SPA size in IMS program
Replies: 8
Views: 10521

i am getting error code 99999 while xpediting the program and this says it exceeds the buffer limit.
by sivasaras
Wed Oct 19, 2011 4:34 pm
Forum: IMS DB
Topic: Need Information about the SPA size in IMS program
Replies: 8
Views: 10521

i have inserted these code changes in the program WHEN MI-PFKEY = LIT-08 ADD 1 TO SPA-PF8-PRESS-COUNT IF SPA-PF8-PRESS-COUNT = 1 PERFORM 37500-MOVE-SPA-TO-IO-AREA VARYING SUB1 FROM 14 BY 1 UNTIL SUB1 >= REST-OF-LINES OR SUB1 > 26 END-IF IF SPA-PF8-PRESS-COUNT = 2 PERFORM 37500-MOVE-SPA-TO-IO-AREA VA...
by sivasaras
Tue Oct 18, 2011 9:57 pm
Forum: IMS DB
Topic: Need Information about the SPA size in IMS program
Replies: 8
Views: 10521

Need Information about the SPA size in IMS program

Hi, Problem: In the online Screen for a Account Number it will display around 40 list of fields like FN,LN,MN,ADD,PH,MOB etc... If we give this Acc358768543 in the screen it will display like LN KUMAR MN SUNDAR FN SHYAM now the issue is while pressing PF8 key to view the next screen it is getting ab...