MVSFORUMS.com

1. shell command should be input in PARM, using PARM='SH your unix command' or
//STDPARM DD *
SH your unix command

2. BPXBATCH run shell comand, should start with SH
3. STDIN must be z/OS UNIX ...

try LS -l 1>STDOUT 2>STDERR

Thanks Frank and Kolusu, I'll try it.

Thanks Frank.

Is there a sample assembler user exit routine for "user exit address constant"?
simple sample code for #4.7.2.3 in the manual would be perfect.

I want to code a user exit to split one record to several records,
input
xxxxyyyy-------------------
xxxx - number of new records
yyyy - length of new records

e.g.

00030004ABCD1234EFGH

wi ...

query SYSIBM.SYSPACKDEP (If the DBRM bound to PLAN directly, query SYSPLANDEP)

SELECT DCOLLID, DNAME, DCONTOKEN
FROM SYSIBM.SYSPACKDEP
WHERE BNAME = your tb name
AND BQUALIFIER = your tb owner

You can run several DB2 subsystem in one MVS image, but be careful about the central storage usage.

I think you are talking about ICF user catalog. Why you think it's related to DSNZPARM? They are ...

i have a situation where ID gets created by adding 1 to the max of (ID) of table. when two users creating ID at the same time will get the same ID .since two parallel cics sessions read the same ta ...

DSN1COPY is more easier.
You don't need UNLOAD/LOAD.

use CASE, e.g.

select empid,
CASE
when sal1 > sal2 and sql1 > sal3 ... and sal1 > sal12 then sal1
when sal2 > sal1 and ... then sal2
...
END
from emptable

several options:
1. dynamical SQL - prepare SQL first
2. if - then, different stastic SQLs
3. get the column first, do calculation in your progrom
....

In the examples you show the offset as being x'20' and x'15' but the 'oF' is in positions 20 and 15. x'20' = 64 decimal and x'15' = 21 decimal.

the sample is not good, i should change it to bina ...

remove duplicates

select dbname, tsname, dsnum, max(TIMESTAMP)
from sysibm.syscopy
where timestamp < current timestamp - 3 ...

just noticed the 2nd requiement are any type

select dbname, tsname, dsnum, max(TIMESTAMP)
from sysibm.syscopy
where timestamp < curr ...

select dbname, tsname, dsnum, max(TIMESTAMP)
from sysibm.syscopy
where timestamp < current timestamp - 3 months
and ICTYPE ...