Data Conversion

Question:
What is the most efficient method of converting Informix data in a Unix operating system to text or dbf data in an NT operating system (size = 8GB)?

Answer:
Use dbexport to export all of the data in the database. It will output a series of text files delimited by the UNIX pipe ( | ) symbol.

To deal with just one table, a few tables or parts of a table, use the following SQL:

UNLOAD to "filename" SELECT 
																
																	
																		
																			
																				
																			
																		
																		
																			Submit a Tip
																		
																		
																			
																				
																			
																		
																		
																			Browse "Web Development" Tips
																		
																		
																			
																				
																			
																		
																		
																			 Browse All Tips

0 Comments (click to add your comment)

Comment and Contribute