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
 

 

Creating comma delimited file using file manager

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

Active User


Joined: 10 Aug 2009
Posts: 158
Location: India

PostPosted: Tue Sep 29, 2009 9:49 am    Post subject: Creating comma delimited file using file manager
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: 158
Location: India

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

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

Senior Member


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

PostPosted: Thu Oct 01, 2009 2:59 pm    Post subject:
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: 7914
Location: Bellevue, IA

PostPosted: Thu Oct 01, 2009 4:56 pm    Post subject:
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

Site Director


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

PostPosted: Thu Oct 01, 2009 8:50 pm    Post subject:
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: 158
Location: India

PostPosted: Mon Oct 05, 2009 10:17 am    Post subject:
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

Site Director


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

PostPosted: Mon Oct 05, 2009 7:25 pm    Post subject:
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: 158
Location: India

PostPosted: Tue Oct 06, 2009 9:22 am    Post subject:
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: 1238
Location: Richfield, MN, USA

PostPosted: Tue Oct 06, 2009 10:27 am    Post subject:
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

Site Director


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

PostPosted: Tue Oct 06, 2009 7:32 pm    Post subject:
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: 158
Location: India

PostPosted: Wed Oct 07, 2009 9:18 am    Post subject:
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

Senior Member


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

PostPosted: Wed Oct 07, 2009 9:51 am    Post subject:
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

Site Director


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

PostPosted: Wed Oct 07, 2009 7:32 pm    Post subject: Reply to: Creating comma delimited file using file manager
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: 158
Location: India

PostPosted: Thu Oct 08, 2009 9:38 am    Post subject:
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

Site Director


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

PostPosted: Thu Oct 08, 2009 7:39 pm    Post subject: Reply to: Creating comma delimited file using file manager
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: 32
Location: India

PostPosted: Thu Jun 27, 2013 12:46 pm    Post subject:
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

Site Director


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

PostPosted: Thu Jun 27, 2013 8:04 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> IBM Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm


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