04-20-2013
Quote:
Originally Posted by
SundarGampa
Is there a way to read the file and write it to a fixed length format.
Undoubtedly it can be done (Perl, for example, is often used for this type of application), but you would have to provide a detailed description of both file formats, the current and the desired.
For example, you mention that each record is preceded by its length but neglect to specify how the length is encoded. With regard to the output format, how should the fixed width be determined? Should it be equal to the longest record? Should it be some other value? If that value is insufficient to accommodate a record, should that record be truncated? How should records be padded? Should the output be newline terminated? Should the records be modified in any way, such as unpacking binary values?
Again, if you would like assistance, you will have to do a much more thorough job of describing the file formats and the conversion process.
If the file formats you're working with utilize some mainframe standard, a link that explains them would be invaluable for those who are not familiar with them but could otherwise assist.
Regards,
Alister
Last edited by alister; 04-20-2013 at 12:27 PM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi I m an absolute dummy on UNIX, I m basically a SAP guy. but I require a file which is stored on the mainframe to be moved to Unix application server. I got the following script to do it from someone
#! /usr/local/bin/move_prom
REMOTE_HOST=158.52.246.30 # Hostname of the remote Mainframe... (2 Replies)
Discussion started by: satyaj_99
2 Replies
2. Shell Programming and Scripting
Any help to read the contents of a variable length csv ....??(using awk)
The csv mite look like this :
anjali,ram,rahul,mohini,sam,.... and so on ...
I need to pick up each name..
Thanks in advance
SD (3 Replies)
Discussion started by: shweta_d
3 Replies
3. Shell Programming and Scripting
Hi,
I have received a mainframe file ( VSAM file ) . I would like to handle that file in Unix. i.e I would like to take the last record of the file. I have given wc -l <file_name> , it gives 0 lines. Even though It has some lines , it is not giving count exactly. When I gave file <file_name>... (1 Reply)
Discussion started by: thambi
1 Replies
4. UNIX for Advanced & Expert Users
thanks (2 Replies)
Discussion started by: ashishabhishek
2 Replies
5. UNIX for Dummies Questions & Answers
Hi, all.
I need to convert a file tab delimited/variable length file in AIX to a fixed lenght file delimited by spaces. This is the input file:
10200002<tab>US$ COM<tab>16/12/2008<tab>2,3775<tab>2,3783
19300978<tab>EURO<tab>16/12/2008<tab>3,28523<tab>3,28657
And this is the expected... (2 Replies)
Discussion started by: Everton_Silveir
2 Replies
6. Shell Programming and Scripting
Dear all,
I have basic knowledge of Unix script and her I am trying to process variable length and variable format CSV file.
The file length will depend on the numbers of Earnings/Deductions/Direct Deposits.
And
The format will depend on whether it is Earnings/Deductions or Direct Deposits... (2 Replies)
Discussion started by: chechun
2 Replies
7. UNIX for Dummies Questions & Answers
Hi,
The files are being zipped from mainframe to the UNIX server. I have to unzip huge files on AIX server which is too old. The UNZIP as well as gzip utility version is not able to handle it and if we have to install the latest version there is a lot of process which takes lot of process. Is... (4 Replies)
Discussion started by: Bijesh
4 Replies
8. UNIX for Dummies Questions & Answers
Hi Everyone,
Do I need to provide record length as Record length + 4 when I'm transferring a variable block files from unix to mainframe through ftp?
For example, I have a file in unix (ebcidic converted) with maximum record length of 100.
This works correctly,
quote... (1 Reply)
Discussion started by: poova
1 Replies
9. Shell Programming and Scripting
Hi All ,
I need a help regarding file ftp ing from mainframe to unix.Our source file is mainframe file.I need to download the mainframe file to local unix server through unix script.If anyone can help me how we can do it through unix script ,it will be really helpful.Thanks. (7 Replies)
Discussion started by: STCET22
7 Replies
10. UNIX for Beginners Questions & Answers
My sample file is variable length, with out any field delimiters. It has min of 18 chars length and the 'CRLF' is potentially between 12-14 chars. How do I replace this with a space? I still want to keep end of record, but just want to remove these new lines chars in the middle of the data.
... (7 Replies)
Discussion started by: chandrath
7 Replies
LEARN ABOUT HPUX
hppacsrd
hppac(3X) hppac(3X)
NAME
hppac: HPPACADDD(), HPPACCMPD(), HPPACCVAD(), HPPACCVBD(), HPPACCVDA(), HPPACCVDB(), HPPACDIVD(), HPPACLONGDIVD(), HPPACMPYD(), HPPAC-
NSLD(), HPPACSLD(), HPPACSRD(), HPPACSUBD() - HP 3000-mode packed-decimal library
SYNOPSIS
DESCRIPTION
This set of calls invokes the library functions for emulating 3000-mode (MPE V/E) packed-decimal operations. These functions are in
library which is searched when the option is used with or ld(1).
Performs packed-decimal addition.
Compares two packed-decimal numbers.
Converts an ASCII representation to packed-decimal.
Converts a binary representation to packed-decimal.
Converts a packed-decimal number to ASCII.
Converts a packed-decimal number to binary.
Performs packed-decimal division.
Performs packed-decimal division (alternate routine).
Performs packed-decimal multiplication.
Performs a packed-decimal normalizing left shift.
Performs a packed-decimal left shift.
Performs a packed-decimal right shift.
Performs packed-decimal subtraction.
For all operations, the value returned in the variable to which the compcode argument points is one of the following values of type
Result > 0 or operand1 > operand2
Result < 0 or operand1 < operand2
Result == 0 or operand1 == operand2
For all operations, the value returned in the variable to which the pacstatus argument points is one of the following values of type Their
meanings are intended to be obvious:
AUTHOR
The HPPAC library was developed by HP.
SEE ALSO
PA-RISC Systems Only hppac(3X)