Using easytrieve to create smaller file to pass to excel...
I have a file and layout.
There are some fields defined as comp-3, but I think maybe they are binary?
How do I define them in my ezt code to get the data legible?
paste of the 3 fields (in hex):
---+----2---
---+----F---
---+----2---
-----------
...ÿ...ÿ...@
311D311D3107
F18FF18FF20C
From the cobol copybook:
15 EFFECTIVE-DATE PIC S9(07) COMP-3.
15 CHANGE-EFFECTIVE-DATE PIC S9(07) COMP-3.
15 EXPIRATION-DATE PIC S9(07) COMP-3.
If I look at them with FileAid, they are appear to be julian dates - like 2011189 - which would be fine if I could see them that way.
I'm getting effective dates like
1,058,085,087
or split out
63 17 24 33-
Any help appreciated.
easytrieve - is this binary field
Moderators: DikDude, Moderator Group
When posting data (or code or jcl etc) it is important to use the "Code" tags:
The 3 values posted are not packed-decimal from what i can see.
1,058,085,087 is indeed the decimal number given when 3F1118DF is converted to decimal (using the Windows calculator).
What has fileaid been told about the format of these fields?
Code: Select all
---+----2---
---+----F---
---+----2---
-----------
...ÿ...ÿ...@
311D311D3107
F18FF18FF20C
Code: Select all
15 EFFECTIVE-DATE PIC S9(07) COMP-3.
15 CHANGE-EFFECTIVE-DATE PIC S9(07) COMP-3.
15 EXPIRATION-DATE PIC S9(07) COMP-3.
1,058,085,087 is indeed the decimal number given when 3F1118DF is converted to decimal (using the Windows calculator).
What has fileaid been told about the format of these fields?
Have a good one
When I FTPd the file from a different mainframe to ours, apparantly the FTP decided to split just some of the records into 2. So...the date fields that I was getting a s0c7 on were acually some other field(s) - on that "2nd" record. At least I read up on binary and how it works!
so here's a big NEVER MIND.
Now I'm trying to figure out how to fix my FTP - There's got to be a glitch with VB records or something...
Thanks for your help!!!
Glad I found this site!
so here's a big NEVER MIND.
Now I'm trying to figure out how to fix my FTP - There's got to be a glitch with VB records or something...
Thanks for your help!!!
Glad I found this site!
You're welcome - there is usually someone around (or will be fairly soon) when there are questions.
Suggest you check with your ftp support and see how ftp is configured at each end. You might try building a very small variable file and dump the file before transmitting it and after the data is received on the target system.
When i transmit data to a mainframe, i pre-allocate the receiving file.
You also need to determine which mode of transmission is being used.
Good luck
Suggest you check with your ftp support and see how ftp is configured at each end. You might try building a very small variable file and dump the file before transmitting it and after the data is received on the target system.
When i transmit data to a mainframe, i pre-allocate the receiving file.
You also need to determine which mode of transmission is being used.
Good luck
Have a good one
- dbzTHEdinosauer
- Moderator
- Posts: 981
- Joined: Mon Oct 02, 2006 8:31 pm
It's a SAS FTP run on the mainframe.
Yeah, had tried pre-allocating, different variations of V, VB, F, lrecls, blksizes, binary...but what it needed was:
Didn't think it was going to work, but it did, and that's all that matters!
So glad I found this forum - Thank you!
Yeah, had tried pre-allocating, different variations of V, VB, F, lrecls, blksizes, binary...but what it needed was:
Code: Select all
S370V PROMPT RCMD='SITE RDW';
Didn't think it was going to work, but it did, and that's all that matters!
So glad I found this forum - Thank you!
FREE TUTORIALS
Tutorials
Free tutorials from mainframegurukul
- JCL Tutorial
Covers all important JCL concepts. - Cobol Tutorial
This tutorials covers all Cobol Topics from STRING to COMP-3. - DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming. - SORT Tutorial
This Tutorial covers all important aspects of DFSORT with examples - CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page