Re: Columns in each table

You may want to download the pdfs for the documentation. There is also a documentation CD with all the manuals (the ones you saw at http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp). The good thing in the documentation cd is that there are some kind of pdf that index all the other pdf's; so if you try find for something it shows all the pdfs (documentation) that contains what you are looking for. Kinda cool. J. Larry Mehl escribi': > Jean -- > > Thank you for this URL. > > The Search field on this page got me to definitions for systables and > syscolumns. I will create a join of those 2 tables to get what I need. > > Larry > > > Jean Sagi wrote: > >> You didn't mention you database version but take a look into: >> >> http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.adref.doc/adref191.htm >> >> >> >> J. >> >> >> Larry Mehl escribi': >> >>> Jean -- >>> >>> Thanks. Are you suggesting that manuals will have a code example to >>> extract the system columns I need? If not, can you point me to code >>> that will do what I want? >>> >>> Also, can you tell me in what Informix component to enter such SQL code? >>> >>> Larry >>> >>> Jean Sagi wrote: >>> >>>> Look in the sysmaster database: systables, syscolumns, etc. >>>> >>>> Look at www.informix.com for manuals. >>>> >>>> There should be no problem using crystal with informix. >>>> >>>> >>>> J. >>>> >>>> -----Original Message----- >>>> From: "mehl@cyvest.com" <mehl@cyvest.com> >>>> To: informix-list@iiug.org >>>> Date: 7 Aug 2006 13:48:24 -0700 >>>> Subject: Columns in each table >>>> >>>> Hello -- >>>> >>>> I am a newbie to Informix, and will start a contract tomorrow to write >>>> Crystal Reports on an Informix db. >>>> >>>> Can anyone suggest SQL code to obtain the following information from an >>>> Informix database?: >>>> Table, Column, DataType, Length, Description (?) >>>> >>>> I use the following code in MS SQL Server >>>> SELECT >>>> SUBSTRING(table_name,1,20) AS "Table", >>>> SUBSTRING(column_name,1,30) AS "Column", >>>> SUBSTRING(data_type,1,13) AS "DataType", >>>> ISNULL(character_maximum_length, ' ') AS "Length", >>>> STR(numeric_precision) AS "Precision", >>>> numeric_scale AS "Scale", >>>> CONVERT(nvarchar(150), ISNULL(s.value, ' ')) AS Description >>>> FROM >>>> INFORMATION_SCHEMA.COLUMNS i_s >>>> LEFT OUTER JOIN >>>> sysproperties s >>>> ON >>>> s.id = OBJECT_ID(i_s.TABLE_SCHEMA+'.'+i_s.TABLE_NAME) >>>> AND s.smallid = i_s.ORDINAL_POSITION >>>> AND s.name = 'MS_Description' >>>> WHERE >>>> OBJECTPROPERTY(OBJECT_ID(i_s.TABLE_SCHEMA+'.'+i_s.TABLE_NAME), >>>> 'IsMsShipped')=0 AND >>>> table_schema = 'DBO' AND >>>> table_name NOT LIKE 'sys%' AND >>>> table_name NOT LIKE 'dtprop%' >>>> ORDER BY table_name, ordinal_position >>>> >>>> Can you also tell me in what Informix component to enter such SQL code? >>>> In SQL Server, for example, I could enter it in Query Analyzer or >>>> create a query in the Management Console. >>>> >>>> Thanks for any help. >>>> >>>> Larry Mehl >>>> >>>> _______________________________________________ >>>> Informix-list mailing list >>>> Informix-list@iiug.org >>>> http://www.iiug.org/mailman/listinfo/informix-list >>>> >>>> >>>> Jean Sagi >>>> jeansagi@myrealbox.com >>>> jeansagi@gmail.com >>>> >>>> >>>> >>> >>> >>> >> >> >