create aggregate appears in dbschema output

Posted in 2014

Topics: Storage & Space Management, Security, Permissions & Auditing

GILLES TCHAPPI — Thu, 15 May 2014 08:48:18 — source: IIUG Forums & Mailing Lists

Hi there, I've the following output when running dbschema on dataserver running on AIX box # dbschema -ss -d basename -t bkdetsws DBSCHEMA Schema Utility INFORMIX-SQL Version 9.40.FC9 Copyright IBM Corporation 1996, 2004 All rights reserved Software Serial Number AAA#B000000 create aggregate "f201466".group_concat with ( INIT = group_concat_init, ITER = group_concat_iter, COMBINE = group_concat_comb, FINAL = group_concat_fini ); { TABLE "bank".bkdetsws row size = 108 number of columns = 3 index size = 23 } create table "bank".bkdetsws ( chrono decimal(8,0), nlig decimal(4,0), mes char(100) ) extent size 30764 next size 1398 lock mode row; revoke all on "bank".bkdetsws from "public"; create index "bank".i0_bkdetsws on "bank".bkdetsws (chrono,nlig) using btree in idx1dbs ; create index "bnkcamf".i3_bkdetsws on "bank".bkdetsws (chrono) using btree in data1dbs ; Can someone, please, explain why this 'CREATE AGGREGATE' appears in my dbschema output ? Thanks in advance

↪ replying to GILLES TCHAPPI

Art Kagel — Thu, 15 May 2014 10:17:06 — source: IIUG Forums & Mailing Lists

The simple answer is that userid f201466 created an aggregate named group_concat in your database. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, May 15, 2014 at 4:48 AM, GILLES TCHAPPI <giltfr@yahoo.fr> wrote: > Hi there, > > I've the following output when running dbschema on dataserver running on > AIX > box > > # dbschema -ss -d basename -t bkdetsws> > DBSCHEMA Schema Utility INFORMIX-SQL Version 9.40.FC9 > Copyright IBM Corporation 1996, 2004 All rights reserved > Software Serial Number AAA#B000000 > create aggregate "f201466".group_concat with > > ( > > INIT = group_concat_init, > > ITER = group_concat_iter, > > COMBINE = group_concat_comb, > > FINAL = group_concat_fini > > ); > > { TABLE "bank".bkdetsws row size = 108 number of columns = 3 index size = > 23 } > create table "bank".bkdetsws > ( > > chrono decimal(8,0), > > nlig decimal(4,0), > > mes char(100) > ) extent size 30764 next size 1398 lock mode row; > revoke all on "bank".bkdetsws from "public";> > create index "bank".i0_bkdetsws on "bank".bkdetsws (chrono,nlig) > > using btree in idx1dbs ; > create index "bnkcamf".i3_bkdetsws on "bank".bkdetsws (chrono) > > using btree in data1dbs ; > > Can someone, please, explain why this 'CREATE AGGREGATE' appears in my > dbschema output ? > > Thanks in advance > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c36bb2e744e204f96d98f4

↪ replying to Art Kagel

GILLES TCHAPPI — Thu, 15 May 2014 12:00:08 — source: IIUG Forums & Mailing Lists

Hi Thanks a lot for your answer. Does this means any user defined object created in my database will have its ddl displayed in the dbschema output even if the user defined object is without report with the table passed as argument in the dbschema command ? Regards

↪ replying to GILLES TCHAPPI

Art Kagel — Thu, 15 May 2014 12:05:06 — source: IIUG Forums & Mailing Lists

It depends on the object type. In the case of user defined aggregates and casts, IB yes they are always printed. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, May 15, 2014 at 8:00 AM, GILLES TCHAPPI <giltfr@yahoo.fr> wrote: > Hi > > Thanks a lot for your answer. > > Does this means any user defined object created in my database will have > its > ddl displayed in the dbschema output even if the user defined object is > without report with the table passed as argument in the dbschema command ? > > Regards > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0160be4e184feb04f96f1be2

↪ replying to Art Kagel

GILLES TCHAPPI — Thu, 15 May 2014 13:37:52 — source: IIUG Forums & Mailing Lists

Hi, Thanks a lot for your anwser. Have a good day. Best regards