Hi - Need help to create SQL table with multiple field reference files and identity

["Gangasani, Bhargava" <Bhargava.Gangasani@xxxxxxxxxxxxxx>]

> Hi,
>
> I need to create a SQL table by using multiple field reference files
> in which one of the reference file has identity column. My requirement
> is to get the identity column attributes also to the target file along
> with the definitions of other fields from other field reference files.
>
>
> When I have run the following create table statement:
>
> CREATE TABLE ICIWRKLXP/E0TFTBLP5 (E0TRDT,     
>       E0TRNO, E0EXPT) AS                      
>       (SELECT A.TRDT, A.TRNO, B.EXPT          
>          FROM FREFFIL A,                      
>       FREFFIL6 B) WITH DATA INCLUDING IDENTITY
>
> The file  ICIWRKLXP/E0TFTBLP5 is getting created but the identity
> column attributes are not coming to  ICIWRKLXP/E0TFTBLP5. 
>
> Could anyone help me in this?
FREFIL6:
 	CREATE TABLE ICIWRKLXP/FREFFIL6 (                            
 	  EXPT INT   NOT NULL GENERATED ALWAYS                       
 	  AS IDENTITY (START WITH 1 INCREMENT BY 1 MINVALUE 1 NO     
 	  MAXVALUE CYCLE NO CACHE ORDER))                            

FREFIL:

It is normal table with  TRDT 8 CHAR.   TRNO 7S 0.

> Thanks,
Bhargava.

2009 Winner: Broadridge receives ?Top Overall Honors" for 2 consecutive years in the Black Book of Outsourcing Brokerage Process Service Provider Survey.  Learn more at http://www.broadridge.com/ranked1/



?THANK GOD IT?S MONDAY!? Sounds interesting? Know more @ www.broadridge.com.


This message and any attachments are intended only for the use of the addressee and
may contain information that is privileged and confidential. If the reader of the 
message is not the intended recipient or an authorized representative of the
intended recipient, you are hereby notified that any dissemination of this
communication is strictly prohibited. If you have received this communication in
error, please notify us immediately by e-mail and delete the message and any
attachments from your system.