Re: Oracle/SQL Server and Informix Equivalent Command

Ray M wrote: > I am very familiar with both SQL Server and Oracle and have been using them > for years. But, now I am on a job where I have to do some work with Informix > (the accounting system is Prelude, which runs on UniData, which apparently > runs Informix). I am having trouble getting the equivalent commands to work > or to find them. What I need to do is export some tables and then pull them > into SQL Server. Here is the problem. The prelude system does not store the > tables as SQL compatible so they created this hokey ODBC dictionary and you > have to convert tables 1 at a time to an ODBC view. The views do not > resemble tables at all really, what happens is a table that gets converted > to a view, you end up with like 20 seperate views that are like 1 view per > column in the underlying table (I am using Visual Schema Generator). I can > do a SELECT * FROM [table] TO '/home/datadump/tablename.dmp' but, I am > confused. I thought I could do a LISTDICT [tablename] but the format is not > very clear. I cannot get the format to just give me a dump with no > linebreaks so I can pipe it to a text file (the reason being, I have to > create an equivalement SQL Server table). I tried CLEAR COLUMN; but that did > not correct it. So, my question is this. If I was in Oracle I would issue > the following commands I thought Unidata was another RDBMS. If you DO have an Informix RDBMS that doesn't have an SQL interface, I can only imagine that it is written using C-ISAM. In both cases you are stuck with the proprietary interfaces. All the responses I have seen so far refer to extracting data through an SQL interface, which apparently you don't have. Not much help, but I fear you are stuck with the problem of manually extracting the data one table at a time. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list