Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts File Tailoring -- Temporary dataset i... samzee71 CLIST & REXX 3 Fri Dec 01, 2017 3:12 am
No new posts Rexx - File tailoring samzee71 CLIST & REXX 10 Thu Nov 30, 2017 10:47 pm
No new posts Moving a PS file as body of a mail! Vignesh Sid JCL & VSAM 4 Tue Nov 21, 2017 9:23 pm
No new posts unable to set RC = 4 when empty file migusd SYNCSORT 1 Tue Nov 21, 2017 1:21 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us