A question for extract one data from dummy table

[Former Member]

Hi expert,

I use Sybase IQ 15.4.

I want to export one row data with set temporary TEMP_EXTRACT_NAME....   like this sql

select '9999' from dummy;

or

select '9999' from iqdummy; (phygical table)

or

select '9999';

All of them did not make the data file. I know that system table can't export. In this case , how do i can export data? Is there any other way to extract?

Thank you in advance.

[Gisung]

Hi,

I think here are possible workarounds for this.

1. The extract job is working well when using "output to " instead of temp_extract* option.

   (DBA)>select '9999' from dummy; ; OUTPUT TO '/gjang/DATA/test.dat';

2. Insert the data into other table using "select into".

  select '9999'  into #test_tmp from dummy;

  set temporary option Temp_extract_name1='/gjang/DATA/test.dat';

  select * from #test_tmp;

"KBA 2323613" explanins the possible workaround.

- 'Feature, EXTRACT with OMNI functional compensation, is not supported' when using TEMP_EXTRACT option

https://launchpad.support.sap.com/#/notes/2323613

Best Regards,

Gi-Sung Jang

[c_baker]

You need a table with 1 row.  Try inserting a row into iqdummy.

Chris