MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 343 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: get File from Unix to mainframe
vak255

Replies: 3
Views: 1934

PostForum: 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: 1934

PostForum: 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: 1934

PostForum: 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: 3681

PostForum: 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: 3681

PostForum: 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: 3681

PostForum: 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: 2908

PostForum: 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: 2908

PostForum: Application Programming   Posted: Mon Jun 06, 2016 10:45 am   Subject: % edit data
thanks Terry.
  Topic: % edit data
vak255

Replies: 4
Views: 2908

PostForum: 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: 3604

PostForum: 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: 3604

PostForum: 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: 3604

PostForum: 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: 3051

PostForum: 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
  Topic: Fetch value on different combination
vak255

Replies: 5
Views: 3051

PostForum: 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: 3051

PostForum: 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 ...
 
Page 1 of 23 Goto page 1, 2, 3 ... 21, 22, 23  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group