Search results for query: *

Disregard, I was able to figure it out. You need to insert a macro as a parameter

I have a stored procedure which requireds parameters as a query subject how can you pass the paramaters to the stored procedure from either Query studio or Report studio. Currently when publishing package while trying to create report the stored procedure does not return any fields since...

Hi all, I was wondering how can code in java a do while loop that reads a specific directory in unix and passes each file name found within the directory to a different routine as a parameter.

Add more memory. I was running into the same problem we added memory and reportnet was starting a lot faster. Also, when starting the reportnet services DO NOT start them from configuration manager start them manually by executing the startup batch file.

Does any one here has experience with both DecisionStream and Data Junction? If so, would you be able to tell me why one ETL is better than the otehr?

Actually Cognos Recommends using UNC paths instead of map drives. I have not encountered any issues using UNC so far with Cognos Series7 MC

Yes, you can download a utility from the Cognos Support Web Site to help you process PPES audit log files. For more information, go to http://support.cognos.com/supported/support/pua/series7/using.html There is also a company Software By Design, Inc. who has developed a nice front end...

Does anyone know how to execute and format and update statement using the sql command from within the Procedure Node? Example; SQL('connstr', 'update table field = 'X''); When I try the example above I get an error message, It seems that the parser does not like the quotes for the 'X' value.

I asked the same question to COGNOS and they mentioned that, yes you can eliminate Upfront as the protal and use Cognos Connection as the Portal for PPES 7.3 MC

The security model in ReportNet can be easily integrated with the existing security infrastructure in your organization. It is built on top of one or more third-party authentication providers. You use the providers to define and maintain users, groups, and roles, and to control the...

Thanks Rob! I will go ahead and give it a try. Martin

All, When creating a new project using Visual Studio.net the Creating New Project status box runs for a while over 30 minutes and then finally it generates the project. Have anyone encountered a similiar issue? I'm using VS.net 2003 with Win XP Pro. Your help would be really appreciated. MC

After install the dotnet framework ver 1.1 IIS in windows XP pro gets stuck in a starting status. Did anyone encountered the same problem ? Martin

I tried it in Sybase but I continue to get errors. Here is the code: select a.job, a.start_time, b.end_time from (select distinct date, job, start_time, end_time from v_control_m_jobs_detail where start_time <> "" ) a, (select distinct date, job, start_time, end_time from...

Anyone out there know if the following code can be accomplish in Sybase ? Oracle: select aa.field1, bb.field2 from (select keyfield, field1 from table1) aa, (select keyfield, field2 from table2) bb where aa.keyfield = bb.keyfield Thanks

Thanks nwdurcholz! Thanks for all the ideas. I'll have to do some more research on how tu use xml and the SOAP libraries to create the webservice in unix. Martyc71

I'm running .NET in a Windows 2003 server. I was wondering if I could make a call to a remote server. In vb 5 and 6 I was able to accomplish that by using WINSOCK to connect ot unix and call the required commands. Any ideas how I can accomplish the same using ASP.NET

Does any one know a way to call unix shells scripts from ASP.NET using VB.NET ?

Thanks flex13

hlybbi, If the number of fields in your source tables are the same as your target temp table why do you need a temp table why don't you just use a union select * from table1 union select * from table2 I would use only temp tables if i'm manipulating data Martyc71