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
 

 

Problem with a file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PC Guides & IT News
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    Post subject: Problem with a file
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> PC Guides & IT News All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts SYMNAMES problem jacobdng DFSORT/ICETOOL 7 Thu Dec 22, 2016 7:47 am
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm


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