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
 

 

vprint problem in file-aid

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
diwa_thilak

Active User


Joined: 13 Jul 2006
Posts: 205
Location: At my desk

PostPosted: Thu Feb 28, 2008 7:45 pm    Post subject: vprint problem in file-aid
Reply with quote

Friends,


I need to take backup of a VSAM file which contains more than 250 columns.

I am trying to use VPRINT command to take backup, but the data gets truncated to only certain cols. Data gets truncated.

I allocated the dataset with the LRECL(255) and then tried the VPRINT. Still the data doesnt gets backed up.

How can i take backup.

Any suggestions techies...
Back to top
View user's profile Send private message

diwa_thilak

Active User


Joined: 13 Jul 2006
Posts: 205
Location: At my desk

PostPosted: Thu Feb 28, 2008 8:46 pm    Post subject:
Reply with quote

techies,

I found the LRECL defined for File-aid to be of default 133, is there any way you can suggest me to take the backup
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10278
Location: italy

PostPosted: Thu Feb 28, 2008 8:54 pm    Post subject: Reply to: vprint problem in file-aid
Reply with quote

I know I am being picky, but..

the column concept is related only to relational dbms
I would rather speak about fields

and .... I am no fileaid expert but VPRINT looks more like a printing tool
rather than a backup tool

for such task there many other options better suited for it
for example
HSM hbackup command
IDCAMS repro
SORT copy
FILEAID ????
DFDSS/ADRDSSU

just choose one
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 Feb 28, 2008 10:18 pm    Post subject:
Reply with quote

Hello,

Who/what provided the direction to use VPRINT for a backup? What kind of backup do you expect from vprint?

If we better understand your requirement, we may be able to offer other suggestions.
Back to top
View user's profile Send private message
diwa_thilak

Active User


Joined: 13 Jul 2006
Posts: 205
Location: At my desk

PostPosted: Fri Feb 29, 2008 12:36 am    Post subject:
Reply with quote

Techies,

I need the data in the form of report. To be more specific, i need data of all the cols.

The problem is i am trying to take the data in report form using VPRINT option, the data is getting truncated.

If i sort and do an FTP the data in packed format is not coming out as expected.

How to proceed ?

Do i need to write one cobol/ezt to do the functionality.

(or)

Is there any EZT program to generate a report converting the packed attributes to numeric ones ?
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: Fri Feb 29, 2008 12:47 am    Post subject:
Reply with quote

Hello,

It sounds like you may simply need to read the existing file and create a new file that is easily readable by the eyes (rather than code). Why is such a file needed?

However;

Quote:
converting the packed attributes to numeric ones
Packed decimal is numeric. . . icon_confused.gif

When you say "more than 250 columns", do you mean lrecl=250+?

You could probably use cobol, ezt, your sort product, or some other utility to reformat the records and make the new file lrecl as long as it needs to be.

If you show some sample input data and the desired output from that input, we can probably offer better suggestions.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10278
Location: italy

PostPosted: Fri Feb 29, 2008 1:07 am    Post subject: Reply to: vprint problem in file-aid
Reply with quote

being picky again icon_cool.gif
just take a decision and carry it on until the end
Your initial post was about a backup, now about producing a report icon_question.gif icon_question.gif

for reports the common and most used record length is, guess what?, 133
so no wonder that Your report does not fit

If You need to transfer the data to a PC, You do not need a report,
You just need an all character representation of Your data
use a different tool to just flatten out ( from packed, binary ) the numerics
and transfer the resulting file to the pc
Back to top
View user's profile Send private message
diwa_thilak

Active User


Joined: 13 Jul 2006
Posts: 205
Location: At my desk

PostPosted: Fri Feb 29, 2008 6:33 am    Post subject:
Reply with quote

Thanks Enrico,Dick,

Yup you are right Enrico, All i need to see the data in the form of Excel.

That is need to download the records from VSAM file into a flat file.

Detailed explanation.

I have a VSAM file its LRECL is 255 (around 30 cols) and i just browse the file(VSAM) using File-Aid(VFMT) format.

And i give VPRINT option to print the data horizontally so that i could take the same in Excel using FTP.

But File-Aid seems to have an constraint that not more than 133 LRECL i can extract. So data gets truncated.

But i can extract the data vertically, but formating and loading the data in excel becomes tedious.

If i sort into a PS, the packed decimal in the VSAM gets converted into JUNK character in PS. I could not able to load the data into PS.

Is there any other way i can retrieve the data from VSAM into an Excel ?
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: Fri Feb 29, 2008 7:54 am    Post subject:
Reply with quote

Hello,

Yes, you could read the vsam data into a little cobol program that uses the existing copybook, move the non-displayable numbers to edited fields (i.e. zz,zz9.99-) which are redefined as pic x(n), and STRING all of the fields delimited by x'05' (tab) into a new output record and then write the new record.

The new ps file will be easy to ftp to some win-based target and will open directly into excel with no other manipulation.
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 -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Split file based on comparsion to 2 f... Div Grad DFSORT/ICETOOL 3 Thu Jul 27, 2017 9:16 pm
No new posts Problem commiting to DB2 from IMS MPP Ole Soerensen IMS DB/DC 2 Wed Jul 26, 2017 5:19 pm
No new posts Extra character appears in file when ... Balu5491 All Other Mainframe Topics 1 Wed Jul 26, 2017 2:39 pm
No new posts SSH - known_hosts file configuration vasanthz All Other Mainframe Topics 2 Wed Jul 26, 2017 2:10 am
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm


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