CREATE Table DDL - Null vs Not Null

[c6lapsteel]

Hi,

What determines whether a Null or Not Null will be added to column name attributes in the CREATE TABLE ddl definition? This seems slightly hit or miss. Is this determined by the data itself or can this be set somewhere?

Thanks,

[Opher]

I think they KEY and INDEX columns are set to NOT NULL.  I do not recall every seeing a way to set this for the other columns.

Good luck,
Opher

[rmcleod]

I think it is good practice not to allow decisionstream to set the DDL - it is best to call a ddl sql script stored in a dedicated DDL directory before the decisonstream build. This can be done with function or procedure - just string up the sql in a re-usable function


drop_create_table( $dbname_staging, 'HR_MedicalTestType_load' );

[c6lapsteel]

Good idea - can you give an example of how your function/procedure works? When do you call it?


Thanks