Author |
Message |
Topic: DB2 Clone Table Question |
ed.sam13
Replies: 5
Views: 3719
|
Forum: Database Posted: Thu Oct 22, 2015 11:37 am Subject: DB2 Clone Table Question |
It takes close to 8 hours end to end. All the unload/load and process files are on tape. |
Topic: Arrays in DB2 Stored Procedure |
ed.sam13
Replies: 3
Views: 4074
|
Forum: Database Posted: Wed Oct 21, 2015 7:01 pm Subject: Arrays in DB2 Stored Procedure |
Can stored procedures created for DB2 on z/OS support arrays? I tried the example in https://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.apdv.sqlpl.doc/doc/c0052894.html but do ... |
Topic: DB2 Clone Table Question |
ed.sam13
Replies: 5
Views: 3719
|
Forum: Database Posted: Wed Oct 21, 2015 5:06 pm Subject: DB2 Clone Table Question |
Seems like there is no other way around this........... |
Topic: Passing CLOB from Cobol to Native SP |
ed.sam13
Replies: 7
Views: 5211
|
Forum: Database Posted: Mon Oct 19, 2015 11:56 pm Subject: Passing CLOB from Cobol to Native SP |
Thanks. When I changed the definition of the field from CLOB to CLOB(3M) it worked |
Topic: DB2 Clone Table Question |
ed.sam13
Replies: 5
Views: 3719
|
Forum: Database Posted: Sun Oct 18, 2015 10:47 pm Subject: DB2 Clone Table Question |
We have a DB2 table on z/OS with 100M rows. There is a Java spring batch process which gets a file from another system processes these updates and update/inserts into this table.
But once in a yea ... |
Topic: Passing CLOB from Cobol to Native SP |
ed.sam13
Replies: 7
Views: 5211
|
Forum: Database Posted: Sun Oct 18, 2015 9:48 pm Subject: Passing CLOB from Cobol to Native SP |
hi Kolusu, nope. WS-LIMIT just tells me how many occurrences of the array should be filled before calling the SP. The max value for WS-LIMIT could only be 500.
Ok so the logic in the program is as ... |
Topic: Passing CLOB from Cobol to Native SP |
ed.sam13
Replies: 7
Views: 5211
|
Forum: Database Posted: Sun Oct 18, 2015 8:55 pm Subject: Passing CLOB from Cobol to Native SP |
The definition of WS-LIMIT is 9(04). I suspect that there is a 1MB limit set somewhere which is causing this issue. When it is 3000*349 it crosses the 1MB limit. I tried increasing the REGION paramete ... |
Topic: Passing CLOB from Cobol to Native SP |
ed.sam13
Replies: 7
Views: 5211
|
Forum: Database Posted: Fri Oct 16, 2015 5:41 pm Subject: Passing CLOB from Cobol to Native SP |
Actually it is good only until occurrence 348. When I populate 349th occurrence, the full CLOB is not getting to the SP. Its getting truncated. |
Topic: Passing CLOB from Cobol to Native SP |
ed.sam13
Replies: 7
Views: 5211
|
Forum: Database Posted: Fri Oct 16, 2015 5:36 pm Subject: Passing CLOB from Cobol to Native SP |
I am passing a CLOB from a Cobol program to a native Stored Procedure.
This is my SP input variable declarationion.
01 SP-IN-BATCH USAGE IS SQL TYPE IS CLOB(3000000).
I accumula ... |
Topic: Update on a Indexed Timestamp Field |
ed.sam13
Replies: 5
Views: 3480
|
Forum: Database Posted: Fri Sep 25, 2015 12:52 pm Subject: Update on a Indexed Timestamp Field |
hi Kolusu, Yes the update statement is using the primary keys of the table on the predicate. Last Modified timestamp is one of the columns which get updated on the SET statement along with few other c ... |
Topic: Update on a Indexed Timestamp Field |
ed.sam13
Replies: 5
Views: 3480
|
Forum: Database Posted: Fri Sep 25, 2015 11:52 am Subject: Update on a Indexed Timestamp Field |
hi Kolusu,
Thanks for your reply. Actually I wanted to understand the impact of an update statement when we have a last modified timestamp as index. This will not be a primary index. This will be a ... |
Topic: Update on a Indexed Timestamp Field |
ed.sam13
Replies: 5
Views: 3480
|
Forum: Database Posted: Thu Sep 24, 2015 7:16 pm Subject: Update on a Indexed Timestamp Field |
We have a table with some columns and Last modified timestamp. There will be updates to around 1-2% of the rows in this table everyday. So to extract all rows which were updated for a particular day, ... |
Topic: Error Inserting to ST_POLYGON column |
ed.sam13
Replies: 2
Views: 2727
|
Forum: Database Posted: Mon Sep 14, 2015 1:58 pm Subject: Error Inserting to ST_POLYGON column |
Sorry forgot to mention, When I execute the following Static SQL, it goes thru
INSERT INTO SAMPLE_GEOMETRIES
(GEO_NAME, GEOMETRY)
VALUES
( 'PMX',
DB2GSE.ST_POLYGON('POLYGON( ... |
Topic: Error Inserting to ST_POLYGON column |
ed.sam13
Replies: 2
Views: 2727
|
Forum: Database Posted: Mon Sep 14, 2015 1:56 pm Subject: Error Inserting to ST_POLYGON column |
The following is the definition of the DB2 table.
CREATE TABLE
SAMPLE_GEOMETRIES
(
GEO_NAME CHAR(60) NOT NULL
FOR SBCS DATA
,GEOMETRY ... |
Topic: DB2 Spatial Support for Spring Batch |
ed.sam13
Replies: 1
Views: 3687
|
Forum: Other Technical Topics Posted: Mon Sep 14, 2015 4:20 am Subject: DB2 Spatial Support for Spring Batch |
I have the following question.
[url=http://stackoverflow.com/questions/32560983/spring-batch-db2-update-db2gse-st-polygon-fails]Spring Batch DB2 update DB2GSE.ST_POLYGON fails
I am not sure whom ... |
|