 |
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 126 matches |
| Author | Message |
|---|---|
 Topic: ICE085A 0 SECOND COMMUNICATION AREA SPACE EXCEEDED - DFSORT |
|
| chandra Replies: 2 Views: 1689 |
 Forum: Utilities Posted: Thu Feb 24, 2022 6:05 pm Subject: ICE085A 0 SECOND COMMUNICATION AREA SPACE EXCEEDED - DFSORT |
| Thank you Kolusu.
I used verify in ICETOOL to find the invalid fields and removed the fields to create my comma separated file. |
|
| Topic: ICE085A 0 SECOND COMMUNICATION AREA SPACE EXCEEDED - DFSORT |
|
| chandra Replies: 2 Views: 1689 |
Forum: Utilities Posted: Wed Feb 23, 2022 9:21 pm Subject: ICE085A 0 SECOND COMMUNICATION AREA SPACE EXCEEDED - DFSORT |
| Hi,
I'm using DFSORT to copy a file with OUTREC as fallows(creating comma separated fields), my input dataset is FB and LRECL=32000. My OUTREC is 7000 bytes //STEP02 EXEC PGM=SORT,PARM='SIZE&# ... |
|
| Topic: QW for MVS/QuickRef is not working in my shop |
|
| chandra Replies: 2 Views: 2311 |
Forum: TSO and ISPF Posted: Wed Sep 09, 2020 5:31 pm Subject: QW for MVS/QuickRef is not working in my shop |
| Hi,
I'm not able to access MVS/QuickRef with command QW. When I issue QW command I'm getting fallowing error. Data set not cataloged 'SYS2.QUICKREF.QWIPNL' was not found in catalog. I thoug ... |
|
| Topic: Sum the amount based on credit/debit indicator |
|
| chandra Replies: 3 Views: 2561 |
Forum: Utilities Posted: Fri Nov 21, 2014 11:02 am Subject: Sum the amount based on credit/debit indicator |
| Thank You Kolusu.
William - I will remove the DCB statement from my SORTOUT statement. The records are not in sorting order in my example I am showing in sorting order for simplicity. |
|
| Topic: Sum the amount based on credit/debit indicator |
|
| chandra Replies: 3 Views: 2561 |
Forum: Utilities Posted: Thu Nov 20, 2014 5:11 pm Subject: Sum the amount based on credit/debit indicator |
| Hi All,
My input file is VB, LRECL=227 In the following sort step I am able to do the following things. I want to add the amount in the column 76 if the account number is 235120 or 235010 and ... |
|
| Topic: Greater than and Less than on Char Column |
|
| chandra Replies: 6 Views: 4537 |
Forum: Database Posted: Tue Apr 29, 2014 4:05 pm Subject: Greater than and Less than on Char Column |
| Hi Kolusu,
The BEG_CODE and END_CODE are Char(12) columns and they can have any alpha numeric values in them including decimal values. I have mentioned in my original post in the descript ... |
|
| Topic: Greater than and Less than on Char Column |
|
| chandra Replies: 6 Views: 4537 |
Forum: Database Posted: Tue Apr 29, 2014 9:52 am Subject: Greater than and Less than on Char Column |
| Hi Kolusu,
It is not working as expected. When I gave the value '00000000055.8' I was expected to see the Beg_code = F20 and END_code = F99 but I got no rows. I try to change your query as f ... |
|
| Topic: Greater than and Less than on Char Column |
|
| chandra Replies: 6 Views: 4537 |
Forum: Database Posted: Tue Apr 29, 2014 9:15 am Subject: Greater than and Less than on Char Column |
| Thanks for your reply !!
NASCAR9 - I want the rows whose value is in between BEG_CODE and END_CODE Kolusu - I will check your solution and let you know how it is working. |
|
| Topic: Greater than and Less than on Char Column |
|
| chandra Replies: 6 Views: 4537 |
Forum: Database Posted: Mon Apr 28, 2014 2:06 pm Subject: Greater than and Less than on Char Column |
| Hi All,
I have a query in COBOL program as follows. SELECT BEG_CODE ,END_CODE FROM CE01T WHERE BEG_CODE <= :WS-CODE AND END_CODE >= :WS-CODE The BEG ... |
|
| Topic: VSAM File Prmiary Key Length Increase |
|
| chandra Replies: 9 Views: 6725 |
Forum: Application Programming Posted: Mon Nov 14, 2011 10:05 am Subject: VSAM File Prmiary Key Length Increase |
| Yes Misi01...That's true. We are analysing all the screens.
Thanks for pointing out... |
|
| Topic: VSAM File Prmiary Key Length Increase |
|
| chandra Replies: 9 Views: 6725 |
Forum: Application Programming Posted: Sat Nov 05, 2011 7:23 am Subject: VSAM File Prmiary Key Length Increase |
| Hi Dick and Jack,
We are having same situation. We are expanding the policy number from X(6) to X(10). I am doing an analysis of building a tool that can change all the COBOL copybooks that are ... |
|
| Topic: Advanced SQL Book |
|
| chandra Replies: 3 Views: 2614 |
Forum: Database Posted: Fri Oct 14, 2011 11:47 am Subject: Advanced SQL Book |
| Hi Dick and Kolusu,
Thank you very much !! |
|
| Topic: Advanced SQL Book |
|
| chandra Replies: 3 Views: 2614 |
Forum: Database Posted: Fri Oct 14, 2011 8:06 am Subject: Advanced SQL Book |
| Hi,
I want to learn advanced SQL statements. I know basics of simple SQL statements (select, update, delete, insert, group by, order by)but I want learn advanced technics. Can anyone suggest me bo ... |
|
| Topic: How can you check BIND to avoid a -805 on first run. |
|
| chandra Replies: 6 Views: 5355 |
Forum: Database Posted: Mon Jul 04, 2011 2:24 am Subject: How can you check BIND to avoid a -805 on first run. |
| Hi Kolusu,
I am trying to run the above REXX program but I am getting following error message. 52 +++ call db2init right(mvs,1) 25 +++ call catinfo Erro ... |
|
| Topic: Create report using SAS |
|
| chandra Replies: 9 Views: 5157 |
Forum: Application Programming Posted: Fri Jun 10, 2011 12:37 am Subject: Create report using SAS |
| Hi Papadi,
I assumed that the OP has mentioned State, City and date in the input data to understand the data not as a part of data. If you look at my original post I have removed Statem City an ... |
|
All times are GMT - 5 Hours |