COPY A VBS FILE TO FB FORMAT



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

COPY A VBS FILE TO FB FORMAT

Postby marg » Wed Jul 17, 2013 5:56 pm

Hi,

I need to copy a VBS file to a FB file using DFSORT.
The parameters of the I/P file is as below:
Organization . . . : PS
Record format . . . : VBS
Record length . . . : 32768
Block size . . . . : 27998

I used the below Sysin and it threw
ICE111A E REFORMATTING FIELD ERROR

SORT FIELDS=COPY
OUTFIL FNAMES=SORTOUT,VTOF,
OUTREC=(5,32764)

Could you please let me know on the sort card?
marg
 
Posts: 4
Joined: Mon Jul 15, 2013 11:51 am
Has thanked: 0 time
Been thanked: 0 time

Re: COPY A VBS FILE TO FB FORMAT

Postby Robert Sample » Wed Jul 17, 2013 6:06 pm

Did you look up the ICE111A message in the manual? If not, why not? If so, did you notice the 4th possible cause of a column greater than 32752? Or the one about position plus length being greater than 32753?
Robert Sample
Global moderator
 
Posts: 3720
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: COPY A VBS FILE TO FB FORMAT

Postby dick scherrer » Wed Jul 17, 2013 7:10 pm

Hello,

Are you aware of what is possible in a VBS dataset? The lrecl for a record may be longer than blksize. . . .

What kind of file are you trying to copy to FB?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: COPY A VBS FILE TO FB FORMAT

Postby steve-myers » Wed Jul 17, 2013 9:10 pm

  1. The DCB attributes for the proposed input data set are not valid. Did you copy them to the post correctly?
  2. If the LRECL really is 32768, the data set may have been created using the very rarely used LRECL=X option. The few times I have tried using this feature have not worked well, so I cannot offer any guidance.
  3. if the LRECL is really 32767, the data set is most likely SMF data. You would be a fool to copy SMF data to an FB data set; the output data set would be much larger than the input data set, which is already quite large.
  4. What do you really want to do with this data? Perhaps someone can propose something more apprpriate.
steve-myers
Global moderator
 
Posts: 2105
Joined: Thu Jun 03, 2010 6:21 pm
Has thanked: 4 times
Been thanked: 243 times

Re: COPY A VBS FILE TO FB FORMAT

Postby marg » Thu Jul 18, 2013 9:49 am

I am not a fool to register in this forum and post topics.
I may be. But you are not the person to criticise on that.

This is a learning forum and I expect some ethics both from users and moderators.
marg
 
Posts: 4
Joined: Mon Jul 15, 2013 11:51 am
Has thanked: 0 time
Been thanked: 0 time

Re: COPY A VBS FILE TO FB FORMAT

Postby BillyBoyo » Thu Jul 18, 2013 10:56 am

And exactly how has that progressed your cause? You bothered to reply without addressing a single point raised,. I have not even an idea of what has upset you.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: COPY A VBS FILE TO FB FORMAT

Postby dick scherrer » Thu Jul 18, 2013 8:02 pm

Hello,

I am not a fool to register in this forum and post topics.
I may be. But you are not the person to criticise on that.

This is a learning forum and I expect some ethics both from users and moderators.
Obviously, something / someone has caused you grief. Why do you believe there was any criticism?

If you take the time to explain your issue, someone will be able to address it.

From what you posted, we have no idea how to reply other than to ask for clarification of your complaint . . .

As far as your "sort card" question, you need to explain more about what you have and what you need to accomplish. The file will not simply copy to FB and when we know more we may be able to offer suggestions.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: COPY A VBS FILE TO FB FORMAT

Postby steve-myers » Thu Jul 18, 2013 10:08 pm

The purpose of LRECL=X is to provide for logical records greater than 32767 bytes, but YOUR program must assemble the segments while reading the data set or create the segments while writing the data set. Data management will not provide assistance, as it does for VBS with LRECL <= 32767. You cannot specify LRECL=X in JCL, either.

As Mr. Scherrer pointed out, you cannot create a RECFM F data set with an LRECL > 32760. If your input data is really LRECL=X and it has real records > 32760 bytes, what do you want to do?

My issue with SMF data is that, while you encounter a few records in the 32K area, most of the records are much shorter. Copying a 3200 byte record to a 32760 byte output record is very inefficient.
steve-myers
Global moderator
 
Posts: 2105
Joined: Thu Jun 03, 2010 6:21 pm
Has thanked: 4 times
Been thanked: 243 times

Re: COPY A VBS FILE TO FB FORMAT

Postby skolusu » Thu Jul 18, 2013 11:04 pm

marg wrote:I am not a fool to register in this forum and post topics.
I may be. But you are not the person to criticise on that.

This is a learning forum and I expect some ethics both from users and moderators.


marg,

I have gone thru the responses and I am not sure what made you upset. People help here voluntarily and there is no reason for you to get all worked up. You can explain a bit more about your requirement and then may be we can offer you a solution.
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post