can any one provide me the link for the db2 v7 & db2 v8
manual for Z/os? i need to know about the syntax of REORG
in both versions & need to know the difference as well
in my project..TEST is db2 8.1 version In PROD it is 7.1
if i do REORG in TEST.. can I use the same REORG jcl with
out modification in PROD region (this is DB2 8.1 )? if
not, what modification i need to do in my REORG control
card?
I have database, in that segment1 having dept code and
segment 2 and so on multiple employees num. using dept &
employee num we have to compare whether that employee belong
to that dept or not, if that employee belongs to that dept
then incentive is same same as in the table or else
incentive must be zero? using IMS & cobol
How to open VSAM file from 3.4?
i have millions of records and i dont want to use the print
ch ids(/) command bcz it takes to much time.
so if you have any another command to open this plz tell me.
1) SORT FIELDS=(20,4,CH,D,10,3,CH,D)
OUTREC FIELDS=(7:20,4,C' FUTURE ',20,2,10,3,1Z,1,9,13,7,
24,57,TRAN=LTOU,6X'FF')
This example illustrates how a fixed-length input data set
can be sorted and reformatted for output. The SORTIN LRECL
is 80 bytes.
The reformatted output records are fixed length with a
record size of 103 bytes. SOLRF (the IBM-supplied default)
is in effect, so unless the SORTOUT LRECL is specified or
available, it will automatically be set to the reformatted
record length of 103.
in the above example i have some doubts that
a) sort fields=(20,4,CH,D,10,3,CH,D) -what exactly it does
and this fields related to output record fields or input
record fields
b)outrec used to refprmat the records after sorting that
means
could please reply me as soon as possible
Thanks.
Venkat
My Question is
1. How to cound no. of records in JCL. Please explain with
an example.
2. How to execute only odd steps in JCL?
I know EDIT TYPE = Inculde, Step Name = 1,3,5 and
COND code for all even step.
Anyone knows other than this.
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB
and PGMB calls PGMC. I have to do inserts, updates in all
the 3 pgms.
2) Say PGMC has done its work successfully and returned to
PGMB
3) PGMB had an SQL error while doing some update
4) PGMA has already done some updates before calling PGMB
all are running under the same CICS region.
What will happen if I issue SYNCPOINT ROLLBACK in PGMB when
it abends ? Does all the changes in PGMA,B,C rollback ?
(because all the pgms belong to same task).
536
How do we pass parameters into a CICS –DB2 program
How can i load all the data from a file to Table (array) in
cobol.How i manage the occurs clause with out reading the
file.Any options avilable ? Please can any one help me it
is urgent?
is there any way to execute more than one proc in the same
exec statement at the same time..?
51
I have program P1 which calls file F1 which has 100 records
and following structure
001 ..................
002 ..................
003 ..................
098 ....................
099 ...................
100 ....................
Now I want to read these files and write these records in
file F2 in following manner.
001 ...... 051 .....
002 ...... 052 .....
003 ...... 053 .....
.......... .......
.......... .......
.......... .......
048 ........ 098 ......
049 .......... 099 .......
050 .... 100 ......
Login
| Sign Up
SiteMap shows list of All Categories in this site.
Site Map
