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
 

 

Getting problem in xmitip

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
vicharapusrinu
Warnings : 1

New User


Joined: 04 Dec 2006
Posts: 63
Location: Hyderabad

PostPosted: Wed Feb 22, 2012 10:25 am    Post subject: Getting problem in xmitip
Reply with quote

Can some one help me please?

With the below JCL I am able to get email which is having report by name "REPORT.CSV.TXT".TXT (As an attachment )
But contents of the attached file is NOT CSV data,
It is plain data, but is suppose to be in CSV data, so that if I open in MS excel
It has to appear in correct format.

Code:
//TSOB EXEC PGM=IKJEFT1B                                             
//SYSEXEC  DD DSN=XXX.YYY.ZZZ,DISP=SHR                               
//SYSPRINT DD SYSOUT=*                                               
//SYSTSPRT DD SYSOUT=*                                               
//SYSTSIN DD *                                                       
%XMITIP AAA.BBB@CCC.COM                                             +
        NOMSG FILE 'AAA.BBB.CCC '                                   +
        FROM AAA.BBB@CCC.COM                                        +
        SUBJECT 'CSV TEST FILE' FORMAT TXT                          +
        FILENAME REPORT.CSV                                         
/*       


Where
//SYSEXEC DD DSN=XXX.YYY.ZZZ --> is CLIST library
Back to top
View user's profile Send private message

Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1712
Location: UK

PostPosted: Wed Feb 22, 2012 11:32 am    Post subject:
Reply with quote

OK - where are the runtime messages? Where is the (sample) input data? Where is anything useful to help those who will try and help you?
Back to top
View user's profile Send private message
Dsingh29

Active User


Joined: 16 Dec 2008
Posts: 132
Location: IBM

PostPosted: Wed Feb 22, 2012 11:34 am    Post subject: Reply to: Getting problem in xmitip
Reply with quote

give FORMAT CSV instead of TXT
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Wed Feb 22, 2012 1:35 pm    Post subject: Reply to: Getting problem in xmitip
Reply with quote

Quote:
give FORMAT CSV instead of TXT

might work in Your location ...
Quote:
Location: Dream Land

not anywhere else

did You care to read the XMITIP manual before posting...
the FORMAT CSV description
Quote:
FORMAT CSV
The input file must be in Comma Separated Value (CSV) format and will be attached as a text file attachment with a CSV suffix.

and the example
Quote:
Code:
//TSOB EXEC PGM=IKJEFT1B
//SYSEXEC DD DISP=SHR,DSN=rexx.exec
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
 %xmitip user.name@domain.com nomsg file 'hlq.weekly.csv' –
  from myname@domain.com -
  subject 'CSV Test File' format txt –
  filename report.csv

/*
In this example we are sending a data set called 'hlq.weekly.csv', which contains comma separated value data.
We are using the FILENAME keyword to explicitly name the file attachment as report.csv so that it will arrive with a .CSV suffix.


XMITIP will not do any transformation of the data, it will send it ASIS
it' s the user task to provide a properly <formatted> file

the FORMAT CSV would be used only to let XMITIP know what to do if it is told to do some additional processing,
but the file has to be already in CSV format.
Back to top
View user's profile Send private message
vicharapusrinu
Warnings : 1

New User


Joined: 04 Dec 2006
Posts: 63
Location: Hyderabad

PostPosted: Wed Feb 22, 2012 2:24 pm    Post subject: Reply to: Getting problem in xmitip
Reply with quote

Hi,

Although I have changed FORMAT CSV instead of TXT

Code:
//TSOB EXEC PGM=IKJEFT1B                                             
//SYSEXEC  DD DSN=XXX.YYY.ZZZ,DISP=SHR                               
//SYSPRINT DD SYSOUT=*                                               
//SYSTSPRT DD SYSOUT=*                                               
//SYSTSIN DD *                                                       
%XMITIP AAA.BBB@CCC.COM                                             +
        NOMSG FILE 'AAA.BBB.CCC '                                   +
        FROM AAA.BBB@CCC.COM                                        +
        SUBJECT 'CSV TEST FILE' FORMAT CSV                          +
        FILENAME REPORT.CSV                                         
/*


I have got email with an attachment with file name as "REPORT.CVS.CSV".CSV , and in attachment all (all 3 columns of MF data set) data has been places into first column of exel BUT I need to place 1st column of MF dataset as first column of excel and
2nd column of MF dataset as 2nd column of excel…. And so on..


The below is the output messages

Code:
The below is the output messages
XMITIP:   Subject:     CSV TEST FILE                                           
XMITIP:                                                                         
XMITIP:   Process Section                                                       
XMITIP:                                                                         
XMITIP:   > Warning: FILENAME REPORT.CVS and Format CSV are not the same.       
XMITIP:   > There may be a mismatch when opening on the recipients workstation.
XMITIP:   > To avoid a mismatch when opening on the recipients workstation, 
            an extension of '.CSV' will be added
XMITIP:                                                                         
XMITIP:   (001) File:                'AAA.BBB.CCC’                                            XMITIP:   (001) Attachment filename: REPORT.CVS.CSV                             
XMITIP:   -Input Records: 5 CSV                                                 
XMITIP:   as attachment name: REPORT.CVS.CSV                                   
0 message and 37 data records sent as 18 records to BCBSALB.SMTP               
Transmission occurred on 02/22/2012 at 03:03:47.                               
USER LOG DOES NOT EXIST FOR USER(S) SMTP    AND THE BROADCAST DATA SET CANNOT BE
XMITIP:                                                                         
XMITIP:   Message maximum record size is: 104                                   
XMITIP:                                                                         
XMITIP:   Message successfully transmitted                                     
XMITIP:   Sent 34 records as text, attachments, and control information.       
XMITIP:   Approximate byte count is: 700                                       

IF I change below line FORMAT CSV to FORMAT TXT

Code:
SUBJECT 'CSV TEST FILE' FORMAT TXT


I have got email with an attachment with file name as "REPORT.CVS.TXT".TXT , and in attachment all 3 columns of MF data set is placed into notepad
BUT I need to placed 1st column of MF dataset as first column of excel and
2nd column of MF dataset as 2nd column of excel…. And so on..


The below is the output messages


Code:
XMITIP:   Process Section                                                       
XMITIP:                                                                         
XMITIP:   > Warning: FILENAME REPORT.CVS and Format TXT are not the same.     
XMITIP:   > There may be a mismatch when opening on the recipients workstation.
XMITIP:   > To avoid a mismatch when opening on the recipients workstation,
            an extension of '.TXT' will be added
XMITIP:                                                                       
XMITIP:   (001) File:                'AAA.BBB.CCC’                                            '                   
XMITIP:   (001) Attachment filename: REPORT.CVS.TXT                           
XMITIP:   -Input Records: 5 TXT                                               
XMITIP:   as attachment name: REPORT.CVS.TXT                                   
0 message and 37 data records sent as 18 records to BCBSALB.SMTP               
Transmission occurred on 02/22/2012 at 03:18:25.                               
USER LOG DOES NOT EXIST FOR USER(S) SMTP    AND THE BROADCAST DATA SET CANNOT B
XMITIP:                                                                       
XMITIP:   Message maximum record size is: 104                                 
XMITIP:                                                                       
XMITIP:   Message successfully transmitted                                     
XMITIP:   Sent 34 records as text, attachments, and control information.       
XMITIP:   Approximate byte count is: 690                                       
READY                                                                         
END                                                                           
***************************
Back to top
View user's profile Send private message
vicharapusrinu
Warnings : 1

New User


Joined: 04 Dec 2006
Posts: 63
Location: Hyderabad

PostPosted: Wed Feb 22, 2012 2:28 pm    Post subject: Reply to: Getting problem in xmitip
Reply with quote

And also please let me know how I can change/open excel from .CSV file?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Feb 22, 2012 2:33 pm    Post subject:
Reply with quote

What have YOU tried in respect of this CSV / XLS problem., which is hardly mainframe is it

Have you used google. Have you asked your peers, have you bothered to accomplish the most basic research for yourself.

Somehow I doubt it icon_evil.gif
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Wed Feb 22, 2012 2:41 pm    Post subject: Reply to: Getting problem in xmitip
Reply with quote

did You care to read my previous reply
and to read the xmitip manual ?
is the file You want to send in csv format ?
xmitip will not take a plain file an transform it into csv format
Back to top
View user's profile Send private message
elango_K

New User


Joined: 18 Aug 2011
Posts: 44
Location: India

PostPosted: Wed Feb 22, 2012 3:17 pm    Post subject:
Reply with quote

Hi,

Can you please post the link to the manual?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Wed Feb 22, 2012 3:19 pm    Post subject: Reply to: Getting problem in xmitip
Reply with quote

is it that google does not work for You ? icon_cool.gif
the first hit returned when googling for xmitip manual was the manual link
Back to top
View user's profile Send private message
vicharapusrinu
Warnings : 1

New User


Joined: 04 Dec 2006
Posts: 63
Location: Hyderabad

PostPosted: Wed Feb 22, 2012 5:35 pm    Post subject: Reply to: Getting problem in xmitip
Reply with quote

Hi Enrico/ Expat

Thanks for your suggestion,
I am able send email with attachment as CSV file and, I am able to view in correct format.

BUT I don’t have JCL to convert normal MF data set to CSV MF data set.
Could some one provide that JCL?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed Feb 22, 2012 6:01 pm    Post subject:
Reply with quote

vicharapusrinu,

at first i was going to reply with one of my normal, festive responses,
but it is obvious
that you have no idea of what is going on in the world of computers,
and thus it would have been like kicking a dog on the ground.

so,

a CSV is a Comma Separated Value formatted file.

as such, you have two alternatives:
  • modify the file generator (program) to output the file in CSV format
  • use a sort utility to 'convert' the file


depending on the product (DFSORT, SYNCSORT, CA-SORT) at your site,
you can either look (search)
  • the JCL forum for SYNCSORT solutions
  • the DFSORT forum for DFSORT solutions (i know that there exists a few threads)
  • pray that a SYNCSORT or DFSORT solution (control cards) will work with CA-SORT or whatever,
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1712
Location: UK

PostPosted: Wed Feb 22, 2012 8:11 pm    Post subject:
Reply with quote

Here is your JCL
Code:

// your jobcard
//STEP1 EXEC PGM=your sort program
//SYSOUT  DD SYSOUT=your sysout class requirements
//SORTIN  DD DISP=SHR,DSN=your input dataset (the one that needs to be converted to CSV format)
//SORTOUT DD DISP=(,CATLG,CATLG),SPACE=(required space),DSN=the datasetname of the file after conversion to CSV format
//SYSIN   DD *
control cards to do the conversion
/*
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 -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm
No new posts DB2 Streaming Batch Processing Problem Manshadi DB2 4 Sat Sep 24, 2016 12:14 pm
No new posts Problem with GETMAIN command amitc23 CICS 6 Thu Sep 01, 2016 1:01 pm
No new posts TXT2PDF problem - printing @ in PDF vipul65 All Other Mainframe Topics 9 Thu Aug 25, 2016 12:48 am


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