Author |
Message |
Topic: Issue with Table locks |
pkarthik@email.com
Replies: 2
Views: 4125
|
Forum: Database Posted: Fri May 17, 2019 1:58 pm Subject: Issue with Table locks |
Thanks Kolusu.
I will discuss with my team and DBA to apply page lock or row lock instead of Table lock. Also try to reorder the records to update in different order to avoid contention.
Mulli ... |
Topic: Issue with Table locks |
pkarthik@email.com
Replies: 2
Views: 4125
|
Forum: Database Posted: Fri May 17, 2019 1:04 pm Subject: Issue with Table locks |
Hi,
I have a table that has 8 million records. We are performing an initial load in a staging table with 30+ columns. we have 5 COBOL DB2 programs that are updating different columns in a row. DBA ... |
Topic: SOC7 Occured but No COMP-3 data type involvement |
pkarthik@email.com
Replies: 7
Views: 7450
|
Forum: Application Programming Posted: Tue Sep 06, 2011 10:58 pm Subject: SOC7 Occured but No COMP-3 data type involvement |
Hi All,
This is a existing program executing in production for several years .Failed un-expectedly twice in production last week.
1. C390-Array is defined as X(100).
2. SUB1 has no reference ... |
Topic: SOC7 Occured but No COMP-3 data type involvement |
pkarthik@email.com
Replies: 7
Views: 7450
|
Forum: Application Programming Posted: Tue Sep 06, 2011 1:25 am Subject: SOC7 Occured but No COMP-3 data type involvement |
We received below error.
The system detected a data exception (System Completion Code=0C7).
From compile unit BSP390 at entry point BSP390 at compile unit offset +00000DC4 at entr ... |
Topic: Selecting MAXIMUM and Minimum Value in DB2 |
pkarthik@email.com
Replies: 6
Views: 3708
|
Forum: Database Posted: Tue Jul 08, 2008 5:42 pm Subject: Selecting MAXIMUM and Minimum Value in DB2 |
Thanks JSharon,
I will follow this for all the queries |
Topic: Selecting MAXIMUM and Minimum Value in DB2 |
pkarthik@email.com
Replies: 6
Views: 3708
|
Forum: Database Posted: Tue Jul 08, 2008 5:40 pm Subject: Selecting MAXIMUM and Minimum Value in DB2 |
HI,
My Query is
SELECT F.CU_ITEM_NUMBER
, F.TU_SUFFIX
, MIN(F.PO_UNIT_COST)
... |
Topic: Selecting MAXIMUM and Minimum Value in DB2 |
pkarthik@email.com
Replies: 6
Views: 3708
|
Forum: Database Posted: Tue Jul 08, 2008 12:51 am Subject: Selecting MAXIMUM and Minimum Value in DB2 |
Hi,
I did not provide the where caluse.
I have different where clauses. So Getting two rows because of UNION.
To be simple. I require maximum of Union and Minimum of Union.
Regards,
Kart ... |
Topic: Selecting MAXIMUM and Minimum Value in DB2 |
pkarthik@email.com
Replies: 6
Views: 3708
|
Forum: Database Posted: Tue Jul 08, 2008 12:25 am Subject: Selecting MAXIMUM and Minimum Value in DB2 |
Hi all ,
I need a single row having the maximum of UNIT_COST and Minimum of UNIT_COST.
As I have two select clause. I am getting two seperate rows. Please helkp me in thsi regard.
SELECT F. ... |
Topic: Problem in Update Query |
pkarthik@email.com
Replies: 8
Views: 3972
|
Forum: Database Posted: Tue Nov 06, 2007 12:27 am Subject: Problem in Update Query |
Thanks Dick and Sharon.
SET ENT_QTY_CURRENT = 0
,ENT_VAL_CURRENT = 0
worked out well. |
Topic: Problem in Update Query |
pkarthik@email.com
Replies: 8
Views: 3972
|
Forum: Database Posted: Mon Nov 05, 2007 5:29 am Subject: Problem in Update Query |
Hi,
Please find my compile listig.
My code is as below.
1154 C4000-UPDATE-TABLES SECTION.
1155 EXEC SQL ... |
Topic: Problem in Update Query |
pkarthik@email.com
Replies: 8
Views: 3972
|
Forum: Database Posted: Mon Nov 05, 2007 4:39 am Subject: Problem in Update Query |
Hi,
I have to update selective rows in a table after performing an innerjoin.I am getting an error saying syntax error.Please help me in this regard.I am new to DB2.
Showing error in below set sta ... |
Topic: How to get current date using sort card??? |
pkarthik@email.com
Replies: 3
Views: 12102
|
Forum: Utilities Posted: Mon May 21, 2007 11:00 am Subject: How to get current date using sort card??? |
Hi Kolusu,
Sorry I didnt get exactly how the date can be got from the syste, using sort card. Can you pls expalin me breifly?? . I would be a great help for me.
Cheers,
Karthik P |
Topic: How to get current date using sort card??? |
pkarthik@email.com
Replies: 3
Views: 12102
|
Forum: Utilities Posted: Mon May 21, 2007 10:30 am Subject: How to get current date using sort card??? |
Is there any possibility to get current date from the system using sort card without writing a cobol program.
Can any one help me out with this??? |
Topic: How to remove a Hex char from a variable length file |
pkarthik@email.com
Replies: 2
Views: 2347
|
Forum: Job Control Language(JCL) Posted: Thu Oct 12, 2006 10:41 pm Subject: How to remove a Hex char from a variable length file |
Hi, we have a requirement to remove a hexadecimal value which might appear at any position in a variable length record. sample given below.
Here is an extract :
:21S:ABCDE
:21R: ... |
Topic: Linkage section signed number passing |
pkarthik@email.com
Replies: 6
Views: 3388
|
Forum: Application Programming Posted: Thu Jun 08, 2006 10:28 pm Subject: Linkage section signed number passing |
Could you please expalin me how come 23M=-234. |
|