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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: