MVSFORUMS.com

I read an input file and write to an output file using a rexx.
The files are allocated in the JCL but DCBs are not specified / wrongly specified.

The record length of the output file needs to be ...

I have the easytrieve plus manual and have to use eZT+ with DB2. The manual does not contain any information on this. I did check other products in support connect and did not find anything useful und ...

Allow me to explain a little further.

My shop has all the production code inside a library master.
The signoff jobs in production are a bunch of rexx programes that execute CA-librarian batch ut ...

Hi

The CA manuals state that the -SCAN utility statement is a read-only function (Security adm guide). Also the user guide states that -SCAN does not enqueue the master file.(user guide)

This be ...

Hi

Is there a way to receive the sub-system ID in the application program?

i.e

DSN system(TDB2)
Run program(appl1) plan(appl1) lib(loadlib)
END

I want TDB2 to be available inside my prog ...

Hi

I have a customer table with

---------------------------------------
Acc_No. Customer_id Priority
----------------------------------------
(char10) decimal(9,0) ...

Hi
Can someone please post the similar cheat sheet for packed decimal values as well?
A link to the appropriate manual is highly appreciated.

Thanks

Thanks a lot for your reply.

I want to handle the 'DATA EXCEPTION' condition. i.e write record to error and read the next record.
Something similar to 'ON CONVERSION'. But the program abends on en ...

Hi

I have a PL1 structure of LRECL=4050, with a combination Bin fixed, Dec fixed, Char and Bit values. I need to check the physical integrity of the data before processing.(i.e) BIN & DEC value ...

Would it make a difference if you use CURSOR WITH HOLD option?

Hi

Can someone tell me if there is a diffeerence in performance between the following 2 queries?

Here index1 is a duplicate index and can have upto 25 duplicate rows.

1)
SELECT index1
...

Thanks for the details. I was encountering a Lock escalation condition for mass updates. Sorted it out alright. Thanks again

Hi
A little more clarification needed

1) If I execute
LOCK TABLE <NAME> IN EXCLUSIVE MODE;
UPDATE1
COMMIT1
UPDATE2
COMMIT2

Will the explicit lock on the table remain after COMMIT1?
...

I think sashi0505 problem was with his ACQUIRE and RELEASE bind option. Anyways thats a pretty old post.
And sarangadher , the commit will be performed for all operations.

When a plan which updates or inserts is executed DB2 performs temporary locks on the corresponding page and this accumulates as the control passes from the main to sub prog. The commit is performed on ...