 |
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 17 matches |
| Author | Message |
|---|---|
 Topic: COBOL Bank application demo |
|
| SRI123 Replies: 2 Views: 2448 |
 Forum: Application Programming Posted: Mon Jan 03, 2022 2:10 am Subject: COBOL Bank application demo |
| Hi To understand real time application of COBOL/mainframe, can someone share Bank application or inventory application demo code? or MIT source code link ..? | |
| Topic: COBOL Host variable |
|
| SRI123 Replies: 3 Views: 3436 |
Forum: Application Programming Posted: Wed Sep 22, 2021 10:21 am Subject: COBOL Host variable |
| Thanks for reply Kolusu.
In input file field is declared as pic 9(16). I'm moving this to host variable POLNO PIC S9(16)V USAGE COMP-3 and selecting the statement select polno into :ws-pol-num ... |
|
| Topic: COBOL Host variable |
|
| SRI123 Replies: 3 Views: 3436 |
Forum: Application Programming Posted: Wed Sep 22, 2021 9:21 am Subject: COBOL Host variable |
| Hi
In a file a variable pol-num is declared as 9(16). In DB2 table column is polno declared as decimal(16,0). When I try to check pol-num in table with select statement I'm getting pol-num as unde ... |
|
| Topic: SORT logic for multirecord value checking |
|
| SRI123 Replies: 4 Views: 2387 |
Forum: Utilities Posted: Wed Oct 14, 2015 1:33 am Subject: SORT logic for multirecord value checking |
| Thank you Got desired result | |
| Topic: SORT logic for multirecord value checking |
|
| SRI123 Replies: 4 Views: 2387 |
Forum: Utilities Posted: Tue Oct 13, 2015 5:26 am Subject: SORT logic for multirecord value checking |
| Yes only TYPE-2 record can be possible, then only TYPE-2 rec need to be written.
Is it possible thru DFSORT? |
|
| Topic: SORT logic for multirecord value checking |
|
| SRI123 Replies: 4 Views: 2387 |
Forum: Utilities Posted: Tue Oct 13, 2015 3:40 am Subject: SORT logic for multirecord value checking |
| Hi
How to write logic checking for multiple records? I have input file in this format with these 3 fields - EMPNO EMPTYPE Description. Each EMPNO can have 3 types of datatypes - type-1,type-2,typ ... |
|
| Topic: DB2 unload , reformat and load |
|
| SRI123 Replies: 8 Views: 5173 |
Forum: Database Posted: Fri Aug 28, 2015 7:08 am Subject: DB2 unload , reformat and load |
| Ok thats good idea.thanks
Instead of reformatting while unloading, want to do it while loading. So how to keep the condition in load statement. And do I need to change the data format from FILE ... |
|
| Topic: DB2 unload , reformat and load |
|
| SRI123 Replies: 8 Views: 5173 |
Forum: Database Posted: Fri Aug 28, 2015 6:24 am Subject: DB2 unload , reformat and load |
| Since data needs to be reformatted; | |
| Topic: DB2 unload , reformat and load |
|
| SRI123 Replies: 8 Views: 5173 |
Forum: Database Posted: Fri Aug 28, 2015 4:42 am Subject: DB2 unload , reformat and load |
| Hi
Employee table contains - EMP-NO Integer, DOJ DATE, DATE-REL DATE, SAL DECIMAL(9,2) I want to unload the data from the above table and reformat the data and load the data to another table. W ... |
|
| Topic: How to add years to date in format CCYY-MM-DD using DFSORT? |
|
| SRI123 Replies: 8 Views: 4575 |
Forum: Utilities Posted: Fri Aug 28, 2015 2:44 am Subject: How to add years to date in format CCYY-MM-DD using DFSORT? |
| Thank you Kolusu... | |
| Topic: How to add years to date in format CCYY-MM-DD using DFSORT? |
|
| SRI123 Replies: 8 Views: 4575 |
Forum: Utilities Posted: Thu Aug 27, 2015 2:27 pm Subject: How to add years to date in format CCYY-MM-DD using DFSORT? |
| Hi Kolusu
Even thou input is 80bytes, only 1st 40 bytes has data . |
|
| Topic: How to add years to date in format CCYY-MM-DD using DFSORT? |
|
| SRI123 Replies: 8 Views: 4575 |
Forum: Utilities Posted: Thu Aug 27, 2015 12:49 pm Subject: How to add years to date in format CCYY-MM-DD using DFSORT? |
| Sorry Kolusu
1. What is the LRECL and RECFM of the input file ? - 80 bytes 2. What is the LRECL and RECFM of the desired output file? - 80 bytes 3. What is the position and format of the input ... |
|
| Topic: How to add years to date in format CCYY-MM-DD using DFSORT? |
|
| SRI123 Replies: 8 Views: 4575 |
Forum: Utilities Posted: Thu Aug 27, 2015 12:10 pm Subject: How to add years to date in format CCYY-MM-DD using DFSORT? |
| Hi Kolusu
Thanks for reply. If I have input record has some more field and I want to take that field to some other position in output file. So do I need to change INREC to OUTREC? 1233 2009-01- ... |
|
| Topic: How to add years to date in format CCYY-MM-DD using DFSORT? |
|
| SRI123 Replies: 8 Views: 4575 |
Forum: Utilities Posted: Thu Aug 27, 2015 8:01 am Subject: How to add years to date in format CCYY-MM-DD using DFSORT? |
| How to add years to date in format CCYY-MM-DD ?
input is like this: 1233 2009-01-01 1234 2010-01-28 3456 2015-03-31 output : if the date is less than 2010-01-01 then suffix the date ... |
|
| Topic: How to change CCSID value |
|
| SRI123 Replies: 6 Views: 7684 |
Forum: Database Posted: Tue Apr 29, 2014 8:37 pm Subject: How to change CCSID value |
| Thanks for reply.
I have admin rights( this is training environment). Since my precompilation has CCSID 500, what is the value need to enter for below 7, 8, 9 fields? 7 EBCDIC CCSID ... |
|
All times are GMT - 5 Hours |