SQL-Script question
Posted in 1995
Topics: General Discussion
I'm currently using Informix Online together with ISQL. I can't solve a simply problem: I've a database with 89 records and I want to add a new column with inventory- numbers. The first value should be 800 and the last one 888. The type of the new column could be Smallinteger but not Serial. I want automatically fill out this new column with the values between 800 and 888. Who knows the solution of this simply problem with ISQL? //// (o o) -------------------o0o.-(_)-.o0o----------------------------- // Toralf Hauspurg II \\_\\_\\_\\_ \\_ \\_ // // Stadtverwaltung Jena II \\_ \\_ \\_ // // PF 100338 II \\_ \\_\\_\\_\\_ // // 07703 Jena II \\_ \\_ \\_ // // Tel. 03641 494231 II \\_ \\_ \\_ // ------------------------------------------------------------- o00o o00o