dcsimg
Login | Register   
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


Tip of the Day
Language: Informix
Expertise: Beginner
Apr 11, 2000

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


Populating Databases

Question:
I am trying to populate the stores (demo) database with a SQL script through dbaccess. The script keeps on returning syntax errors. The script is as follows:
DECLARE status INTEGER;
LET status = 1;

WHILE status < 100000
   INSERT INTO stock (stock_num, description, unit_descr) VALUES (status, "AVX", "jkl")
   status = status + 1;
   if status >= 100000 THEN
      BREAK
   else
      CONTINUE;
END WHILE;
The product is installed and the demo database has been created successfully and can be manipulated. I have tried dbimport but have no data available to import!

Could you please inform me why this will not run? (I am using Informix OnLine Dynamic Server 7.31 on Sun Solaris 5.6.)

Answer:
This is a shell script, not a SQL script. There should be a file called "dbaccessdemo*" in $INFORMIXDIR/bin. Run this from a shell prompt and you should be OK.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date