Thread: help me on procedure syntax error...

I never work with PLSQLDev and no have idea what it is capable... But, to tunning a SQL with Informix, you just need to enable the SET EXPLAIN command. Check the manual for more information: IBM Informix Dynamic Server v11.50 Information Center If you want a grafical environment, maybe the OpenAdminTool can help you,...

Can you please tell me how to use foreach in this example and also how do i grant & execute this procedure

Code: EXIT=1 while [ $EXIT -ne 0 ];do scp ... EXIT=$? done Regards, Hans

Dear Sir I pleased you to tell me which are crontab variables environment to be set up in my script so that i have right result. This is my crontab: 30 16 * * * /home/ope_for.sh "everyday at 4'30mn the crontab launch the script ope_for.sh which it self launch dbaccess my_database and execute the query ope_for_new Thanks

Hi ceinma, Thank you for you response, you can say me the link where is the information about installing informix in cluster, I have not experience installing informix in cluster. Thank you for you help.

please help me on this part of code...is there any problem for using a variable in skip...please help me.. WHILE i < var_column_length select skip i first 1 colname from syscolumns into var_column_name where tabid=(select tabid from systables where tabname=var_table_name) ; SELECT ar_pk_id ,ar_alert_id,ar_l_table_name,ar_l_field ,ar_r_table_name ,ar_r_field INTO var_ar_pk_id,var_ar_alert_id,var_ar_l_table_name,v...

@ceinma Thanks for all your hard work and help! The "magic way" is definitely the direction I'll go. I suspect that it will be faster too.

Quote: Originally Posted by ceinma Can you easily export all data of each table to flat files, using delimiters? like this: col1|col2|col3|... if your answer is YES, just create the table in Informix database and use the LOAD command to load the flat file to Informix. use the search if wish.. You should be able to. I do this the other way around - moving a chunk of data from informix to mysql. Mysql.... SELECT a,b,a+b INTO OUTFILE...

Hi, thanks for your help on this. The output(s) I posted was a only a sub set of the reults. The end result will hold many more rows. In the millions I believe... >> Did you read the file generated by the dbaccess via output? I think the output on both occasions are in the same format...... ------------------------------------------------ >>looking your outputs, the UNLOAD is faster: >> Quote: 0. 0 1....

Hello, I have been looking for a data integration / transfer program able to help with Informix. I have had some advice but have not found the right software yet. The main feature is being able to migrate important quantities of contacts and data on a daily basis. The migration would be done manually. Thank you for your help!