Can I copy the FB (fixed Block) record length file to a VB
(variable Block)record length file and Vise Versa? If Yes
then how ? is that thru one of the JCL utility ?
Answers were Sorted based on User's Feedback
Answer / sathya
yes we can do using sort utility,
//SORTTA EXEC
PGM=SORT
//SYSIN DD *
SORT
FIELDS=COPY
OUTREC FIELDS=(1:5,4096),CONVERT
/*
//SORTIN DD DSN=…,DISP=SHR
//SORTOUT DD DSN=…
//SYSOUT DD
SYSOUT=*
//
The CONVERT control statement is used to convert the
File format from VB to FB.
| Is This Answer Correct ? | 16 Yes | 2 No |
Answer / ds
Yes. using IEBGENER utility we can copy this. But this is
not advisable until there's a specific requirement.
FB to VB
--------
FB rec length is X
VB rec length should be X+4
VB to FB
--------
VB rec length is X (Length indicated in JCL)
FB rec length is X-4
Note: But here in second case lot disk space will be wasted.
Without the idea of requirement and system design, one
can't say anything.
Thanks, DS.
| Is This Answer Correct ? | 14 Yes | 3 No |
Answer / atif
Use syncsort utility.
for FB to VB
OPTION COPY
OUTFIL BUILD=(5,1000),FTOV,VLTRIM=X'40'
simililarly for Vb to FB
OPTION COPY
OUTREC FIELDS=(1:5,4034),CONVERT
| Is This Answer Correct ? | 16 Yes | 5 No |
What do you do if you do not want to keep all the space allocated to a dataset?
One of My Job is running in production, which contains five steps?i want to pass the input to FIFTH step while running is it possible? if how?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above. 1 What is the maximum number of tables that can be stored on a Partitioned Table Space ? 1 what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names Accenture 5 Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code? 6 When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing? 2 how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE IBM 7 max number of columns in a db2 table? 6 What is package versioning? Please give an example. 1 What is the picture clause of the null indicator variable? 6 How do you filter out the rows retrieved from a Db2 table ? 1 What is DB2 (IBM Database 2)? 3 Can any one tell me about Restart logic in DB2.
Min no of member?s (PDS) in one directory block?
if we have a job consist of two steps and each step calling a proc having 10 steps each then how many steps are counted only 2 or 22(10+10+1+1)? can we have more than 255 steps in a single job?
I have Job A and Job B. I want to trigger Job B from Job A. Please advise.
what is meant by jobtrac?
My requirement is : How to populate a empty PS/flat file with ONLY spaces in the first line. You should not use any input dataset to do this. I'm not sure whether you may use any utility for this purpose?
What are isolation levels? Where do we need to specify them in compiling JCL?
How I sort the records in a file and copy the first 10 records to another file
what is XSUM in some fields= none, xsum ??
What do you understand by the terms: joblib and steplib?