MVSFORUMS.com

Just using Rexx, save all your resul members in a stem and when the loop

DO RECID=1 TO IN.0

has completed, create and write your output lines

Not that familiar with REXX, I know that I can u ...

wdnealis,

I think IDPFX option on batch version 3.15 would give you the desired results.

take a look at this topic

http://www.mvsforums.com/helpboards/viewtopic.php?t=8786&highlight=id ...

How can I write multiple values on the same line in the output file?

For example, when I search for a value, how can I get the memeber name and the results on the same line of an output file?

i. ...

I was trying to use Control Center to do a BACKUP, but I kept getting DB in USE. But the BACKUP from the CLP resolved the issue:

db2 backup database sample

Backup successful. The timestamp for ...

I think the problem occured when I tried a LOAD command from a file. The START DATABASE(SAMPLE) SPACENAM(USERSPACE1) ACCESS=FORCE command returns the following error:

SQL0104N An unexpected token ...

I've been looking through the threads to resolve the issus of removing a backup pending state from a tablespace. When I try, I get a message that the DB is in use or Table space access is not allowed ...

The COMMIT works fine.

Thanks again.

I'm adding to the MAX SQNCto make it unique.

That's a typo, it's an Insert into, that should be VALUES.

And the SQNC is incremented, but the resutl is -803 eventhough the displaty shows that the value was increased.

You old post on this topic mentioned that "You can only update a primary key if the table is a stand alone table(no child table) or the table is not partitioned.", so I tried the delete/inse ...

1. Yes.

2. no triggers, and this is the only table being update.

OCRNC is the number of occurences.

I have displays and the values do not exist, but when the insert or update is executed the result is -803.

No. All five columns are the key, and that's a date field, not TS. The update is to fetch and change all ERR_SW from '1' to '2', and the MAX SQNC is the only other field that changes on the key. Th ...

Hi,

I am fetching values and trying to update the Primary Key on a partitioned table, but keep getting a -803 SQLCODE. I also, tried a delete, insert, but the -803 is still occuring. Any ideas o ...

ok, here's the solution.

The IDCOMND ddname is the key as mentioned on the thread:
http://www.mvsforums.com/helpboards/viewtopic.php?p=10515#10515

This file will contain the LISTCAT command, s ...