View previous topic :: View next topic
|
Author |
Message |
satish.ms10
Active User
Joined: 10 Aug 2009 Posts: 184 Location: India
|
|
|
|
Hi,
I have a ps file and it's layout (copybook), using this information I want to create comma delimited file for the give ps file using FILE MANAGER utility.
please suggest me how can I create a comma delimited file using FILE MANAGER.
Thanks in advance. |
|
Back to top |
|
|
satish.ms10
Active User
Joined: 10 Aug 2009 Posts: 184 Location: India
|
|
|
|
Any suggestions...please! |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Quote: |
I want to create comma delimited file for the give ps file using FILE MANAGER utility. |
By saying this, you yourself have limited the responses. Unless I've FILE MANAGER installed at my shop -- I can't answer. And I, for one, is from such a shop where FILE MANAGER is not installed.
There can be alternate ways of doing what you want, if you make your choice a bit flexible. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
We don't use FIle Manager here, so none of our comma delimited files are created with it -- but we have a lot of comma delimited files. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Why is File Manager a requirement? |
|
Back to top |
|
|
satish.ms10
Active User
Joined: 10 Aug 2009 Posts: 184 Location: India
|
|
|
|
Hi All,
Reason to use File Manager only is, I do not have any job submission facility for me in my shop.
I have access to File Managaer tool only. Using this tool I need to create a comma delimited file for the given file.
My previous post ("Sort to convert to signed numerics")is related to this task only. I have done this conversion using File Manager tool. Now I need to create comma delimited file for this file.
Please let me know if this can be done using File Manager. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
How do you compile/run programs? |
|
Back to top |
|
|
satish.ms10
Active User
Joined: 10 Aug 2009 Posts: 184 Location: India
|
|
|
|
Hi Dick,
We are not coding any programs to compile/run. We are analyzing existing project and inflow and outflow data.
To analyze the outflow data, we need to convert PD values to signed numerics and needs to create some delimited (Ex: Comma) file and download the delimited file to excel file. |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
Please refrain from posting the same question as 2 different threads in 2 different forums. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
we need to convert PD values to signed numerics and needs to create some delimited (Ex: Comma) file and download the delimited file to excel file. |
Suggest you convert the PD using File Manager and then download the file as is.
Excel supports importing fixed length data without delimiters.
IMHO, part of analyzing the existing processes could include submitting jobs to "look at things". Possibly, your management would also see the value of this? |
|
Back to top |
|
|
satish.ms10
Active User
Joined: 10 Aug 2009 Posts: 184 Location: India
|
|
|
|
Hi Dick,
I have done converting the PD values using File Manager successfully.
I will check with my manager regarding other points.
Thank you very much. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Great, glad to hear. I know it's going to be site specific if I ask how you did it? But may be worthwhile if you post the solution for the benefit of others... |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Good to hear it is working - thanks for letting us know
As far as the ability to submit jobs - fwiw - the same security rules that are in effect when you use tso/filemanager would be in place if you run a batch job.
Good luck,
d |
|
Back to top |
|
|
satish.ms10
Active User
Joined: 10 Aug 2009 Posts: 184 Location: India
|
|
|
|
Hi Dick/Anuj,
Thank you.
It is my responsibility to provide the solution here.
My another post ("Sort to convert to signed numerics") is having Input layout. Anyhow I am giving input layout again here.
Input Layout:
Code: |
01 REC.
05 FIELD01 PIC S9(05)V99 COMP-3.
05 FIELD02 PIC S9(07)V99 COMP-3.
05 FIELD03 PIC S9(07)V99 COMP-3.
05 FIELD04 PIC S9(07)V99 COMP-3.
05 FIELD05 PIC S9(07)V99 COMP-3.
05 FIELD06 PIC S9(07)V99 COMP-3.
05 FIELD07 PIC S9(07)V99 COMP-3.
05 FIELD08 PIC S9(07)V99 COMP-3.
05 FIELD09 PIC S9(07)V99 COMP-3.
05 FIELD10 PIC S9(07)V99 COMP-3.
05 FIELD11 PIC S9(07)V99 COMP-3.
05 FIELD12 PIC S9(07)V99 COMP-3.
05 FIELD13 PIC S9(07)V99 COMP-3. |
I have created output layout and is mentioned below.
Output Layout:
Code: |
01 REC01.
05 FIELD01 PIC -9(06).99.
05 FIELD02 PIC -9(08).99.
05 FIELD03 PIC -9(08).99.
05 FIELD04 PIC -9(08).99.
05 FIELD05 PIC -9(08).99.
05 FIELD06 PIC -9(08).99.
05 FIELD07 PIC -9(08).99.
05 FIELD08 PIC -9(08).99.
05 FIELD09 PIC -9(08).99.
05 FIELD10 PIC -9(08).99.
05 FIELD11 PIC -9(08).99.
05 FIELD12 PIC -9(08).99.
05 FIELD13 PIC -9(08).99. |
I used File Manager COPY option (3.3) with Inut copybook for source dataset and I mentioned destination/new dataset with Output copybook.
And I got desired output as expected.
Once again thanks for your help. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Thank you for posting your solution
d |
|
Back to top |
|
|
bhavin.mehta
New User
Joined: 25 Jun 2012 Posts: 34 Location: India
|
|
|
|
I also have the same requirement for a comma delimited file
@dick scherrer, as you said,
Quote: |
Excel supports importing fixed length data without delimiters.
|
but my file has a more than 1000 fields and it will be difficult for me to accuratebly map each and every field. Its involves a lot of manual work which I want to avoid.
And as Robert said that they have a lot of comma delimited files, can you pass on those methods? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
When i create data-delimited files i mostly use the STRING statement in COBOL. . .
The Tab character (x'05') usually works better for us than commas because it is rather common to have a comma in the actual data. |
|
Back to top |
|
|
|