MVSFORUMS.com

[Prasantha Kumar]

hi all,
i am new to this forum. my name is Prasantha Kumar Balasubramanian from Bangalore, India. Well, i shall get to my poin now.

I am trying to execute a Pl/1 progrm which has embedded SQL statements in it. Precompile, Compile and Link-edit of the program gives a return code of 0 which means that it is normal. When it comes to execution of the code with the JCL, I get a weird MAXCC = 1000 what does it mean? debugging the program shows that the error occurs when executing the very first SQL statement. I used a PUT SKIP LIST (display) on the SQLCODE immediately after the SQL. But I didnt get the line displayed in the output. So, I think there is some problem related to the SQL. If anyone has copme across such code pls reply this mail. It is very urgent and a suitable response will be apreciated.

[kolusu]

Prasantha kumar,

We cannot provide any help without looking any error messages. Can you post your sysout error messages? Just a guess did you BIND your program/plan after the link-edit?

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[Prasantha Kumar]

hi all,
I went deeper into the code and debugged it. I found that i het a ONCODE of 8094 when the first SQL CODE is executed. The SQL is as follows:
EXEC SQL
SELECT CURRENT DATE FROM :ADATE1 FROM (a single row table);
This is embedded in the Pl/1 program as the first one. Any idea why this ONCODE occurs? (referring a PL/1 in a book, it is a Protection Exception). Do you also know how it can be solved?? The SYSOUT error message is as follows:

ONCODE=8094 Protection exception
From compile unit TTCIRP7 at entry point TRIGGER_CHECK at compile unit offset +233019C8 at entry offset
+232FA59C at address 3A451018.

[Prasantha Kumar]

hi,
i also get an ONCODE error 8096 for some other programs. This too appears like 8094 i.e. when the first embedded SQL in a PL/1 program is encountered. The SYSOUT is :

ONCODE=8096 Specification exception
From compile unit XXXXXXXX at entry point XXXXXXXX at compile unit offset +49731777 at entry offset +4973176F
at address 608812FF.

Here, XXXXXXXX is the program name. Please consider this state also. Any suggestion how the ONCODE's 8094 as well 8096 can be eliminated in case of a PL/1 program uses embedded SQL and the first SQL statement in the progrm flow throws the above said ONCODE's?

[kolusu]

Prasantha Kumar,

hmm I assume that the SELECT CURRENT DATE FROM :ADATE1 FROM (a single row table); is a typo. The select statement shold be an INTO a working storage variable.

[Prasantha Kumar]

hi,
But, I would like to tell you read the messages properly. I have told that the error is in a PL/1 program and not a COBOL program okay? Also the variable ADATE1 is declared as DCL ADATE1 CHAR(26) ; now pls look carefully and analyse these.

[kolusu]

[Prasantha Kumar]

hi kolusu,
why r u taking these as rude remarks?? these r palin okie? oh no its hard to ask u such questions!!! i am not rude any time okie? just look at the in a casual manner. well if my mails r not so polite to you, then tell mw how to address you? shall i call you as kolusu sir? well anyway, pls look at the mails in a casual angl. if i have been ude to you in this mail and the previous ones, i apologize to u. thank you

[kolusu]

prashantha kumar,

Please stop Chat/sms Language on this board.

I would really appreciate if you can stop using chat lingo on this board. This is not instant messaging on a cell phone or a chatroom. Please write your messages out clearly. There is no reason to use lazy abbreviations (y, u, coz, etc.) or to abbreviate sentences in a setting like this

[programmer1]

Prasantha Kumar,

It looks like that you are more interested in guaging ones patience than resolving your problem.

If you are planning to use foul language on me, please inform me in advance and I will take it casually
_________________
Regards,
Programmer