IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Creating comma delimited file using file manager


IBM Mainframe Forums -> IBM Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
satish.ms10

Active User


Joined: 10 Aug 2009
Posts: 184
Location: India

PostPosted: Tue Sep 29, 2009 9:49 am
Reply with quote

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
View user's profile Send private message
satish.ms10

Active User


Joined: 10 Aug 2009
Posts: 184
Location: India

PostPosted: Thu Oct 01, 2009 11:42 am
Reply with quote

Any suggestions...please!
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Thu Oct 01, 2009 2:59 pm
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Thu Oct 01, 2009 4:56 pm
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Oct 01, 2009 8:50 pm
Reply with quote

Hello,

Why is File Manager a requirement?
Back to top
View user's profile Send private message
satish.ms10

Active User


Joined: 10 Aug 2009
Posts: 184
Location: India

PostPosted: Mon Oct 05, 2009 10:17 am
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Mon Oct 05, 2009 7:25 pm
Reply with quote

Hello,

How do you compile/run programs?
Back to top
View user's profile Send private message
satish.ms10

Active User


Joined: 10 Aug 2009
Posts: 184
Location: India

PostPosted: Tue Oct 06, 2009 9:22 am
Reply with quote

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
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Tue Oct 06, 2009 10:27 am
Reply with quote

Please refrain from posting the same question as 2 different threads in 2 different forums.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Oct 06, 2009 7:32 pm
Reply with quote

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
View user's profile Send private message
satish.ms10

Active User


Joined: 10 Aug 2009
Posts: 184
Location: India

PostPosted: Wed Oct 07, 2009 9:18 am
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Wed Oct 07, 2009 9:51 am
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Oct 07, 2009 7:32 pm
Reply with quote

Good to hear it is working - thanks for letting us know icon_smile.gif

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
View user's profile Send private message
satish.ms10

Active User


Joined: 10 Aug 2009
Posts: 184
Location: India

PostPosted: Thu Oct 08, 2009 9:38 am
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Oct 08, 2009 7:39 pm
Reply with quote

Thank you for posting your solution icon_smile.gif

d
Back to top
View user's profile Send private message
bhavin.mehta

New User


Joined: 25 Jun 2012
Posts: 34
Location: India

PostPosted: Thu Jun 27, 2013 12:46 pm
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Jun 27, 2013 8:04 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IBM Tools

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
Search our Forums:

Back to Top