Author |
Message |
Topic: get File from Unix to mainframe |
vak255
Replies: 3
Views: 2183
|
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: 2183
|
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: 2183
|
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: 4018
|
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: 4018
|
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: 4018
|
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: 3206
|
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: 3206
|
Forum: Application Programming Posted: Mon Jun 06, 2016 10:45 am Subject: % edit data |
thanks Terry. |
Topic: % edit data |
vak255
Replies: 4
Views: 3206
|
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: 3968
|
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: 3968
|
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: 3968
|
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: 3361
|
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 ![Smile](images/smiles/icon_smile.gif) |
Topic: Fetch value on different combination |
vak255
Replies: 5
Views: 3361
|
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: 3361
|
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 ... |
|