Search results for query: *

As far as I know its 255, the total row length I think is limited by the page size.

Hiya All, We are looking at getting a new machine for our production DW (running Sybase IQ 12.4.3), we are migrating from an old Sun box to one of these: IBM p630 (2x Power 4 1.45GHz, support for max 4 processors) 8GB RAM or Sun V880 (4x Sparc III 1.2Ghz, support for max 8 processors)...

Try adding the .MCX rather than the .MAC to the run dialog box. If that fails the command line is: <Your Cognos Installation dir>\cer?\bin\runmac32.exe <macro name>. For example mine is : c:\Program Files\cognos\cer2\bin\runmac32.exe mymac.mcx

What we do with stored procedures is create an IMR that contains the prompts for the stored procedure, and then base another IMR on this Source IMR so that we can apply extra filtering, calculations etc... Just a suggestion ;-)

One very important thing to note about the uvodbc.config .. don't forget the spaces aroung the &quot;=&quot; sign... I spent many hours why I was getting odd error messages .. turned out I had DBMSTYPE=ODBC and not DBMSTYPE = ODBC. Nothing to do with this problem.. just something that annoyed...

The Sybase IQ Bulk Load stage uses Sybase Open Client to connect to the IQ Server. You need to make sure that you have Sybase Open Client installed on the server and that your interfaces file (found in $SYBASE) points to the IQ Server (execute dsedit to set it up). The best way to test this is...

Brycie, Im a little confused about what you actually want? You want to call a stored procedure in a Sybase Open Client stage? if so its easy, simply change the QueryType from Generated to SQL Query, and in the SQL tab put in your Stored procedure (you can put placeholders in to use dynamic...

JGirl, We are also a Datastage(5.1) and Cognos (Series 7) site and here is what we do. At the end of the last datastage job simply put in an 'After-Job Routine' that calls a batch file (Eg. ExecDos D:\Cognos\Macros\BuildCube.bat) and make sure that the Check Box 'Only run after-job...

I know its a simple question, but are you using the same connection to create as you are to drop the index? If you change the SQL to &quot;select db_name()&quot; do they both return the same name? Starg

Which version of ISQL are you using? I use &quot;Sybase Adaptive Server Anywhere ISQL Version 6.0.3.3066&quot; and there is an option to use an ODBC driver as input for all the parameters you mention. It is possible to also script it, checkout the reference guide for full details but for an...

Brian, are you getting any error messages either in the Powerscript or the server logs?

or if your using the version of Adaptive Server Anywhere that comes with Sybase IQ, don't use sp_who buy sa_conn_info

Trisha, The problem you have is that you are doing an outer join (*=) and not an inner join (=). What your query is saying is that you want all rows from SW_CASE and only those rows that match in DS_SURVEY. As you are only selecting back the swCaseID and using a having clause (having's...

Dave, Yes it does, but that does bring me to another point. In the final version of this macro I would want the application to be invisible. This means I need to assign the window handle to a dialog box that I have displayed, would you know how to the the Window handle of a dialog box that...

Hi, Does anybody have examples on how to make win32 APIs calls for common dialogs (I am trying to open the Print Dialog). My code compiles but does not display the dialog or return an error. I think the problem I am having is returning the handle to the current window. I make the Powerplay...

How do you know its a corrupt index? what are the symptoms? what version are you on? Platform? Does the problem occur at an specific interval or after an event (or series of events)? Warren