|
View previous topic :: View next topic
|
| Author |
Message |
Appu
New User
Joined: 26 Apr 2010
Posts: 73
Location: India
|
|
|
|
Hello Team,
Please note that I am trying to run an XSLTRANSFORM procedure for DB2 from a PL1 program. But I am getting sqlcode -443 ; but the message in SQLERRM is not displayed fully. This is because the SQLCA in PL1 contains only 70 characters. How can I get the full error message seen. |
|
| Back to top |
|
 |
Akatsukami
Global Moderator
Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL
|
|
|
|
| DSNTIAR. |
|
| Back to top |
|
|
Appu
New User
Joined: 26 Apr 2010
Posts: 73
Location: India
|
|
|
|
Hello,
Thanks for the information. I have tried DSNTIAR as well; but I am still not able to get the truncated message from SQLERRM. The usage of DSNTIAR gave me the same info as SQLCA.
Eg:-
DSNT408I SQLCODE = -443, ERROR: ROUTINE SYSFUN.XSLTRANSFORM (SPECIFIC NAME
SYSFUN.XSLTRANSFORM) HAS RETURNED AN ERROR SQLSTATE WITH DIAGNOSTIC
TEXT SQLCODE: -16280 Content is not
DSNT418I SQLSTATE = 38000 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNX9CAC SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF'
What I really wanted was the truncated message contained in TEXT SQLCODE.
Please share your thoughts. |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
|
|
| Back to top |
|
|
Appu
New User
Joined: 26 Apr 2010
Posts: 73
Location: India
|
|
|
|
Hello,
This means that there is no other way i can see the rest of the truncated message ? Any other tool or option available ? |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
|
|
|
|
| What more message are you expecting in TEXT SQLCODE ? |
|
| Back to top |
|
|
Appu
New User
Joined: 26 Apr 2010
Posts: 73
Location: India
|
|
|
|
Hello,
As you could see above, the message gets truncated :
TEXT SQLCODE: -16280 Content is not
I want to see the rest of the message  . I understand this is not possible with the current declaration of SQLCA .. so checking if there is any other way .. |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
|
|
|
|
| Did you try displaying SQLERRM explicitly via program to assure there is something more also present ? And why do you think its not possible to have it within 70 bytes ? |
|
| Back to top |
|
|
Appu
New User
Joined: 26 Apr 2010
Posts: 73
Location: India
|
|
|
|
| You mean changing the SQLCA structure ? |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
|
|
|
|
| It seems TS does not pay attention to read the links shared.. |
|
| Back to top |
|
|
Appu
New User
Joined: 26 Apr 2010
Posts: 73
Location: India
|
|
|
|
First of all I am really doubted whether you all understood the issue.
I have already read the SQLCA strcuture and I know the message can hold a maximum of 70 chars. But from the message I got, i could see that it is getting truncated after 70 chars .. but contains some valid messages and I want to see if any option available by which i could see the truncated message .
I am not saying this from air, but I have tried the program and put a display of my SQLCA structure. |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| Did you read about the msg length field, and the message eventually containg x'FF'? Could that be reason for your problem? |
|
| Back to top |
|
|
Appu
New User
Joined: 26 Apr 2010
Posts: 73
Location: India
|
|
|
|
Hi PeterHolland,
Yes the tokens are separated by X'FF' and I have already pasted the whole 70 char message . So there is no way we can know what message has been truncated ? |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
|
|
|
|
There is a confusion for me here ,
1) How are you getting "TEXT SQLCODE: -16280 Content is not" message?
2) Are you saying that the above message is truncated then I see it is still <70 to count on?
3) Did you try checking WLM logs?
4) What happens when you used DSNTIAR and moved SQLERRM to a variable which is declared more than 70?
5) You may also wants to check,
| Code: |
SQL0443
Message Text: Trigger program or external routine detected an error.
Cause Text: Either a trigger program, external procedure, or external function detected and returned an error to SQL. If the error occurred in a trigger program, the trigger was on table &4 in schema &5. If the error occurred in an external procedure or function, the external name is &4 in schema &5. The associated text is &6. If the error occurred in a trigger program, the associated text is the type of trigger program. If the error occurred in an external function, the associated text is the text of the error message returned from the external function.
Recovery Text: Refer to the joblog for more information regarding the detected error. Correct the error and try the request again.
SQLCODE or SQLCODEs: -443
SQLSTATE or SQLSTATEs: 38xxx, 38501 |
|
|
| Back to top |
|
|
Appu
New User
Joined: 26 Apr 2010
Posts: 73
Location: India
|
|
|
|
1) By simply putting a PUT SKIP of SQLCA structure.
2)
| Code: |
SQLCA.SQLERRM='SYSFUN.XSLTRANSFORM.SYSFUN.XSLTRANSFORM.SQLCODE: -16280 Content i
EDDCC4EDDCDDD77EEECED4EEDEDCDECDDDFEEECED4EEDEDCDECDDDFEDDCDCC746FFFFF4C99A89A48
28331B2835994ED282645B723391526694F282645B723391526694F2833645A00162800365355309 |
As you could see , the message doesnt starts from 'TEXT SQLCODE' but the tokens are separated by X'FF' ( as correctly suggested by PeterHolland).
3) how to do that in a pl/1 pgm
4) the same as you have replied above :
| Quote: |
Also even if you are using DSNTIAR program , it will give you what is there in SQLCA the only added benefit is you can give your own error message to be displyed along with the SQLCODE as sample below,
|
. Also nothing much happens even if we move a 70 char field to a big length field
5) could you please tell me wht is specified as &4, &5 ? |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
|
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| @Rohit, and where did the TS state he is using LUW DB2? |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
|
|
|
|
| PeterHolland, Right. I would later saw it was for LUW so that may no more be useful for him. |
|
| Back to top |
|
|
Appu
New User
Joined: 26 Apr 2010
Posts: 73
Location: India
|
|
|
|
Finally with the help of DBA i could see the full length message.
There was an STC running for the Db2 from which I could get the full message .
Thanks all for ur suggestions. |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
|
|
|
|
| Wouldn't STC be a subset of WLM? And glad you found it. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| Quote: |
| Wouldn't STC be a subset of WLM? And glad you found it. |
NOPE 
STC is the type of task which determines it's characteristics
JOB,STC,TSO
see the appropriate zOS manuals
WLM is the catch all name for the component that handles the system resources assigned to a task
( in a ugly/inexact , but understandable word ITS PRIORITY ) |
|
| Back to top |
|
|
|
|
