 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 26 matches |
| Author | Message |
|---|---|
 Topic: STORAGE FOR NUMBER OF ENTRIES EXCEEDS 16M LIMIT |
|
| Pknair Replies: 2 Views: 2774 |
 Forum: TSO and ISPF Posted: Tue Feb 26, 2008 8:59 pm Subject: STORAGE FOR NUMBER OF ENTRIES EXCEEDS 16M LIMIT |
| Getting this error when doing a LISTCAT command with a '*' as one of the HLQ. The browse shows 800 datasets. Is there any way to surpass this message. | |
| Topic: LINE_BEFORE command for the BOTTOM OF DATA line |
|
| Pknair Replies: 6 Views: 3517 |
Forum: TSO and ISPF Posted: Thu Dec 20, 2007 12:52 am Subject: LINE_BEFORE command for the BOTTOM OF DATA line |
| Need some help with an EDIT MACRO
The requirement is that I need to write multiple lines before the "BOTTOM OF DATA" line using an EDIT MACRO. I got it working with the LINE_AFTER command ... |
|
| Topic: REXX for MULTI ROW FETCH |
|
| Pknair Replies: 17 Views: 13945 |
Forum: TSO and ISPF Posted: Fri Oct 26, 2007 3:31 pm Subject: REXX for MULTI ROW FETCH |
| I tried by including the ROWSET statement in the DECLARE CURSOR, but it gave me a -104 at the DECLARE statement itself.
I then used C51 but it keeps giving the -104 error on the FETCH statement ... |
|
| Topic: REXX for MULTI ROW FETCH |
|
| Pknair Replies: 17 Views: 13945 |
Forum: TSO and ISPF Posted: Thu Oct 25, 2007 2:28 pm Subject: REXX for MULTI ROW FETCH |
| The cobol program works fine too.
Does anyone know the different statements that can be passed in the ATTRIBUTES |
|
| Topic: REXX for MULTI ROW FETCH |
|
| Pknair Replies: 17 Views: 13945 |
Forum: TSO and ISPF Posted: Thu Oct 25, 2007 2:18 pm Subject: REXX for MULTI ROW FETCH |
| I'm not sure about the DSNREXX version, However As for JSHARON's question I did try with the singleton select and it does work fine | |
| Topic: REXX for MULTI ROW FETCH |
|
| Pknair Replies: 17 Views: 13945 |
Forum: TSO and ISPF Posted: Thu Oct 25, 2007 1:49 pm Subject: REXX for MULTI ROW FETCH |
| I'm sorry if I have in any of my previous replies , unintentionally offended you. Infact I do appreciate all the help being extended by everyone.
The version of DB2 is 8 The error is as given be ... |
|
| Topic: REXX for MULTI ROW FETCH |
|
| Pknair Replies: 17 Views: 13945 |
Forum: TSO and ISPF Posted: Thu Oct 25, 2007 10:30 am Subject: REXX for MULTI ROW FETCH |
| I tried using the "INTO" keyword but the result is still the same. I'm getting SQLCODE of -104 when trying to execute the FETCH. All the other SQLs gave me an SQLCODE of "0". | |
| Topic: REXX for MULTI ROW FETCH |
|
| Pknair Replies: 17 Views: 13945 |
Forum: TSO and ISPF Posted: Mon Oct 22, 2007 9:06 am Subject: REXX for MULTI ROW FETCH |
| Hi JSharon
That was a typo. the SQLSTMT statement did not have a singl quote. Hi Nic The Fetch that you are executing retireves one row at a time. Whereas the one that I am trying to exec ... |
|
| Topic: REXX for MULTI ROW FETCH |
|
| Pknair Replies: 17 Views: 13945 |
Forum: TSO and ISPF Posted: Fri Oct 19, 2007 9:21 am Subject: REXX for MULTI ROW FETCH |
| Anyone has an idea of how to do a mutli row fetch using REXX. I'm able to declare a cursor. But the fetch statement always gives me a -104.
SQLSTMT='SELECT CREATOR , NAME FROM SYSIBM.SYSTABLES WHER ... |
|
| Topic: 1st Stored Procedure - Can't seem to get it work correctly |
|
| Pknair Replies: 25 Views: 18058 |
Forum: Database Posted: Thu Oct 12, 2006 11:13 pm Subject: 1st Stored Procedure - Can't seem to get it work correctly |
| Came in late SQLCODE 80N is not -804 but -805 | |
| Topic: DATA SET XXX IN USE ?? |
|
| Pknair Replies: 12 Views: 6854 |
Forum: TSO and ISPF Posted: Thu Oct 12, 2006 3:12 pm Subject: DATA SET XXX IN USE ?? |
| Did you try TSO WHOHAS 'DSNNAME'. Most shop's have that.
Thanks Pknair |
|
| Topic: Is there any way to trap the Down key though ISPF |
|
| Pknair Replies: 1 Views: 1577 |
Forum: TSO and ISPF Posted: Wed Oct 04, 2006 10:27 am Subject: Is there any way to trap the Down key though ISPF |
| Just like how you can trap the Function keys using .PFKEY is there any way to trap the Down, Up, PGDN and PGUP keys . Just out of curiosity.
Thanks in advance Pknair |
|
| Topic: BPXWUNIX call from Cobol |
|
| Pknair Replies: 2 Views: 3010 |
Forum: Application Programming Posted: Thu Jul 27, 2006 12:51 pm Subject: BPXWUNIX call from Cobol |
| You are right Kolusu it was as simple as that but unfortunately our DB2 admins does not want to do that and I am not aware of any reason which is why I came up with this idea. Do you have any other wa ... | |
| Topic: BPXWUNIX call from Cobol |
|
| Pknair Replies: 2 Views: 3010 |
Forum: Application Programming Posted: Thu Jul 27, 2006 11:36 am Subject: BPXWUNIX call from Cobol |
| I have a requirement to do a BPXWUNIX call from a cobol stored procedure. I have coded it in REXX and it works perfectly fine. Since our WLM job does not contain a SYSEXEC DD I am unable to call the r ... | |
| Topic: Is there any alternative to OUTTRAP to trap messages |
|
| Pknair Replies: 2 Views: 2079 |
Forum: TSO and ISPF Posted: Thu Jul 06, 2006 6:00 pm Subject: Is there any alternative to OUTTRAP to trap messages |
| I am using an LDAPSRCH command from a REXX utility. However the OUTTRAP is unable to trap the messages and the message gets displayed on the screen. Can someone suggest another way to do the same. | |
All times are GMT - 5 Hours |