Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic Queries in StoredProcedure

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
Hello

In a stored procedure, I am using dynamic query. On exection of the stored procedure I am getting
SQL CODE -905.
When replaced the dynamic query with a static query the stored procedure works fine.
The stored procedure is defined with maximum ASUTIME i.e. 750000 service units.

Is there any other way to overcome -905 or to enhance performance of dynamic query?

Thanks
 
Status
Not open for further replies.

Similar threads

gdg1976
  • Locked
  • Question
extract rows with characters in char field
Replies
6
Views
334
gdg1976
gdg1976
gdg1976
  • Locked
  • Question
hi all, input TAB1 COL1
Replies
0
Views
168
gdg1976
gdg1976
ANGELDANY
  • Locked
  • Question
WEEK ISO with Dates in string format YYYYMMDD 1
Replies
4
Views
375
ANGELDANY
ANGELDANY
gdg1976
  • Locked
  • Question
db2 sql extract double rows (different in case sensitive) 1
Replies
6
Views
241
mikrom
mikrom
MohanV
  • Locked
  • Question
Using table functions in Query
Replies
5
Views
220
fredericofonseca
fredericofonseca

Part and Inventory Search

Sponsor

Back
Top