Add to Favorites    Make Home Page 5458 Online  
 Language Categories  
 Our Services  
 FAQs Home  


Informix Commands FAQs

Home -- FAQs Home

A D V E R T I S E M E N T

Search Projects & Source Codes:

1. How to load the database from Unls(pipe delimited flat file)?

Ans: Use command :-

dbload -d -c -l log.txt -e 1 -n 2

Example:- dbload -d rbs -c uploadAllRBSTables.cnd -l log.txt -e 1 -n 2

cnd file should have the entries for all the tables which are to be populated like...

FILE acct_type.unl DELIMITER '|' 4; insert into acct_type;

FILE customer.unl DELIMITER '|' 23; insert into customer;

2. How to unload the database to Unls(pipe delimited flat file)?

Ans: Use command :-

unload to

Example:- unload to customer.unl select * from customer
where cs_src_appl_name='RBS';

3. How to use Joins in Informix?

Ans:

SELF JOIN:

Joining a table with itself is a self-join.

Example:-

SELECT A.Name, B.Name
FROM SalesReps A, SalesReps B
WHERE A.Mgr = B.Empl_Num;

INNER JOINS:

An inner join between two (or more) tables is the Cartesian product that satisfies the join condition in the WHERE clause. Example:-

SELECT O.City, S. Name
FROM Offices O, SalesReps S
WHERE O.Mgr = S.Mgr;

OUTER JOINS

To select all unmatched rows from A, the syntax is

SELECT A.Column1, B.Column2
FROM A LEFT JOIN B
ON A.Column2= B.Column2

To select all unmatched rows from B, the syntax is

SELECT A.Column1, B.Column2
FROM A RIGHT JOIN B
ON A.Column2= B.Column2

4. How do I create schema from existing informix database?

Ans: Use command :-

dbschema -d >cdb.sql

Example:-

dbschema -d cdb_database_name >cdb.sql

5.How do I create database from schema?

Ans: Use command :-

create database in with buffered log;

Example:-

create database cdb2 in dev_data_dbs with buffered log;

6. How do I Set the Buffered log?

Ans: Use command :-

create database in with buffered log;

Example:-

create database cdb2 in dev_data_dbs with buffered log;

FAQs Home||C++ FAQs

A D V E R T I S E M E N T




Google Groups Subscribe to SourceCodesWorld - Techies Talk
Email:

Free eBook - Interview Questions: Get over 1,000 Interview Questions in an eBook for free when you join JobsAssist. Just click on the button below to join JobsAssist and you will immediately receive the Free eBook with thousands of Interview Questions in an ebook when you join.

 Advertisements  

Google Search

Google

Source Codes World.com is a part of Vyom Network.

Vyom Network : Web Hosting | Dedicated Server | Free SMS, GRE, GMAT, MBA | Online Exams | Freshers Jobs | Software Downloads | Interview Questions | Jobs, Discussions | Placement Papers | Free eBooks | Free eBooks | Free Business Info | Interview Questions | Free Tutorials | Arabic, French, German | IAS Preparation | Jokes, Songs, Fun | Free Classifieds | Free Recipes | Free Downloads | Bangalore Info | Tech Solutions | Project Outsourcing, Web Hosting | GATE Preparation | MBA Preparation | SAP Info | Software Testing | Google Logo Maker | Freshers Jobs

Sitemap | Privacy Policy | Terms and Conditions
Copyright ©2003-2017 SourceCodesWorld.com, All Rights Reserved.
Page URL: http://www.sourcecodesworld.com/faqs/informix-commands-faq.asp


Download Yahoo Messenger | Placement Papers | Free SMS | C Interview Questions | C++ Interview Questions | Quick2Host Review