CULPRIT / SQL Add Rows Example
Article ID: 93235
Updated On:
Products
IDMS
IDMS - Database
IDMS - ADS
Issue/Introduction
Is there an example of how to CREATE an SQL Table using Culprit?
Environment
Release:
Component: CULP
Component: CULP
Resolution
Sample of CREATE TABLE syntax
//SYSIN DD *
IN DB SS=EMPSS01
PATH01 DEPARTMENT EMPLOYEE
01OUT SQLTABLE=JEXTABQ TYPE=CREATE DICTIONARY=SYSDICT SCHEMA=DEMOEMPL
010 NULL-INDICATOR 0
0151*010 EMP-ID-0415 FZ SZ=4 NOT NULL
0151*020 EMP-FIRST-NAME-0415
0151*030 NULL-INDICATOR FB SZ=4
0151*040 EMP-LAST-NAME-0415
0151*050 NULL-INDICATOR FB SZ=4
0151*060 DEPT-ID-0410 FZ SZ=4 NOT NULL
/* ''
//SYSIN DD *
IN DB SS=EMPSS01
PATH01 DEPARTMENT EMPLOYEE
01OUT SQLTABLE=JEXTABQ TYPE=CREATE DICTIONARY=SYSDICT SCHEMA=DEMOEMPL
010 NULL-INDICATOR 0
0151*010 EMP-ID-0415 FZ SZ=4 NOT NULL
0151*020 EMP-FIRST-NAME-0415
0151*030 NULL-INDICATOR FB SZ=4
0151*040 EMP-LAST-NAME-0415
0151*050 NULL-INDICATOR FB SZ=4
0151*060 DEPT-ID-0410 FZ SZ=4 NOT NULL
/* ''
Additional Information
https://docops.ca.com/ca-idms/19/en/using/using-ca-culprit-for-ca-idms/creating-new-sql-data-tables
Feedback
Yes
No
Powered by
