MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Converting VB to VBS

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Application Programming
View previous topic :: View next topic  
Author Message
karunkallore
Beginner


Joined: 11 Dec 2004
Posts: 103
Topics: 39

PostPosted: Mon Jun 25, 2007 4:26 pm    Post subject: Converting VB to VBS Reply with quote

Hello Guru's,

I have a question which is bothering me a little bit. Hope to get some relief posting it here.

I have a file , the name is &&TEST ( a temporary one ) which is declared in the following format in the JCL and in the COBOL code.


IN JCL
----------

//TEST DD DSN=&&TEST,
// DISP=(NEW,DELETE,DELETE),
// UNIT=SYSWK,
// SPACE=(CYL,(1,75),RLSE),
// DCB=(RECFM=VB,LRECL=11508,BLKSIZE=0,DSORG=PS,BUFNO=50)


IN COBOL CODE
----------------------

INPUT-OUTPUT SECTION.
*********************
SELECT TEST-FILE
ASSIGN TO TEST
ORGANIZATION IS SEQUENTIAL.

FILE SECTION.
*********************

FD TEST-FILE
BLOCK CONTAINS 0 RECORDS
LABEL RECORDS ARE STANDARD.


Now the question is :-

1) Would there be a problem in converting this VB file to a VBS ? I am planning to do this because I heard somewhere that if a file is in VBS then it increases the perforamance when a sort is done on the file.

2) Could some one tell me what all parmeters I need to change to convert this VB file to VBS. I have done it the way I figured out it should be but as always Guru's please correct me if I am wrong.

IN JCL ( modified one )
--------------------------------

//TEST DD DSN=&&TEST,
// DISP=(NEW,DELETE,DELETE),
// UNIT=SYSWK,
// SPACE=(CYL,(1,75),RLSE),
// DCB=(RECFM=VBS,LRECL=11508,BLKSIZE=0,DSORG=PS,BUFNO=50)


IN COBOL CODE ( Modified One )
----------------------------------------------

INPUT-OUTPUT SECTION.
*********************
SELECT TEST-FILE
ASSIGN TO TEST
ORGANIZATION IS SEQUENTIAL.

FILE SECTION.
*********************

FD TEST-FILE
BLOCK CONTAINS 0 CHARACTERS
LABEL RECORDS ARE STANDARD.
RECORDING MODE IS S.

Can I retain the LRECL as11508 and BLKSIZE=0 or do I need to change it ? Any other changes so that the file (&&TEST ) created in VB and VBS format are same.

3) Finally but not the least could some one tell me the diffirence between VB and VBS formats ? Pros and Cons and stuff like that ?

Thanks a lot in advance....

Karun
Back to top
View user's profile Send private message Send e-mail
dbzTHEdinosauer
Supermod


Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany

PostPosted: Tue Jun 26, 2007 12:43 am    Post subject: Reply with quote

Quote:
Spanned Records: A spanned record is a variable-length record in which the length of the record can exceed the size of a block. If this occurs, the record is divided into segments and accommodated in two or more consecutive blocks by specifying the record format as either VS or VBS. Segmentation and assembly are handled by the operating system. The use of spanned records allows you to select a block size, independently of record length, that will combine optimum use of auxiliary storage with maximum efficiency of transmission.



Are your records fixed length or variable length?
_________________
Dick Brenholtz
American living in Varel, Germany
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Tue Jun 26, 2007 6:32 am    Post subject: Reply with quote

karunkallore wrote:

1) Would there be a problem in converting this VB file to a VBS ? I am planning to do this because I heard somewhere that if a file is in VBS then it increases the perforamance when a sort is done on the file.


Says who? Why would you think a spanned record is easy to sort?

karunkallore wrote:

2) Could some one tell me what all parmeters I need to change to convert this VB file to VBS. I have done it the way I figured out it should be but as always Guru's please correct me if I am wrong.


Check this link which answers your queries

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/IGY3PG10/1.9.1.1.4?SHELF=&DT=20020923143836&CASE=

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
karunkallore
Beginner


Joined: 11 Dec 2004
Posts: 103
Topics: 39

PostPosted: Tue Jun 26, 2007 9:34 am    Post subject: Replies.... Reply with quote

Hi Dick,

Its a VB record.


Hi Kolusu,

One of my colleagues in main frame had suggested. May be I misinterpreted him. My fault.

Could you please see the changes I made in JCL and COBOL code and let me know if this okay. I am worried about the BLKSIZE and LRECL ? Can i retain those as same as that when the file was VB ?

Thanks,
Karun.
Back to top
View user's profile Send private message Send e-mail
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Tue Jun 26, 2007 10:01 am    Post subject: Reply with quote

karunkallore,

Let us stick to the topic in discussion instead of me.

Why do you have to code the LRECL and Blksize in the JCL? If you want the LRECL to be 11508 , then define the FD field as
Code:

FD  VBFILE                           
    BLOCK CONTAINS 0 CHARACTERS     
    LABEL RECORDS ARE STANDARD       
    RECORDING MODE IS S.             
                                     
01  VBSREC              PIC X(11504).



Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
karunkallore
Beginner


Joined: 11 Dec 2004
Posts: 103
Topics: 39

PostPosted: Tue Jun 26, 2007 10:14 am    Post subject: Reply with quote

Okay thanks ! But then how about Blksize ? Can i retain that in the JCL ? Or should it be totally removed with no reference neither in the code nor in the JCL ?

Also may be a naive question ..but is there any disadvantage in keeping the Lrecl in the JCL as the lay out for this file is kind of fixed in the code due to some coding standards followed here.


Thanks
Karun
Back to top
View user's profile Send private message Send e-mail
vak255
Intermediate


Joined: 10 Sep 2004
Posts: 384
Topics: 79

PostPosted: Wed Jun 27, 2007 11:33 am    Post subject: Reply with quote

Quote:

how about Blksize ? Can i retain that in the JCL ? Or should it be totally removed with no reference neither in the code nor in the JCL ?


Karun, you have coded Block contains 0 CHAR, so SMS will decide the best blocksize for it.

If the file is fixed then go-ahead and code it.
Back to top
View user's profile Send private message
karunkallore
Beginner


Joined: 11 Dec 2004
Posts: 103
Topics: 39

PostPosted: Wed Jun 27, 2007 12:02 pm    Post subject: Reply with quote

Thanks Vak255 Smile ! The file is VBS...
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Application Programming All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group