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


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

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