• Home
• com.ibm.batch
• com.ibm.batch-runtime
• 1.0-b06
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

.com.ibm.batch-runtime.1.0-b06.source-code.jsr352-derby.ddl_DO_NOT_EDIT Maven / Gradle / Ivy

CONNECT 'jdbc:derby:RUNTIMEDB;create=true';

DROP TABLE JOBSTATUS;

CREATE TABLE JOBSTATUS (
  id		BIGINT,
  obj		BLOB
);

DROP TABLE STEPSTATUS;

CREATE TABLE STEPSTATUS(
  id		VARCHAR(512),
  obj		BLOB
);

DROP TABLE CHECKPOINTDATA;

CREATE TABLE CHECKPOINTDATA(
  id		VARCHAR(512),
  obj		BLOB
);

DROP TABLE JOBINSTANCEDATA;

CREATE TABLE JOBINSTANCEDATA(
  id		VARCHAR(512),
  name		VARCHAR(512)
);

DROP TABLE EXECUTIONINSTANCEDATA;

CREATE TABLE EXECUTIONINSTANCEDATA(
  id			VARCHAR(512),
  createtime	TIMESTAMP,
  starttime		TIMESTAMP,
  endtime		TIMESTAMP,
  updatetime	TIMESTAMP,
  parameters	BLOB,
  jobinstanceid	VARCHAR(512),
  batchstatus		VARCHAR(512),
  exitstatus		VARCHAR(512)
  );
  
DROP TABLE STEPEXECUTIONINSTANCEDATA;

CREATE TABLE STEPEXECUTIONINSTANCEDATA(
	id			VARCHAR(512),
	jobexecid	VARCHAR(512),
	stepexecid			VARCHAR(512),
	batchstatus         VARCHAR(512),
    exitstatus			VARCHAR(512),
    stepname			VARCHAR(512),
	readcount			VARCHAR(512),
	writecount			VARCHAR(512),
	commitcount         VARCHAR(512),
	rollbackcount		VARCHAR(512),
	readskipcount		VARCHAR(512),
	processskipcount	VARCHAR(512),
	filtercount			VARCHAR(512),
	writeskipcount		VARCHAR(512),
	startTime           TIMESTAMP,
	endTime             TIMESTAMP,
	persistentData		BLOB
);