"Roy Souther" <[EMAIL PROTECTED]> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
0105301102010Q.28903@OlympusMons">news:0105301102010Q.28903@OlympusMons...
> I am testing my SQL commands in pgaccess before I put them into my C++
code.
> Trying to copy a table using...
> SELECT * INTO TABLE copy_stuff FROM
If you are planing to use ecpg :
exec sql declare cuserbase cursor for
select column1, column2, column3 from my_table order by 1;
exec sql open cuserbase;
exec sql whenever not found do break;
while ( true ) {
exec sql fetch cuserbase into ...
// do same work
}
exec sql close cuserb
I think this isn't so difficult.
Use "unload to ..." on Informix side ( from dbaccess ) and "copy ... from
..." om Postgres side.
"Sylte" <[EMAIL PROTECTED]> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
9d8r7v$1to$[EMAIL PROTECTED]">news:9d8r7v$1to$[EMAIL PROTECTED]...
> Howto? Are there tools or is i
Hi group,
We have a DSS system based on Informix IDS and number of OLTP systems based
on Interbase.
After we was running this system, we had have a unceasing serious problems
with Interbase.
1) Massive inserts, updates, deletes is crashed database internal structure
!!!.
we have to make backup