Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: la46
  • Order by date
  1. la46

    cpio from a different machine

    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...
  2. la46

    cpio from a different machine

    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.
  3. la46

    cpio from a different machine

    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 ...
  4. la46

    Problem with temp table

    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.
  5. la46

    Problem with temp table

    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.
  6. la46

    Problem with temp table

    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...
  7. la46

    Problem with temp table

    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...
  8. la46

    Embeding XSL in an XML file

    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"...
    • la46
    • Thread
    • Replies: 0
    • Forum: XML
  9. la46

    Is there any way to re-initialize a serial column to a defined value?

    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...
  10. la46

    Is there any way to re-initialize a serial column to a defined value?

    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...
  11. la46

    Is there any way to re-initialize a serial column to a defined value?

    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.
  12. la46

    how to get all privillèges affected to a user!

    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!
  13. la46

    how to get all privillèges affected to a user!

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

    Problem when compliling a 4gl code from Informix SE to Informix Online

    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!
  15. la46

    Problem when compliling a 4gl code from Informix SE to Informix Online

    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 .
  16. la46

    Problem when compliling a 4gl code from Informix SE to Informix Online

    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...
  17. la46

    Problem when compliling a 4gl code from Informix SE to Informix Online

    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...
  18. la46

    Must prepare requests that return result in temporary tables

    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.
  19. la46

    Must prepare requests that return result in temporary tables

    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...
  20. la46

    Must prepare requests that return result in temporary tables

    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.

Part and Inventory Search

Back
Top