Total Answers Posted # 37
Total Answers Posted for My Questions # 0
Total Views for My Questions # 0
Users Marked my Answers as Correct # 349
Users Marked my Answers as Wrong # 118
Question { 5815 }
i want to know how the commit option works,how it save the
changes? it will update the database or what ? where we can
see these saved changes?
Answer
Mostly we are using commit mass insert and update time
only.suppose i insert 1000 records i am using count varable
i give commit every 100th records means it will
automatically update the data base.so it will affect 999th
records means 900 records ulready update in ur table.so we
can restart 901 records thats enough.you can see in ur
table.
| Is This Answer Correct ? | 6 Yes | 2 No |
Question { 10369 }
i have the following varibles in the working storage
05 ws-A PIC X(30)
VALUE 'ABCDEFGHIJKLMNOPQRESTUVWXYZ '
05 WS-B REDEFINES WS-A
10 WS-B1 PIC X(10).
10 WS-B2 PIC 9(10).
10 WS-B3 PIC X(10).
If I Display B1, B2 and B3 respectively, what is the value
displayed in B2
Answer
klmnopqrst will displayed no compilation error and runtime
error it will work normally.
| Is This Answer Correct ? | 8 Yes | 4 No |
Question { 27889 }
How I sort the records in a file and copy the first 10
records to another file
Answer
Using dfsort
//step10 exec pgm=sort
//sirtin dd dsn=userid.qulifier.psname,disp=shr
//sortout dd dsn=userid.qulifier.psname,disp=shr
sort fields=(starting position,length,cha,asc/dsc)
stopaft=10
now u get result sortout ps.
| Is This Answer Correct ? | 23 Yes | 0 No |
Question { Cap Gemini, 23530 }
How to resolve -502 sql code in DB2?
Answer
Open cursor already open.try to check the open cursor
giving twice.
| Is This Answer Correct ? | 13 Yes | 1 No |
Question { Cap Gemini, 15326 }
How to resolve -917 sql code in DB2?
Answer
Bind packages failed
| Is This Answer Correct ? | 2 Yes | 1 No |
Question { Cap Gemini, 27978 }
How to resolve -407 sql code in DB2?
Answer
The coloumn declare not null.but we can try to inserted or
update that coloumn means -407 error will come.
| Is This Answer Correct ? | 12 Yes | 3 No |
Question { Cap Gemini, 27978 }
How to resolve -407 sql code in DB2?
Answer
sorry above answer coloumn difine not null but we are to
inserted null values that time -407 will come.
| Is This Answer Correct ? | 5 Yes | 5 No |
Question { Cap Gemini, 17529 }
How to resolve -504 sql code in DB2?
Answer
-504 is cursor not declared error.may be cursor name
misspeled also coming this error.
| Is This Answer Correct ? | 17 Yes | 0 No |
can u plz expain me how to declare dynamic array? what is
the meaning of depending on clause in dynamic array?
Answer
01 studet.
02 stunam occurs 3 to 4 times depanding on n.
03 stuname pic x(15).
03 stumrk occurs 2 times.
04 stumark pic 9(3).
this is dynamic array.now runtime will pass the input.because
using depanding clause.
depanding clause pass the value runtime.
| Is This Answer Correct ? | 3 Yes | 12 No |
Question { 4511 }
I have a files containing both duplicate and non-duplicate
records.The file is already sorted by a key.I want to
determine those records that are duplicate and records that
are non-duplicate.If duplicate the record is move to a
duplicate file and if non-duplicate that will be move to
valid file.thank you
Answer
using sort its possible.
sum fields=none,xsum
matching record present in sortout.
non matching record present in xsum.
another type using file matching concept.
| Is This Answer Correct ? | 3 Yes | 4 No |
i have a sequencial file contains multiple records, i want
to extract one row which contains various fields like order
number,date,warehouse,.ect.. in to the another file by
accepting the order number from jcl. how can i do it. pls
help me..
Answer
its possible to both jcl and cobol.in jcl using sort
utilities sort fields=(1,orderno size,bi,a)
| Is This Answer Correct ? | 3 Yes | 0 No |
