By name and hierarchical parent first or children first.Īrt S. If you need different ordering, myschema offers three alternatives. But, this is just a few anecdotal observations.ĭoes anyone know if it is necessarily so that 'dbschema' orders SPLs (of same name) by ascending procid?ĭbschema orders everything be it's object ID, yes. So far, I have observed that 'dbschema' dumps the SPLs in order of ascending procid. But I'd like to be clear that I am not trying to get my work done for free! Just wondering if there is any way to use existing tools to extract a database's SPLs (particularly overloaded SPLs) into individual files. I am truly grateful for the many previous responses in another thread. But, it never hurts to (first) make sure there isn't "lazier" way to do this. Or, I could program what I want by writing a script that also extracts the procid (to use in generating a unique name for the generated text files for each SPL) and also by using sed or awk to parse out the individual SPLs from the concatenated file, and create new ones, uniquely named, that each contained exactly one SPL. I realize I could break the SPLs out manually- there are only about 40 of them. is there an informix utility called dbschema which does this dbschema -t all -d databasename > schema. Of course, it wouldn't be the first time my mind has gotten me on the wrong track.) (The text differs from the syntax diagram, and I believe this is true for both the 12.X and 14.X published documentation. I could be missing something because of the inconcistency (I would go so far as to use the term "error") in the documentation for dbschema. Informix servers store a number of separate databases, each of which is a self-contained set of tables with its own system catalog. I don't see anything in the documentation for dbschema that indicates any way to disambiguate function/procedure names, or to force dbschema to generate a single file for each SPL. When encountering overloaded SPLs, dbschema concatenates all of the SPLs with the same name into a single text file. That works fine, so long as SPLs are not overloaded. I have used dbschema to generate individual text files for each SPL by rippling through sysprocedures and calling dbschema for each one.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |