can't see any data in IQ????? option set wrong or waht row counts are zero

[sybase46]

Can someone help. We see data going into IQ tables but the rowcounts are zero. You can create a table and do DDL and isnsert the data but you can't see it.

Please Help!

[John Anthony]

first thought that comes to mind ...

Are you using the same login to create table and query the rowcount ? Is it a table ownership mismatch ?

Do something like this and publish result ..

In the same sql batch

select @@version

create table

insert table

select count(*)

-JA

On Mon, Sep 30, 2013 at 7:16 PM, sybase46 <syba...@gmail.com> wrote:

Can someone help. We see data going into IQ tables but the rowcounts are zero. You can create a table and do DDL and isnsert the data but you can't see it.

Please Help!

--
You received this message because you are subscribed to the Google Groups "iqug" group.
To unsubscribe from this group and stop receiving emails from it, send an email to iqug+uns...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Abhijit Jadhav]

Might be two possibilities.
1. No commit was issued after inset statement. You don't need commit for DDLs.
2. You could be missing fully qualified name.  Like dbo.tablename????

Regards,
Abhijit

On 1 Oct 2013 01:16, "sybase46" <syba...@gmail.com> wrote:

Can someone help. We see data going into IQ tables but the rowcounts are zero. You can create a table and do DDL and isnsert the data but you can't see it.

Please Help!

--

[Jeffery Yoder]

Thanks for the offer but if the "set option temp_extract_name1 = '/filepath/'   isn't set to ' ' You won't see the data. di that and it worked.

--
Jeffery Hugh Younce-Yoder
Senior Sybase DBA
5539 Columbia Pike, #805
Arlington, VA. 22204

[Abhijit Jadhav]

Excuse me. It was not offer!

You need to be specific and provide example of what you are doing.

This is table extract and not table insert command!

Anyway you could have used 'set  temporary option' and that's reason you need to rest to ''; . Or unless there is specific reason for not using temporary.

Regards,
Abhijit