devxlogo

Populating Databases

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.

See also  How to Avoid Money Transfer Scams  
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist