Hello,

... I presently run the DDL below on my Windows XP platform using a CMD
file containing:

DB2 -TVF ZJDDLDAT

... where ZJDDLDAT contains ..

CONNECT TO WCB3;
DROP TABLE DD10DATA;
CREATE TABLE DD10DATA (
CUST_NUMB CHAR(5) NOT NULL,
CUST_NAME CHAR(15) NOT NULL,
ABIGINT BIGINT NOT NULL,
TOTAL_CARS DECIMAL(3,00) NOT NULL,
ZU_FIELD DECIMAL(3,02) NOT NULL,
PRIMARY KEY (
CUST_NUMB
)
);
CREATE INDEX DD10DATA_I2 ON DD10DATA (
CUST_NAME
ASC);
INSERT INTO DD10DATA (
CUST_NUMB,
CUST_NAME,
ABIGINT,
TOTAL_CARS,
ZU_FIELD
)
VALUES(
'01357',
'ILBAMOR CONSTRU',
000010056,
941,
3.21
);

... to run this DDL on a z/OS platform, could someone please tell me
what the JCL should be, please, thanks,
Graham Hobbs

Take the DB2zOS manual or even better InfoCenter and look for DSNTIAD
http://publib.boulder.ibm.com/infoce...0_prodhome.htm

http://publib.boulder.ibm.com/infoce...2z_dsntiad.htm

Here is a good example - you might have to change the step/job/linklib
http://db2portal.blogspot.com/2006/0...e-program.html

On 12/05/2011 03:47 PM, Graham Hobbs wrote:

On Tue, 13 Dec 2011 21:27:26 +0100, nijdamf <nijdamf (AT) xs4all (DOT) nl> wrote:

Nijdamf,
Gotta say major thanks, will check all the refs.
Graham

Graham Hobbs <ghobbs (AT) cdpwise (DOT) net> wrote in
news:ja6ge794sd8ia164ds21rvc8ot6s3ornh1 (AT) 4ax (DOT) com:

<...>
Hi Graham,

I hope you are aware of the fact that DDL for DB2/LUW isn't exactly the
same as DDL for DB2/zOS ?

Cheers!

--
Jeroen

On 14 Dec 2011 23:58:14 GMT, TheBoss <TheBoss (AT) invalid (DOT) nl> wrote:

Jeroen,
... no, I had no idea:-(.
I will research this but offhand, given the seven I've used, CONNECT,
DROP, CREATE TABLE, PRIMARY KEY, CREATE PRIMARY INDEX, INSERT and
VALUES, could you say which syntax are NOT different.
Thanks
Graham