CULPRIT / SQL Add Rows Example

Document ID : KB000093235
Last Modified Date : 17/08/2018
Show Technical Document Details
Question:
Is there an example of how to CREATE an SQL Table using Culprit?
Answer:
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 
/* '' 
Additional Information:
https://docops.ca.com/ca-idms/19/en/using/using-ca-culprit-for-ca-idms/creating-new-sql-data-tables