IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Problem with a file


IBM Mainframe Forums -> PC Guides & IT News
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Mafuni

New User


Joined: 07 Nov 2006
Posts: 2

PostPosted: Tue Apr 27, 2010 8:32 pm
Reply with quote

Hi !!

I have this problem.

I receveid a file .dat, and this file is the result of an unload DB2 table on mainframe.

Every alphanumeric fields is beetween "..." and is delimited by '|', and the numeric fields contain only the significative numbers in a field of 15 digits.

For example 123.12| but I expected 0000000000123.12|.

How I can set the field in the last format that I wrote ??

Thanks.
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Tue Apr 27, 2010 9:27 pm
Reply with quote

Welcome..

First thing I guess is you are at wrong section of the forum.


First thing you need to find is,
Is this can be done while unloading table itself. For that you need to tell how you are unloading table(using which utility etc)

If no such facility is available while unloading table itself then there are many tools\utilities like SORT OR FILEAID(though I don't know it) which will help you to get required.
But for members here to help you, You need to tell the file format\layout\sample records etc

Since you have posted it to PC Guides & IT news part and if it is intentional then
You might want to look for VBA macros to handle this
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> PC Guides & IT News

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
Search our Forums:

Back to Top