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
 

 

output data in CSV Format

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
janmejay
Warnings : 1

New User


Joined: 22 Jun 2007
Posts: 81
Location: bangalore

PostPosted: Sat Oct 15, 2016 2:20 pm    Post subject: output data in CSV Format
Reply with quote

hello

my reqmt is dump the data in CSV format in output file.

I have declared my output file structure as

Code:
01 outrec
  10 emp-name   pic x(10)
  10 filler            pic x(1) value ','.
  10 emp-addrs   pic X(30).
  10 Filler            pic x(1) value ','.
  10 emp salay    pic s 9(5) comp-3
  10 filler            pic x(1)  value ','.
  10 emp-phone  pic 9(10)


my out put should like :
Code:
mainppss  ,ukusbangalore      ,50000,9861098610


after reading the input file , i am moving the values to corresponding outrec fields but when i am writing to output file the comma (,) is not displaying after end of fields. it showing blank.

it is coming as

Code:
mainppss   ukusbangalore       50000 9861098610

can let me know the reason
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Sat Oct 15, 2016 2:23 pm    Post subject: Reply to: output data in CSV Format
Reply with quote

same answer as
http://ibmmainframes.com/viewtopic.php?t=65480&highlight=
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1715
Location: UK

PostPosted: Sat Oct 15, 2016 4:04 pm    Post subject:
Reply with quote

Quote:
can let me know the reason

Because the code, which you have not shown, is wrong.
The snippet of code that you did show was not in code tags and you keep using the term 'file' instead of 'dataset'. If you realy mean 'file' then this is not a mainframe question and should not be posted on a mainframe forum.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1715
Location: UK

PostPosted: Sat Oct 15, 2016 4:06 pm    Post subject:
Reply with quote

Duplicate of post in DFSort. Locked.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Sat Oct 15, 2016 5:43 pm    Post subject:
Reply with quote

Is outrec defined as the 01 for an FD? If so, your VALUE clause on the variables is being ignored and you need to use WRITE ... FROM and define outrec in WORKING-STORAGE.

Since you posted nothing for us to help you, that guess is about as far as we can go.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7234

PostPosted: Sat Oct 15, 2016 6:57 pm    Post subject: Reply to: output data in CSV Format
Reply with quote

Or you cleverly INITIALIZE your "outrec". Or MOVE SPACE to outrec. Or some other thing we could attempt to guess, but could tell you exactly if you showed the relevant code.
Back to top
View user's profile Send private message
janmejay
Warnings : 1

New User


Joined: 22 Jun 2007
Posts: 81
Location: bangalore

PostPosted: Sat Oct 15, 2016 8:08 pm    Post subject: Reply to: output data in CSV Format
Reply with quote

Robert is right. I defined my outrec under FD section

FD OUTPUT_FILE
01 OUTREC.
10 EMPNAME PIC X(10).
10 FILLER PIC X(1) VALUE ','.
.................................
..................................


I hope due to this Value Clause get ignored and need to define the outrec
in working storage section.

I will try this and let know.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7234

PostPosted: Sat Oct 15, 2016 11:24 pm    Post subject: Reply to: output data in CSV Format
Reply with quote

Do you ever look at the diagnostic messages at the end of your compile listing?
Back to top
View user's profile Send private message
janmejay
Warnings : 1

New User


Joined: 22 Jun 2007
Posts: 81
Location: bangalore

PostPosted: Sun Oct 16, 2016 8:58 pm    Post subject: Re: Reply to: output data in CSV Format
Reply with quote

janmejay wrote:
Robert is right. I defined my outrec under FD section

FD OUTPUT_FILE
01 OUTREC.
10 EMPNAME PIC X(10).
10 FILLER PIC X(1) VALUE ','.
.................................
..................................


I hope due to this Value Clause get ignored and need to define the outrec
in working storage section.

I will try this and let know.


it is working now. thank you Robert
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 -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
This topic is locked: you cannot edit posts or make replies. How to move a long alphanumeric data ... lind sh COBOL Programming 8 Mon Dec 05, 2016 7:51 pm
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm
No new posts ODPP(Optim Data privacy Provider) Iss... Rama kishore IBM Tools 1 Mon Nov 07, 2016 5:46 pm
No new posts Match or compare two files in VB Format anatol DFSORT/ICETOOL 14 Thu Nov 03, 2016 7:41 pm


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