Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Can SFF(signed free form) incl. decimals & packed decim

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
grlewycky

New User


Joined: 02 Mar 2006
Posts: 7
Location: New York City

PostPosted: Thu Mar 02, 2006 10:32 pm    Post subject: Can SFF(signed free form) incl. decimals & packed decim
Reply with quote

Hi list,

I need to extract and ftp from our mainframe to our Oracle server (on Windows) and along with the sign bit (for negative in particular)
BUT - I also need the decimal point !!!!!!

Can DFSORT do both?:

I found SFF and it does the sign bit perfectly (yet I would like the
positive sign omitted if it can be)

Does it work with Packed Decimal fields also ??


I'm still surfing around for more info after I found this SFF by accident today !!!!


Thanks alot

George Lewycky
NY City Transit
NYC
Back to top
View user's profile Send private message

Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Fri Mar 03, 2006 12:39 am    Post subject:
Reply with quote

Sorry, but I don't understand what you're asking. Please show examples of your input fields with the relevant values and what you want the output records to look like.
Back to top
View user's profile Send private message
grlewycky

New User


Joined: 02 Mar 2006
Posts: 7
Location: New York City

PostPosted: Fri Mar 03, 2006 3:16 am    Post subject:
Reply with quote

Sorry about the confusion Frank,

Let me point to an earlier post of yours which illustrated what I would like to do with DFSORT:

http://www.ibmmainframes.com/viewtopic.php?t=1148

I'm trying to port EBCDIC data in PACKED DECIMAL containing dollar amounts (positive & negative) to be FTP'd to our Oracle server for processing into ASCII.

Basically all I need is to insert a decimal, and be able to determine if the value is negative!!!

SFF seems to be best method for this other than writing a program for a simple extract. But I'm trying to find some answers.

1. can it output decimals ?
2. can I only output negative signs ?

George
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Fri Mar 03, 2006 4:06 am    Post subject:
Reply with quote

SFF is an input format. So is PD. DFSORT can convert a value in any input format to many different types of output formats including lots of different output formats with decimal points and blank for a positive sign, so the answer to both your questions is yes. See the following for more information:

http://www.ibm.com/servers/storage/support/software/sort/mvs/beyond_sorting/online/srtmboft.html#oed

http://www.ibm.com/servers/storage/support/software/sort/mvs/beyond_sorting/online/srtmboft.html#ocv

I think the first one (editing) is more relevant to what you want to do.

If you need more specific help with the exact editing masks to use or anything else you want to do with the data, show me an example of your input fields and what exactly you want the output to look like.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Free FILE not working for specific users sankalp-goyal CLIST & REXX 12 Mon Apr 25, 2016 6:33 pm
No new posts conversion from char to packed decimal Musab Ahmed DFSORT/ICETOOL 7 Fri Apr 08, 2016 1:12 pm
No new posts NDM Packed Data file from Mainframes ... santhosh5983 IBM Tools 2 Wed Mar 30, 2016 2:36 am
No new posts SIGNED DECIMAL TO COMP-3 using cobol ... ram_vizag COBOL Programming 1 Tue Mar 01, 2016 11:32 pm
No new posts CALL MACRO EXECUTE FORM - Setting the... sudarshan.srivathsav PL/I & Assembler 7 Tue Feb 09, 2016 10:32 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us