473,396 Members | 1,774 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Temporary table issue on mainframe Db2

1
I am having an issue with the temporary tables. My stored procedure has
two temp tables,the stored procedure is invoked by Java. When we call
the Storedprocedure for one instance it works fine,when the the stored
procedure is invoked by two different people at the same time it does't
provide the resultset properly,the result set with less data closes and
provide less values,it is picking up the same cursor values for the two
calls.

We tried creating runtime names for the temp tables and tested,there
was no change. Please advise.

Temp table dec

Expand|Select|Wrap|Line Numbers
  1. DECLARE GLOBAL TEMPORARY TABLE WV-TEMPLOC 
  2. CONCERN_ID CHAR(12) NOT NULL 
  3. ,CONCERN_STATUS_CD CHAR(8) NOT NULL 
  4. ,CONCERN_TITLE_TX CHAR(50) NOT NULL 
  5. ,CONCERN_DESC_TX_ VARCHAR(250) NOT NULL 
  6. ,NO_OF_DAYS_OPEN SMALLINT 
  7. ,SEVERITY_RATING CHAR(3) NOT NULL 
  8. ,OPEN_DT CHAR(10) NOT NULL 
  9. ,MONITOR_DT CHAR(10) NOT NULL 
  10. ,CLOSE_DT CHAR(10) NOT NULL 
  11. ,ATTACH_DESC VARCHAR(620) NOT NULL 
  12. ,RES_DES_CODE VARCHAR(820) NOT NULL 
  13. ,CONCERN_STATUS_SUMMARY VARCHAR(250) NOT NULL 
  14. ,R1000_CNT VARCHAR(500) NOT NULL 
  15. ,R1000_TOTAL DECIMAL(9, 4) NOT NULL 
  16. ,CPU_CNT VARCHAR(500) NOT NULL 
  17. ,CPU_TOTAL DECIMAL(9, 4) NOT NULL 
  18. ,IQS_CNT VARCHAR(500) NOT NULL 
  19. ,IQS_TOTAL DECIMAL(9, 4) NOT NULL 
  20. ,EMQF_CNT VARCHAR(500) NOT NULL 
  21. ,EMQF_TOTAL DECIMAL(9, 4) NOT NULL 
  22. ,GQRS_CNT VARCHAR(500) NOT NULL 
  23. ,GQRS_TOTAL DECIMAL(9, 4) NOT NULL 
  24. ,SAQ_SCORE DECIMAL(9, 4) NOT NULL 
  25. ON COMMIT PRESERVE ROWS 
  26.  
  27. DECLARE GLOBAL TEMPORARY TABLE WV-TEMPLOC1 
  28. CONCERN_ID CHAR(12) NOT NULL 
  29. ,SEVERITY_RATING CHAR(3) NOT NULL 
  30. ON COMMIT PRESERVE ROWS
Apr 14 '10 #1
0 1144

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Chris New | last post by:
G'Day All I am having trouble dynamically assigning a value to a table's cell from one frame to another frame. I've created a website that is primarily viewed in a frameset consisting of 2...
2
by: airkart | last post by:
Hello, I've scoured groups and the web, and haven't found a question like mine answered. I'm using Visual Studio 2003 with the Crystal Reports it comes bundled with and SQL Server 2000....
3
by: JBH | last post by:
I'm having difficulty removing spacing between two rows in a table. Below is a copy of my source code <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>About...
5
by: Adam W. Saxton | last post by:
We have a few existing stored procedures which create a Global Temporary Table (##), do some work on the table and then delete the table. The issue we have is that if our Server application is...
2
by: Phil Endecott | last post by:
Dear PostgreSQL experts, I have encountered a problem with temporary tables inside plpgsql functions. I suspect that this is a known issue; if someone could confirm and suggest a workaround I'd...
3
by: pinney.colton | last post by:
I would like to create a stored procedure which creates a temp table to store some XML. The # of fields of XML is dependent upon the contents of another table in the application, so the first part...
8
by: BerkshireGuy | last post by:
Hello everyone. I have a ADODB recordset that uses a connection string to connect and grab data from our mainframe. Had worked great in the past. Then - I ran the same module the other day...
5
by: Rahul B | last post by:
Hi, I have very little knowledge about creating Procedures/functions in DB2. When i tried to create the test function like CREATE FUNCTION GET_TEST (P_TEST_ID INTEGER, P_SEL_OR_SORT...
1
by: popwhub | last post by:
I am having problems printing some reports from my application that are generated from temporary tables. The application has an Access FE and a SQL Server BE. The current method uses a temporary...
4
by: sandeep.iitk | last post by:
Hi, One query is failing on the database and its a long query which was running fine earlier. One possible reason we can think of is increase in data in tables in query. It is failing with...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.