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
 

 

Convert a VB Dataset to FB Dataset

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
VivekKhanna

New User


Joined: 09 Feb 2009
Posts: 57
Location: India

PostPosted: Sun Jul 04, 2010 2:05 pm    Post subject: Convert a VB Dataset to FB Dataset
Reply with quote

Hi,

I had received a dataset (from FTP) and it contains some variable length records.

1. The problem is that I don't know about LRECL and MAXLEN of the records, that will be received. Then I need to process the information based on the delimiter provided (example below).

2. The second problem is that, the records may continue in the next line too (example below).

Key for reading the record is first 9 chars.

Code:

111111111|ABCDXYZ|ABCS@ZYS.COM|ASDRG
111111112|ASVB|ASD@XYZ.COM!ASE
ASD
111111113|SDLKFHFD|ERIT@DFG.COM|SDDGF
111111114|SDFGDFG|DSKG@ERSDR.COM|SDFLKDG
DFGDHJSD
111111115|DFG|DFG@WER.COM|DFGDFGKJ
111111116|DFGDSFHGDF|SDFGHDFH@RITF.COM|DFGHFGH
111111117|DSFGSDG|SDFGDF@OIER.COM|SDFGDFSGH


I need the output to be FB and the output should be like:

Code:

111111111|ABCDXYZ|ABCS@ZYS.COM|ASDRG
111111112|ASVB|ASD@XYZ.COM|ASEASD
111111113|SDLKFHFD|ERIT@DFG.COM|SDDGF
111111114|SDFGDFG|DSKG@ERSDR.COM|SDFLKDGDFGDHJSD
111111115|DFG|DFG@WER.COM|DFGDFGKJ
111111116|DFGDSFHGDF|SDFGHDFH@RITF.COM|DFGHFGH
111111117|DSFGSDG|SDFGDF@OIER.COM|SDFGDFSGH


The problem is that I don't know LRECL and MAXLEN of the record, and then convert VB into FB.
Please guide.
Back to top
View user's profile Send private message

Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Tue Jul 06, 2010 2:30 am    Post subject:
Reply with quote

You haven't given enough information for anyone to help you.

If you don't know the LRECL or MAXLEN of the record, how can we know the maximum number of delimited fields to expect? Or what the continued line can look like, or if there can be more than one continued line, or ...

You need to do a better job of defining what you're trying to do, what the data can look like, the maximum number of delimited fields per line, etc before anyone can help you.
Back to top
View user's profile Send private message
VivekKhanna

New User


Joined: 09 Feb 2009
Posts: 57
Location: India

PostPosted: Tue Jul 06, 2010 1:07 pm    Post subject:
Reply with quote

Hi Frank,

Please consider the above mentioned data, as the complete one. If there are 4 fields in the input, then the record will look like

Code:

111111111|ABCDXYZ|ABCS@ZYS.COM|ASDRG


The biggest problem is that, we are not sure, whether the information that has been sent is through FTP or copy-pasted like a notepad file. No information has been provided on the same. We are still trying to get this information like LRECL and MAXLEN of the record. But still, one of the biggest headache is the following type of record:

Code:

111111114|SDFGDFG|DSKG@ERSDR.COM|SDFLKDG
DFGDHJSD
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: Tue Jul 06, 2010 10:31 pm    Post subject:
Reply with quote

Hello,

Quote:
No information has been provided on the same.
Until you have the specifications for the data how do you plan on implementing any solution. . . - sort or otherwise. . . icon_confused.gif

Suggest this be put on hold until someone can tell you the "rules".

Suggest also that some effort be put into correcting the creation of the file to be uploaded.
Back to top
View user's profile Send private message
VivekKhanna

New User


Joined: 09 Feb 2009
Posts: 57
Location: India

PostPosted: Tue Jul 06, 2010 11:14 pm    Post subject:
Reply with quote

Thanks Dick.

I had already put up the queries to provide us with LRECL and MAXLEN.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Jul 07, 2010 11:24 am    Post subject:
Reply with quote

I agree with Dick. You are treating the symptoms and not the cause.

As stated by Dick
Quote:
Suggest also that some effort be put into correcting the creation of the file to be uploaded.
This would be the best solution.
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Want to pull the job log into a Mainf... Jishu Mukherjee Compuware & Other Tools 9 Tue Mar 21, 2017 4:48 pm
No new posts JCL to get submitted once dataset has... vinu78 JCL & VSAM 17 Thu Feb 16, 2017 7:32 am
No new posts Convert current to hex value gopurs DFSORT/ICETOOL 4 Wed Feb 15, 2017 5:40 am
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts Convert +9999999999999.99 to S9(12)V9(3) vnktrrd DFSORT/ICETOOL 8 Thu Nov 17, 2016 8:15 pm


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