MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 31 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: DB2 Clone Table Question
ed.sam13

Replies: 5
Views: 3718

PostForum: 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

PostForum: 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: 3718

PostForum: 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

PostForum: 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: 3718

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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: 2726

PostForum: 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: 2726

PostForum: 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

PostForum: 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 ...
 
Page 1 of 3 Goto page 1, 2, 3  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group