Author |
Message |
Topic: JOINKEYS in DFsort manual |
coboladdict
Replies: 1
Views: 4273
|
Forum: Utilities Posted: Sat Mar 27, 2010 7:39 am Subject: JOINKEYS in DFsort manual |
Hi,
I was told DFsort now provides JOINKEYS but I can't find anything about it neither in DFsort manual nor in Ibm Information Center.
Could someone tell me where to find this information?
Thanks. |
Topic: eoc - eibresp 06 in a startbr |
coboladdict
Replies: 10
Views: 9892
|
Forum: CICS and Middleware Posted: Wed Mar 17, 2010 2:21 pm Subject: eoc - eibresp 06 in a startbr |
hi,
the cics guys told me the problem seems to be caused by Cics lack of authority to open the file.
The other problem is that i'm receiving an eibresp that has no relation to the actual error.
i w ... |
Topic: eoc - eibresp 06 in a startbr |
coboladdict
Replies: 10
Views: 9892
|
Forum: CICS and Middleware Posted: Tue Mar 16, 2010 12:06 pm Subject: eoc - eibresp 06 in a startbr |
i display eibresp and eibresp2 codes on the screen right after the startbr statement.
the error doesn't happen in the development site. then, i don't think it is a program error.
EOC is anoth ... |
Topic: eoc - eibresp 06 in a startbr |
coboladdict
Replies: 10
Views: 9892
|
Forum: CICS and Middleware Posted: Tue Mar 16, 2010 6:08 am Subject: eoc - eibresp 06 in a startbr |
Your topic title mentions EOC.
I'm receiving an eibresp 06 after a startbr and according to the manual it is an eoc (end-of-chain).
How is an end-of-chain (EOC) related to a STARTBR?
i don't kn ... |
Topic: eoc - eibresp 06 in a startbr |
coboladdict
Replies: 10
Views: 9892
|
Forum: CICS and Middleware Posted: Mon Mar 15, 2010 5:12 pm Subject: eoc - eibresp 06 in a startbr |
How is an end-of-chain (EOC) related to a STARTBR?
could you please explain what's a chain?
my record is vb and the max lrecl is 1114.
the error doesn't happen in the development site.
only in t ... |
Topic: eoc - eibresp 06 in a startbr |
coboladdict
Replies: 10
Views: 9892
|
Forum: CICS and Middleware Posted: Mon Mar 15, 2010 5:10 pm Subject: eoc - eibresp 06 in a startbr |
coboladdict,
What is RESP2 code?
Kolusu
do you mean eibresp2?
it's zero.
thanks. |
Topic: eoc - eibresp 06 in a startbr |
coboladdict
Replies: 10
Views: 9892
|
Forum: CICS and Middleware Posted: Mon Mar 15, 2010 7:57 am Subject: eoc - eibresp 06 in a startbr |
Hello,
i'm receiving an eibresp 06 when executing an startbr.
i'm not familiar with eoc.
the manual says it can be caused by an end-of-data-set condition but it doesn't seem to be the case.
the ke ... |
Topic: sort - how to write an additional record? |
coboladdict
Replies: 5
Views: 3075
|
Forum: Utilities Posted: Wed Mar 10, 2010 12:35 pm Subject: sort - how to write an additional record? |
I can't post from my work place so I'm gonna do my best.
I want to read an idcams listcat sysout with dfsort, identify the dsn next to the string "nonvsam" and write a file "x" th ... |
Topic: sort - how to write an additional record? |
coboladdict
Replies: 5
Views: 3075
|
Forum: Utilities Posted: Wed Mar 10, 2010 11:57 am Subject: sort - how to write an additional record? |
How can I write, with dfsort/syncsort, an additional record in the output file at the end of the processing?
I tried the "trailer1" option but it requires an specif recfm (it's meant to u ... |
Topic: 0 = 1 |
coboladdict
Replies: 9
Views: 4326
|
Forum: Database Posted: Tue Mar 09, 2010 7:31 am Subject: 0 = 1 |
is it considered a good way to solve a db2 performance problem?
how can an avarege guy like me know when to use this trick?
could you provide some guidance?
thanks. |
Topic: 0 = 1 |
coboladdict
Replies: 9
Views: 4326
|
Forum: Database Posted: Mon Mar 08, 2010 6:02 pm Subject: 0 = 1 |
Actually, it's not AND but OR.
Still doesn't make sense to me.
Thanks. |
Topic: 0 = 1 |
coboladdict
Replies: 9
Views: 4326
|
Forum: Database Posted: Mon Mar 08, 2010 5:44 pm Subject: 0 = 1 |
Ok,
Here goes the entire query:
SELECT ...
FROM TABLE
WHERE CD_PRF_DEPE = :WCD-PRF-DEPE
AND CD_INST = :WCD-INST
AND (DD_BAL ... |
Topic: 0 = 1 |
coboladdict
Replies: 9
Views: 4326
|
Forum: Database Posted: Mon Mar 08, 2010 11:46 am Subject: 0 = 1 |
It runs faster because it is automatically NOT= without even looking at the database columns.
if this condition is never satisfied, how can the query retrieve any line from the table?
thanks ... |
Topic: CEEGTST and vars initialization |
coboladdict
Replies: 1
Views: 1738
|
Forum: Application Programming Posted: Sun Mar 07, 2010 8:16 am Subject: CEEGTST and vars initialization |
Is there a way to have the memory got with CEEGTST or CEECZST initialized?
I have an array in this piece of memory and need to initialize its variables on my own (initialize |
Topic: 0 = 1 |
coboladdict
Replies: 9
Views: 4326
|
Forum: Database Posted: Sun Mar 07, 2010 7:57 am Subject: 0 = 1 |
select col1, col2, col3
from table1
where cola = 123
and colb = 456
we had a query with the code above.
the performance wasn't good enough and the db2 guy in the company suggested the fo ... |
|