prateek jain

Hello Friends
I have got a .4ge Program in which some temporary tables are created and populated with some records.
Now i have to view data of temporary table.
One option is i unload to file_name select * from temp_table
but since i cannot rebuild the .4ge due to some reason is there anyway when the program is running i would be able to view the content of temporary table.

---------------------------------
Yahoo! Shopping
Find Great Deals on Holiday Gifts at Yahoo! Shopping
sending to informix-list

simmons, keith

Unfortunately not. Temporary files are the exclusive 'proerty' of their creator and not even the DBA user can access them (directly). You may be able to look at the pages they are held on and see the unformatted data, but I wouldn't hold out much hope.

Keith

-----Original Message-----
From: prateek jain [mailtorateek_mjv@yahoo.com]
Sent: Friday, December 09, 2005 09:53
To: informix-list@iiug.org
Subject: How to View Data of Temporary Table


Hello Friends
I have got a .4ge Program in which some temporary tables are created and populated with some records.
Now i have to view data of temporary table.
One option is i unload to file_name select * from temp_table
but since i cannot rebuild the .4ge due to some reason is there anyway when the program is running i would be able to view the content of temporary table.

---------------------------------
Yahoo! Shopping
Find Great Deals on Holiday Gifts at Yahoo! Shopping
sending to informix-list

************************************************** ********************************
This message is sent in strict confidence for the addressee only. It may
contain legally privileged information. The contents are not to be disclosed
to anyone other than the addressee. Unauthorised recipients are requested
to preserve this confidentiality and to advise the sender immediately of any
error in transmission.
This footnote also confirms that this email message has been swept for the
presence of computer viruses, however we cannot guarantee that this message
is free from such problems.
************************************************** ********************************
sending to informix-list