Print Page - CREATE Table DDL

Title: CREATE Table DDL - Null vs Not Null
Post by: c6lapsteel on 19 Apr 2006 04:36:19 AM

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,

Title: Re: CREATE Table DDL - Null vs Not Null
Post by: Opher on 22 Jan 2007 05:19:23 PM

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

Title: Re: CREATE Table DDL - Null vs Not Null
Post by: rmcleod on 04 Feb 2007 04:28:20 PM

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' );

Title: Re: CREATE Table DDL - Null vs Not Null
Post by: c6lapsteel on 16 Feb 2007 03:30:51 AM

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

Thanks

COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: c6lapsteel on 19 Apr 2006 04:36:19 AM