If my file contains 100,000 records and job abended at
55,000th records processing then how can i restart job from
that record onward by ignoring that record. I can not edit
the file as file size is big and it is getting browse
substituted?
In a JCL if previous steps return code is greater than 0 or
4 then the next step will not execute. But the job will be
successfull with the maximum return code. How can we reset
this maximum return code to '0' regardless of return codes
of any steps?
how a varible can be passed to a subfile...accnt1 contain
data in a data area..ie Daccnt1 uds,Daccnt2 3
overlay(accnt1:1),
DNo 4 overlay(accnt1:4)..we want to transfer this dataarea
value from acnt0001 to a subfile..that means to enter each
record we have to incriment account no,,
i normal window we can do
move accnt1 account_no
eval account_no=accnt1
eval no=no+1
exfmt usr_account
how it possible with Subfile????????.Please do answer?
(Thank you for all your answers dear friends!!)
SET is the ANSI standard for variable assignment, SELECT is
not.
SET can only assign one variable at a time, SELECT can make
multiple assignments at once.
If assigning from a query, SET can only assign a scalar
value. If the query returns multiple values/rows then SET
will raise an error. SELECT will assign one of the values
to the variable and hide the fact that multiple values were
returned (so you'd likely never know why something was
going wrong elsewhere - have fun troubleshooting that one)
When assigning from a query if there is no value returned
then SET will assign NULL, where SELECT will not make the
assignment at all (so the variable will not be changed from
it's previous value)
As far as speed differences - there are no direct
differences between SET and SELECT. However SELECT's
ability to make multiple assignments in one shot does give
it a slight speed advantage over SET.
I/o error detected,Record Out of sequence,Permanent I/o
error occured....I mean give one eg for these errors...i
understand only,update/delete operation without prior read
oprn..give details of remaining
I have some 3 particular fields ..i want to know which all
tables have those 3 fields. Is there any way to identify..
can we know by quering system tables..
If there are two copybooks which have same variables and we
are using both the copybooks in our program. will there be
an error and if i move values to the variable which copybook
varibales gets the values i move in.
what are the types of errors available in rpg IV or
400.Like decimal data error,sessional error or device error
etc...means important error occurings,ie to find out
suddenly???pls give answ if u know?Pls give the answer
1,,,,,,,to 12.........ie how it will happened like...for eg
if a file is not closiing ,,,like this error is happened...
if sufficient data is not in a pf to write in a display
file. or sfldsp is not "on"......sessional or device error
occured...like this give details all 1 to 12 errors
(syam..)....give details PLsssssssssss?
I have a seq file with different fields one field is address
with pic x(50) as input in a cobol program. In address there is
'PUNE' at any different positions in the address field ( form 1
t0 50) . My requirement is select the fields with address 'PUNE'
by using cobol. Please suggest
suppose if you added a coloumn to db2 table, How would it
be the Impact analysis?
93
Can any one tell me that how we go for the compare,unit
testing after changing requirement as per client request.
this is very helpful for me when u give suitable (coading)
exmple.
How is it possible to do a cross-sysplex copy of a PDS
dataset by running one JCL on the target sysplex?
I tried to use IEBCOPY with SUBSYS & CSM as follows:
//CSMTRAN1 EXEC PGM=IEBCOPY
//SYSPRINT DD SYSOUT=*
//SYSUT1 DD DSN=PDS-Dataset-name-from,DISP=SHR,
// SUBSYS=(CSM,'SYSPLEXNAME-FROM')
//SYSUT2 DD DSN=PDS-Dataset-name-to,DISP=OLD,
// SUBSYS=(CSM,SYSPLEXNAME-TO')
//SYSIN DD DUMMY
This did not work. I always get the following error
"IEB1071E DD NAME SYSUT1 IS SUPPOSED TO BE A PARTITIONED
DATA SET BUT IT HAS NO DIRECTORY. EXPECT A TERMINAL I/O
ERROR. (DS1LSTAR=X'000000' DS1DSORG=X'0000'
JFCDSORG=X'0200') "
The source dataset is a catalogued pds dataset with many
entries. The target dataset is allocated in the same job
some lines before the transfer.
I got an example like this for PS datasets with IEBGENER.
But for PO datasets there should be a similar possibility...
DB2 can implement a join in three ways using a merge join,
a nested join or a hybrid join. Explain the differences?
257
what r the quality process in development
197
I have some 3 particular fields ..i want to know which all
tables have those 3 fields. Is there any way to identify..
can we know by quering system tables..
I'm new to rexx. How to code rexx in jcl to read in a lpar
cpu usage file and select 1. date, time 2. some system
names 3. cpu usage for each system. The input file has
hourly reporting. The output file (CSV)is for excel use.
Run in batch mode. Output in FB.
225
1) What is ONCODE (Return code) in PL/1?
2) How to handle the ONCODE in PL/1? Please give me some
examples?
can anybody help me to solve this problem. the program that
i m checking display error message saying "Record format
for file AJDSPFFD does not match model file and decimal
error. how to solve this problem. The AJDSPFFD is snapshot
the AJTLOG that is the audit trail list.