Search results for query: *

Hi ALL, I had a set of file in cpio(in the source machine), they were grouped in a tar file, then extracted in the target machine. The system administrator has done all the transfert via ftp(the default mode i think binary). I transfered these files(from the AIX machine) in another machine (SCO...

Thanks for trying! Still the same Heading error: pax: myfile.unl : 0511-626 Lecture d'un en-tête de fichier incorrect. pax: myfile.unl : Passage au fichier suivant... PS: even if it is .unl (it was produced by a cpio -ocvB) Thanks KenCunningham.

Hello, I was working on SUNOS System with a cpio(cpio -icvB) to extract files performed from a SCO or UnixWare machines with the command : cpio -ocvB. ALL was rigth. NOw we 've migrated to a AIX Machine, the cpio command of the same files do not success(the error message is in french) : cpio ...

Hi mberni, i've used prepared statement when creating temp tables and i've no problem now. I did not tested yet your solution, but i will try it as soon as possible. Thanks mberni.

Hi olded, i've tried to drop the two temp tables before exiting the function with the same portion of code, but this works only the first time and i get the same problem after with also the second table, the first do not cause any problem! Anyway Thank you.

HI ALL, I'm using a temp table in a fucntion to store temporary results, but when calling the same function i've a problem saing that the temporary table already exist. What can be the cause and what is the solution? I use informix Online edition 11. in an AIX serever. the function begins with...

HI ALL, I'm using a temp table in a fucntion to store temporary results, but when calling the same function i've a problem saing that the temporary table already exist. What can be the cause and what is the solution? I use informix Online edition 11. in an AIX serever. the function begins with...

HI All, I want to create un XML file that contains it's XSL style sheet so i do not need to refer an extern XSL style sheet. Any help or examlpe. Thanks. ie: i 've tried this example, any correction is wellcome! <?xml version="1.0" encoding="ISO-8859-1"?> <?xml-stylesheet href="#style"...

It's TRUE. So i can create a function for eliminating the gap : -it inserts a calculated identifier if there is an empty place. -if not, it uses the regular insert. LIKE this : select max(serial_num) into max0 from mytable where serial_num < (select max(serial_num) from mytable) ; select...

Hi, This works to let the next serial numbers to begin with 1000 if there is no one greater than 1000. for example if i have : serial_num ------- 1 2 3 2500 ALTER TABLE my_table MODIFY (serial_num serial (1000)) would not affect the next coming serial_num (it will be 2501). Any way this may...

Hello, when using a serial column in a table, if i drop some of the last data lines inserted, can i fixe the value of the coming serials of this column? (not let a gap between the new and the existing lines in the serial columns). Thks.

Thanks PHV, i didn't understand : table_name su-id--- But now, i think - s: for select - u: for update - d: for delete - i: for insert thanks!

hello, any help about how to get the privileges affected to a user (select on tables, delete update...etc)

Hi, My "globals.4gl" is like this: ---------- DATABASE db_name globals DEFINE r_organ RECORD LIKE organ.* define rec1 ARRAY[32000] OF RECORD Like table1.* define rec2 ARRAY[2000] OF RECORD Like table2.* define rec3 ARRAY[32000] OF RECORD Like table3.* ... END GLOBALS ---------- THaNks FOr ANy Help!

HI all, One another thing is that in the development environment we use IDS 9. But in the production we use 7.3; Is any thing related to that? Best regards .

Hi olded and every Body, For sure i 've looked there! I found that in the 'globals.4gl' there is many records declared like this: define rec1 ARRAY[32000] OF RECORD Like table1.* define rec2 ARRAY[2000] OF RECORD Like table2.* define rec3 ARRAY[32000] OF RECORD Like table3.* ... I took the...

Hi everyBody, I have an application runing under Informix SE, i want to pass to Informix Online. When i run my '.mak' file containning all the source i need the compilation succeed and i get my '.4ge'. But when passing to the prodution server the '.4ge' obtained do not RUN. The ErRor message is...

when using the request in a single module it works, but in the global module it does'nt.(the tow formule work in a simple test code) thanks FOR ALL Ed.

Ok, In the first machine(A) i've requests like: select * from table into temp tmp_table select count(*) into counter from tmp_table -->counter is 10 for example. When i use this same code in the seconde machine(B) -->counter is 0 I 've to change my code like: req="select * from table into...

Hi, I 've a code that work in a machine (UnixWare, informix 7.), but when i use the same code in a second machine with the same caracteristics, all requests that return result in temporary tables must be prepared otherwise they don't work. Any Idea? Thanks to ALL.