MVSFORUMS.com

When I am trying to run Cobol/Db2 Batch Program getting this error.

00E73003
Explanation: The SQL statement coul ...

Hi Kolusu,

Thanks for your response.

I missed amount field in my earlier post. I added amt field, still i am getting the same error.

Thanks,
Prasad

Hi All,
I am getting syntax error when i am trying rank function.

Do we need OLAP Server to run?
Please clarify me..

My SQL:

-------------------------------------------------------------- ...

If you have Platinum tool then RC/Query will help you to see Parent/Child Relationships between the Tables

Hi Teja,

Try Declaring your linkage section like this:

01 LS-TYCD.
05 LS-TYCD-LEN PIC S9(4) COMP.
05 LS-TYCD-TXT. ...

See These Explanation: It may help you.. and ask your admin to restart your db2 environment..

DSNV086E DB2 ABNORMAL TERMINATION REASON=xxxxxxxx

Following is the detail ...

Try Like this:
INSERT INTO TABLE A
(SELECT * FROM TABLE B
where a.key <> b.key);

Hi Vallish,

Thanks for your response. I think rolbe/rolbi are specific to cics transactions. In this case db2 is trying to rollback to initial state(-911) and when it fails it is going for -913's. ...

Hi Himesh,

Thanks for your quick response..

I know why we are getting dead locks. Problem with -913, when dead lock occurs at 4 th sql first 3 sql's are committing(cobol/db2). We need system to ...

Hi All,
Good Morning..

In our application we are getting -913(Deadlock with no rollback) for any contentions. Because of this some transactions are committing. How we can get -911's(Deadlock with ...

Yes, you can use

Hi Coolman/Ravi,

Sorry for late reply.

Ravi:
Thanks for your solution.

Coolman:
I am looking for 2 fields like: Table Name and Column Name in this case table name is dt_pproj_loc and colum ...

Hi All,

I am able to get comment lines from my program using coolman solution.

Thanks to Everybody..

Kolusu,
I am not able to use your solution, one of the reasons is we dont have synctool a ...

Hi Kolusu,

Thanks for your response.

I can flatten into one member, do you have any rexx to get the desired output? Like Deleting the lines between 'PROCEDURE DIVISION' and next program start ' ...

Hi Ravi,

Thanks for your help..

FileAid is copying all the records(comment lines) which satisfying the above conditions. I need only comment lines before the procedure division. Do we have any o ...