Display the CREATE TABLE, CREATE VIEW, CREATE FUNCTION, or CREATE. Grant index on "informix".grupo_oper to "public" as "informix" Ĭreate procedure "informix". INDEX idxtime ON mytable (mytime) The options of the Informix dbschema utility. Grant delete on "informix".grupo_oper to "public" as "informix" Grant insert on "informix".grupo_oper to "public" as "informix" Grant update on "informix".grupo_oper to "public" as "informix" The dbschema Utility In This Chapter Syntax of the dbschema Command Database Schema Creation Creating Schemas for Databases Across a UNIX or Linux Network Changing the Owner of an Object Server-Specific Information User-Defined and Complex Data Types (IDS 9. 412 dbsdbs data spaces, Informix, 129, 131, 155 dbschema, Informix. Grant select on "informix".grupo_oper to "public" as "informix" 105, 106 DBA Oracle role, 102 dbassist utility, 8687, 87 inititialization. Revoke all on "informix".grupo_oper from "public" $ dbschema -t grupo_oper -p all -f sgc_var_param_var -d bhn dboutput.txt To see the table details, privileges for all users, details of the sgc_var_param_var procedure for the bhn database and have that contents saved to a file called dboutput.txt To see synonyms created by user informix on the bhn database displayed on the console:ĭBSCHEMA Schema Utility INFORMIX-SQL Version 7.31.UD6W9Ĭopyright (C) Informix Software, Inc., 1984-1998Ĭreate synonym "informix".syn1 for stores7demo:"informix".customer First suggestion Parse the dbschema with awk to join the lines until found a semicolon. hdbases201206 (seq,sitename) using btree filtering I consider two solutions 100 functional. so: select data from sysprocbody where procid in (select procid from sysprocedures where procname'') and datakey'T' order by seqno - Note that in older Informix, this would complain that seqno had to be included in the list of selected columns. create unique index 'informix'.ix1chdbases201206 on 'informix'. The text of the procedure is also in the sysprocbody table 'where datakey'T''. Procname is the stored procedure name or "all" for all stored proceduresįor information on views, issue the same command on the view instead of using the table name. You can get the contents of the stored procedures (the text) with dbschema: dbschema -d -f all or dbschema -d -f. Permissions granted to the user name or "all" for all users Synonyms created by the user name or "all" for all users Tabname is the table name or "all" for all tables Consider all the DB Objects Index, triggers, function, Stored procedure, synonyms etc are taken care for schema migration. You can use the SQL dbschema statement to get this information:ĭbschema You can use the SQL dbschema statement to get information about table structures, views, synonyms and UDRs.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |