Recent content by DrSmyth

Hi, I'm new to Oracle, so excuse me if I'm asking an obviuos question.. Basically I have a need to execute a loop concurrently (i.e. execute all of the outcomes of the loop in one go). I can do this easily from unix (just execute as a background process), but am struggling to find a way of...

Cheers guys, thanks for the suggestions. Due to the fact that I want to paramiterise the field in question as part of a batch process and the data files are huge so don't want to increase storage requirements I've gone with: OPTIONS (SILENT=(HEADER, FEEDBACK), DIRECT=FALSE, SKIP=1) LOAD DATA...

Hi, I'm brand new to Oracle and am very much learning the ropes, so please go easy on me. We're currently loading a table from a csv using a control file like this: OPTIONS (SILENT=(HEADER, FEEDBACK), DIRECT=FALSE, SKIP=1) LOAD DATA CHARACTERSET US7ASCII INFILE 'TEST.CSV' TRUNCATE INTO TABLE...

Thanks PHV, works like a dream... Have a star

Hi, I'm a bit rusty with my shell scripting and have a need to create a script to do the following: Search a file for lines beginning with this string: SITE_LIST_STR_PARM Then for this line extract each of the numbers following it and put them in a new file each on a different line. The numbers...

Hmmm, sounds interesting.... Any ideas how I'd go about that?

Hi, I've had a request to disable the Export to excel (both under run options and the link in the header) for some Report Studio reports (8.4), is this possible? I've been told by our gatekeeper that the only way he knows to do it is to disable it over the entire application for every user...

We've only ever managed to achieve this by building this kind of 'prompt page' as a standard report page, then using the radio button to show a drill through link depending on the option selected. the user then has to perform the extra step of clicking on the drill through link. Hope this...

Maybe use the paramweter values to create sections then apply page breaks to these.. Should work

Hi, my users are currently operating version 8.3 utilising pre-canned Report Studio and Query Studio reports. However, they've raised an issue wherebye the default file names that COGNOS gives to excel exports are too long (causes some kind of error with pivot tables). I realise that there's a...

First of all please excuse the rather cryptic title to this thread... I'm building a prompt page on a standard COGNOS Page (i.e. not a prompt page). The reason for this is that the user needs to be able to choose between 6 different reports, each with there own set of prompts, so I've got show...

Have sorted this using #prompt()# macro in a parameter map to read the table name extension from the drop down.. Works like a dream...

Hi.. I've been trying to build a dynamic Select & search prompt in Report Studio but seem to be failing miserably so was wondering if anyone could help... Here's the scenario: - User is searching from a customer from a list, there are 11 different types of customer name they will want to...

Cheers, mate... The rollup function mentioned with Grouping sets seems to be doing the kind of thing I'm after so gonna take a closer look at it.. Thanks,

Hi, I've an interesting SQL problem that's quite tricky to explain.... Here's goes: I've an aggregate query that aggregates by each combination of the dimensions that have been selected, here's my SQL: select DGOG.REGION_CDE, DGOG.CTRY_CDE, DFAC.BASE_ENTITY, DCPA.CUST_SUST_RTNG...