 |
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 343 matches |
| Author | Message |
|---|---|
 Topic: get File from Unix to mainframe |
|
| vak255 Replies: 3 Views: 2459 |
 Forum: Utilities Posted: Wed Nov 09, 2016 2:27 pm Subject: get File from Unix to mainframe |
| Thanks Kolusu. I will check on it. | |
| Topic: get File from Unix to mainframe |
|
| vak255 Replies: 3 Views: 2459 |
Forum: Utilities Posted: Wed Nov 09, 2016 11:34 am Subject: get File from Unix to mainframe |
| when I download the file froom unix to windows and when I open in notepad, it looks good.
some conversion is applied when I FTP this to mainframe, I am using the FTP UI in the Extra session to upl ... |
|
| Topic: get File from Unix to mainframe |
|
| vak255 Replies: 3 Views: 2459 |
Forum: Utilities Posted: Wed Nov 09, 2016 11:32 am Subject: get File from Unix to mainframe |
| I have a file which has data as below in Unix box.
File.txt 136528520918 when I downloaded this to windows and FTP to mainframe. Its changing to the below format. its adding a low value '.' a ... |
|
| Topic: +-$ in the same field without spaces |
|
| vak255 Replies: 7 Views: 4520 |
Forum: Application Programming Posted: Mon Jun 27, 2016 1:15 pm Subject: +-$ in the same field without spaces |
| Thanks, will use the below.
$$$$9.9(2)- |
|
| Topic: +-$ in the same field without spaces |
|
| vak255 Replies: 7 Views: 4520 |
Forum: Application Programming Posted: Mon Jun 27, 2016 11:20 am Subject: +-$ in the same field without spaces |
| I think I will use +$999.9(2), if I could not compress leading zeros. | |
| Topic: +-$ in the same field without spaces |
|
| vak255 Replies: 7 Views: 4520 |
Forum: Application Programming Posted: Mon Jun 27, 2016 11:16 am Subject: +-$ in the same field without spaces |
| I have a discount field which has sign and $.
This is defined as DISCOUNT PIC +$$$9.9(2) so this is display as below. DISCOUNT DETAILS -------- - $0.95 - $2.00 + $0.00 - $ ... |
|
| Topic: % edit data |
|
| vak255 Replies: 4 Views: 3623 |
Forum: Application Programming Posted: Mon Jun 06, 2016 11:02 am Subject: % edit data |
| Thanks William. I will define it separately, that will resolve my requirement. | |
| Topic: % edit data |
|
| vak255 Replies: 4 Views: 3623 |
Forum: Application Programming Posted: Mon Jun 06, 2016 10:45 am Subject: % edit data |
| thanks Terry. | |
| Topic: % edit data |
|
| vak255 Replies: 4 Views: 3623 |
Forum: Application Programming Posted: Mon Jun 06, 2016 9:59 am Subject: % edit data |
|
15 PRICE PIC 9(4).9(2). to include $ sign, I changed the above to $$$$9.9(2) similarly, is there a edit PIC available for %. 15 CO-PCT PIC 9(2). ... |
|
| Topic: SQL vs Cobol loop |
|
| vak255 Replies: 4 Views: 4418 |
Forum: Database Posted: Tue May 24, 2016 12:40 pm Subject: SQL vs Cobol loop |
| D7218.ACCT_NUM IN (:WS-zero-acct,:WS-ACCT) AND
D7218.STOCK_NUM In (:Ws-zero-stock,:WS-STOCK) AND How should I include the NULLs? ACCT - Numeric STOCK - AlphaNumeric. |
|
| Topic: SQL vs Cobol loop |
|
| vak255 Replies: 4 Views: 4418 |
Forum: Database Posted: Tue May 24, 2016 12:11 pm Subject: SQL vs Cobol loop |
| Thanks Kolusu, I agree.
I was trying to fetch only one record out of the SQL as I need to process this one record further and the priority is it should first check without zeros, if there is a hi ... |
|
| Topic: SQL vs Cobol loop |
|
| vak255 Replies: 4 Views: 4418 |
Forum: Database Posted: Tue May 24, 2016 10:43 am Subject: SQL vs Cobol loop |
|
SELECT D7218.COMM_RULE_ID , D7218.MANF_REP_NUM , D7218.ACCT_NUM , D7218.PROD_LINE_CD , ... |
|
| Topic: Fetch value on different combination |
|
| vak255 Replies: 5 Views: 3762 |
Forum: Utilities Posted: Thu May 12, 2016 2:12 pm Subject: Fetch value on different combination |
| Sorry, that was a typo.
Thanks for the solution. U always rock Kolusu  |
|
| Topic: Fetch value on different combination |
|
| vak255 Replies: 5 Views: 3762 |
Forum: Utilities Posted: Thu May 12, 2016 8:42 am Subject: Fetch value on different combination |
| rules with effective end date < current date are considered expired rules, so should not be considered in the processing.
Below rule should not be considered. Rule_Num MAN_NUM ... |
|
| Topic: Fetch value on different combination |
|
| vak255 Replies: 5 Views: 3762 |
Forum: Utilities Posted: Thu May 12, 2016 8:30 am Subject: Fetch value on different combination |
| pls find below the details.
Source file MAN_NUM 9(4) ACCT_NUM 9(5) LINE_CD 9(1) SKU x(11) -- above I gave only three digits for reference Lookup table: this will b ... |
|
All times are GMT - 5 Hours |