| View previous topic :: View next topic |
| Author |
Message |
Sara1977
Beginner
Joined: 25 Apr 2004
Posts: 7
Topics: 4
|
 Posted: Wed May 12, 2004 1:24 am Post subject: DB2: Sequence Number in Plan |
 |
|
Hi,
We are using dump master. I got an abend message as follows:
The last SQL statement executed was an EXEC SQL SELECT , precompiler
sequence number 7435 for plan NCBBTCOS .
I want to know the respective SQL statement for 7435. Can I get it by querying any catalog tables?
Regards,
Sara.. |
|
| Back to top |
|
 |
bauer
Intermediate
Joined: 10 Oct 2003
Posts: 315
Topics: 49
Location: Germany
|
| Posted: Wed May 12, 2004 2:42 am Post subject: |
|
|
Hi Sara,
no idea about "DUMP MASTER", but in SYSIBM.SYSSTMT you find the precompiled SQL statements with an statement number. May be, this is the number then "DUMP MASTER" displays.
Hope this helps,
bauer |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
|
| Posted: Wed May 12, 2004 5:15 am Post subject: |
|
|
sara,
Can't you just re-compile the program and check the pre-complier listing for the statement? The catalog table which contains all the information regarding the sql statements in a program is SYSIBM.SYSSTMT table.
Try this SQL
| Code: |
SELECT TEXT
FROM SYSIBM.SYSSTMT
WHERE PLNAME = 'NCBBTCOS'
AND SEQNO = 7435
;
|
Check this link for a detailed explanation on SYSIBM.SYSSTMT table
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
