I am running COBOL-DB2 batch (version 7.0 DB2) in Z/OS -OS390.I see very little documentation - in particular, illustrative examples, of the DESCRIBE TABLE syntax and what exactly gets populated to the SQLDA when the command is issued.In the following example (simplified from my current program whic ...
What is the equivalent of Describe table of Oracle in SQL server.I want to see the table fields for a table in SQL server any command?????TIA ...
in db2, oracle, we can get the schema of table by sql like:"describe table table_name",for informix, we can not do that, while the only way is to use dbaccess?disappointed!not sure, but possibly, "describe " is in sql standard 2003, right? ...
Hello, i would like to make a question related to Describe table, I have a table which has its primary key (dvd_r_id) and a foreign key (pc_id). mysql> describe dvd; +--------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+---- ...
I would like to use the DESCRIBE TABLE command in php to display table info. Any ideas how to do this? ...
does anyone know why when i send a "DESCRIBE table" query to MySQL its telling me i have a syntax error, I tried to the same code directly on the database not using PHP and it worked.. so im a lil confused! lolhelp. ...
I was trying to alter the name of a field from 'relate_id' to 'block_id' in a table, called 'protocols', using the following statement: ALTER TABLE protocols CHANGE COLUMN relate_id block_id smallint(5) UNSIGNED; Now when I use DESCRIBE protocols;, I receive the following error: Unknown column 'rela ...
I am new to mySQL. I installed mySQL 5.0.2 . I created a table in "mysql" database and when i use DESCRIBE tableName the server stops giving error message "mysqld.exe has encountered problem". This describe tableName command is not working for any of the already exisitng tables o ...
I am writing a procedure which takes tablename as input and displays columns present in table as output. How to describe a table inside a plsql procedure. Also how to display the columns, since each table will be having different number of columns. Please suggest. ...
All,We've a scenario where two separate db servers have the same table structures. For example, server A and server B each have Table A with columns A, B, and C. When running DESCRIBE on each, the output from server A returns A, B, C, however, the output from server B is B, C, A. Both create table s ...
this query runs and i get the resultsselect *from t_misure_ee@anubiswhere rownum < 4but this query does not runsDESCRIBE t_misure_ee@anubishow can i get the description of the table t_misure_ee? ...
Hi, is there a sentence in db2 as400 that shows a table structure like "desc <table>" in Oracle? ...
Gurus,I need to get Table Schema from JDBC. I tried using following, but no luck....stmt = conn.createStatement();ResultSet rs1 = stmt.executeQuery("desc mytable");while ( rs1.next() ) { //line 36System.out.println(rs1.getString(1));}Here is exception:java.lang.NullPointerExceptionat creat ...
Describing a table, how can I set the columns width i.e.Name etc. ...
i want to know the primary key of the table. let say, when i : desc t_usg_bci;i got the output like this :Name Null? Type SERIAL_NO NOT NULL NUMBER(6)CALL_TYPE NOT NULL CHAR(3)BILLING_CLASS_CODE NOT NULL CHAR(1)SERV_TYPE NOT NULL CHAR(3)SERV_CLASS NOT NULL CHAR(1)DAT_CODE CHAR(3)BCI NOT NULL CHAR(8) ...
If I understand this correctly, the DESCRIBE command can't be used in a stored PL/SQL procedure. If that is true, what PL/SQL statements could be used to describe several tables, say T1, T2, and T3? ...
I need to get information about a table in Oracle. In SQL Svr or Sybase I would use sp_help that displays all relelvant info about a table. What command or query could do the same thing in Oracle 10G? ...
When I use descr table I got a slow answer. Using sqlplus I got a slow answer making a query to. The others clients sqlplus work fine (very fast). I have a Computer with 2GB RAM and 60GB HD free, pentium 2.66GHz and XP. This configuration is the same that run in others clients computer.AR ...
Basically what the title says. The "Describe" function, or what every you would call it, isn't exactly slow. Don't get me wrong. However, in ratio to a SELECT query, it's about .001 seconds slower. Maybe I'm just anal when it comes to fast load times, but I would like for the quickest poss ...
I have a problem with the new MySQL 5.0.2: when trying to describe a table with the command DESCRIBE table_name MySQL loses connection and the service needs to be restarted, obvioulsy without having the requested description. Bug? Newbie error? ...
Sometimes you'll need info about a table:- in which tablespace does it reside?- are there any views/triggers/etc defined?- howmany rows?- are all indexes really required by DB2?So I created a "generate script SQL". You run this SQL, capture the output in a file and edit this file (prefix: ...
i have this command show fields from <table> describe <table> show columns from <table> these 3 will show the fields and its properties what i want is to show the fields but "with the type datetime only" to know what fields are for date.. can u help me? ...
I'm afraid this DB2 forum seem pretty much dead with not much activity for my question to be answered. So, my question here is what's the DB2 equivalent for the MySQL's command for "DESCRIBE <table name>". Or does it work?I tried this "describe table <table name>" and ...
Everyone :Is there a way to print a table's structure. I'd like something similar to the DESCRIBE <table> information. Thanks for the help.Sincerely,Dale Williams ...
Everyone :Is there a way to print a table's structure. I'd like something similar to the DESCRIBE <table> information. Thanks for the help.Sincerely,Dale Williams ...
Hi, is there any way to describe table metadata in ISQL like Oracle's 'describe TABLENAME' ? ...
I have a problem to open and/or describe table. The errors I had aremysql_stgssl>desc ATL1_USER_DETAILS_VW;ERROR 1356 (HY000): View 'atl1.ATL1_USER_DETAILS_VW' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use themmysql_stgssl>select * from A ...
This is pretty simple to describe:Table A & B both have a date field. I need a query/procedure which will do:SELECT A.date, { max(B.date) where B.date < A.date}Example: A.date B.date ====== ====== 10/10/2006 01/01/1999 01/04/2007 12/12/2006 Result: A.date Max B.date < A.date ====== ======= ...
Does anybody know of a way to allow a user to view the structure of a table using something like 'describe table_name' but not have the ability to view the actual data in the table? I have tried to just give the user create access but 'describe' and 'show columns' fail unless I also give select acce ...
How do I peform the MySQL "describe TABLE" function using PHP? Thx ...
Can I retrieve a tables Field and Type elements via PHP using describe $table?I am trying to dynamically set the sizes a forms text inputs to equal those of the columns in the database. Examplemysql databasename varchar(30)forminput type="text" size="<?name varchar size?> ...
I know descrbe table in mysql.Is there anyway to return the actual CREATE TABLE string that would create the given table, or do I need to run DESCRIBE table [name], parse it out, and build the CREATE command.I'm wanting to copy a table quickly, to another equal table with a different name. ...
is there any way to get all field names in a mysql resultset when table is empty and inner join was used?ex:sql = 'select * from mytable inner join othertable on leftval=rightval';$result = mysql_query($sql);$i = mysql_num_fields() // returns false when no results// describe table doesn't work for i ...
Is it possible to do a select on a describe? It seems that it would not be so difficult. I am trying to do something along these lines, although this syntax is obviously incorrect.... select * from (describe table_name) where Field='some value' I am really just wanting to check if a field exists in ...
First off, I'm a real greenhorn so please forgive me asking questions which may be bleeding obvious, but I have searched and searched and cannot find an answer to my problem.I'm trying to import a CSV file into sqlite3 database in python. The CSV file has 56 columns though. Is there any way to creat ...
i need to be able to show general information tables in my database.i currently do a 'show tables' query to get the name of each table in the db.for each name i do a 'describe table' query to get more detailed information.however, i am having trouble looping through the array (it returns field names ...
ORA-01758 table must be empty to add mandatory (NOT NULL) columnCause: It is not possible to define a new column as NOT NULL if rows already exist in the table being modified.Action: Retry the statement without the NOT NULL specification.SQL> describe TABLE_AName Null? Type -------- COL_1 NOT NUL ...
Is there a table that contains all column names in other tables? like the column 'table_name' in user_tables.I know describe table can view the column names in a table, but I want to be able to select the column names. ...
It is known that "Describe table" gets the table definition.Is there a way to get the table definition sql script that already used to create the table itself (or may be created using enterprise manager) ? ...
1. i got a material table wich contains the article number, a quantity input field, a max quantity field... How can i test that the input quantity is less than the max quant one ?2. The max quantity field has to be invisible so i have a hidden attribute for it. The problem is that the table shows an ...
I am getting two different types of errors when loading an external table. I know why they are happening and I need to know what needs to be done so the data can be loaded properly into the table.The data is being loaded from a text file and all of the data is being loaded as text. First off, execut ...
I have 198 tables in a schema.I want to spool the output of describe table_name command.need a script. ...
Pls advise how to write a query whereas the return result is the column name.I know there is describe <table_name>;Is there any other ways?Pls adviseTjEdited by: user600866 on Oct 14, 2008 12:13 AM ...
I got a small question here.The question is regarding the column formating in SQL prompt.basically we can use DESCRIBE <table_name> to see the columns existed in a table.the column headers appear are "Name", "Null", and "Type"if you don't do any linesize and pagesize setting, the result of the ...
In ApEx 3.2 -- is it my imagination, or is it not possible to describe a table through a database link in the SQL Workshop?describe table_name@dblinkis perfectly acceptable syntax, and I can select from that table just fine, but when I go to describe the object, SQL Workshop keeps telling me "Object ...
it might be a stupid question, but I have problem showing information in a table... when I use the command "select * from table" it prints out all information. When I try to print specific fields, I have problems with two columns. "describe table" gives me the names of the column ...
I wanted to describe the table. DESCRIBE TABLE SCHEMA.TABLENAMEbut i am getting an error:DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "HESSDB2W". SOME SYMBOLS THATMIGHT BE LEGAL ARE: :DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODEDSNT415I SQLERRP = DSNHSMS1 SQL PROCEDURE DETECTING ERRORD ...
We suddenly started facing this problem after the database restart yesterday. Before that everything was working fine. problem is as follows: We have a table and it's definition is as follows:************************************************** ********************db2 => describe table RuleColumn T ...
I invoke the SQL statement of "insert into session.temp_tab select sdate,CDWBH,IHYLB1,sum(IFDL),sum(IGDL),sum(IPDL),s um(IDLHJ) from im.dl_origin_a group by cube(sdate,CDWBH,IHYLB1)" in my SQL procedure. DB2 returned the -802(SQLCODE) code. The structure of im.dl_origin_a is$ db2 describe ...
Iam using DB2 8.1 version on solaris.When iam trying to describe table iam getting the SQL1225N error,can anybody help me in this matter will be appreciated.. ...