Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pbopbo

    COGNOS 8 & MS SQLServer 2005

    Hello, The official support of COGNOS told me that it was not possible to plug on Analysis Services 2005 cubes. They also told me that connection to SQLServer 2005 as datasource was possible but not supported... And what about Transformer 7.3? Can I generate PowerCubes from an SQLServer 2005...
  2. pbopbo

    cognos 8 and MOLAP ?

    I haven't worked whith FM, so I based this affirmation on what I heard... Thank you very much for the correction ! Regards, Philippe
  3. pbopbo

    cognos 8 and MOLAP ?

    Hello, Am I wrong thinking and saying that actual COGNOS 8 solution is only ROLAP and provides no MOLAP feature ?!? How can I use a cube as source in Framework Manager ? It seems that FM is not able to generate IQD ... So how do we deal performance problems ? Thank you in advance for your...
  4. pbopbo

    Hello, I use a table with a blob

    Hello, I use a table with a blob. When I insert something in this blob I get an opened cursor named table_e_400_6eec_5_0_0 which is visible with the query select user_name, count(1) as count, sql_text from sys.v_$open_cursor group by user_name, sql_text order by count; I found an explanation...
  5. pbopbo

    COMPRESS a table

    Thank you, I'll try to add this feature to the server. Cheers, Philippe
  6. pbopbo

    COMPRESS a table

    You have understood me, Dima. As I wrote in my firt message, there is a COMPRESS command that can be applied to a table through an ALTER TABLE command. But it seems that I need a specific feature (Heap segment compression ). And I'm not sure that this feature is adequate for my purpose. Any...
  7. pbopbo

    sqlldr from pl/sql?

    One way I think is to write a Java stored procedure that calls sqlldr (something like Runtime.getRuntime.exec(cmd);. You can than call the java stored procedure in pl/sql like another pl/sql function/procedure. Hope it helps. Philippe
  8. pbopbo

    COMPRESS a table

    Yes 9.2 EE...
  9. pbopbo

    COMPRESS a table

    OK, I understand now...[thumbsup2] I'll try this. But as I want to keep this table always as small as possible I will be forced to program this procedure in an automatic job. Is there no way to let Oracle do this job ?
  10. pbopbo

    COMPRESS a table

    What do you mean ? I don't want to export the table, I just want it to be smaller in Oracle...
  11. pbopbo

    COMPRESS a table

    Hello, I want to compress a table which contains blobs. I tried ALTER TABLE MYTABLE COMPRESS but I get this error : ORA-00439: feature not enabled : Heap segment compression How can I enable this feature? Is it the only way to compress BLOB data ? Thanx, Philippe
  12. pbopbo

    SQL*Plus : column headers truncated

    I tried to do this, but I had bad results with numeric columns. If you apply an 'AXX' format on a numeric column, you obtain something like ####### in the data... So one should refine your query with a DECODE like DECODE(DATA_TYPE, 'NUMBER', '999', 'VARCHAR', 'A')... Too much work for my...
  13. pbopbo

    SQL*Plus : column headers truncated

    Thank you for confirmation. I think it's a strange limitation. A parameter like "SET HEADERWIDTH [COLNAME|DATA]" should not have been complicated to implement !...[thumbsdown]
  14. pbopbo

    SQL*Plus : column headers truncated

    Thank you for your response. But is there no other way to tell sql*plus it should display the full name ? I would not like to have to know the structure of the table (for a generic batch processing). No idea ?
  15. pbopbo

    SQL*Plus : column headers truncated

    Hello, I want to create a .csv file from a table. My script : SET echo OFF SET HEADINGS ON SET colsep ',' SET feedback OFF SET linesize 1000 SET sqlprompt '' SET serveroutput ON SIZE 40000 FORMAT SET TERMOUT OFF SET UNDERLINE OFF SET trimspool OFF SET trimout OFF...
  16. pbopbo

    Converting a code in its textual description in report

    Dave, Thank you for the response. In fact the situation is a little bit more complex than what I showed in my example. I have more than 10 codes for this field and the description are translated in three langages (in another table). And I have more than one field in the report that is coded...
  17. pbopbo

    Converting a code in its textual description in report

    Hello, I would like to convert a numeric code in its textual description in a report. The situation is the following one : I have table which looks like ID EVENTTYPE EVENTDATE 1 1 14.08.2003 2 1 14.08.2003 3 2 14.08.2003 4 3 15.08.2003 5 1...

Part and Inventory Search

Back
Top