Search results for query: *

No suggestions anyone ??

Hello ! OK -- I have a set of 6 Parallel jobs that I am now putting together into a SEQUENCE job to control job flow. Here's a description of what I need to do : PJ1 , PJ2, PJ3 can run in parallel, are fed through a Sequencer. PJ4 isnt really a job -- I just need to check the value of a...

HEY !! Just found it -- Add Environmental Variable $OSH_ECHO and set it to TRUE. Then in your view of the Job log, look for a Statement similar to main_program: Echo: (...) Then DOUBLE CLICK on it for more details -- It shows you the SQL statement with the variables replaced by the...

On my Transaction Download from the As/400 ODBC connection, I am getting 200 or so extra records than I am expecting – using job parameters as variables in my SQL where clause on the ODBC step. If I HARDCODE the values into the WHERE clause, I get the correct number of transaction records. So...

HEllo. I searched, but couldn't find a thread about this -- On my ODBC input connection, on the COLUMNS tab -- Does it make a difference if the columns are in the correct order ? We had a change to the output table, and the new field happens to NOT be the last field on the table. When...

Thank you. I had experimented with the Copy Stage. Is it any more or less efficient from a performance viewpoint, to use 15 ODBC connection stages, or 15 Copy Stages?

Thank you, but I am still confused. The question is How do I join the SQL table to the As/400 Table >>IN THE ODBC << Connection stage? Our Source As/400 table contains over 20,000,000 transactions, but on any given run of my DataStage job, I want to only select a few thousand...So I really...

Another question trying to replicate a process we have in DataManager in Data Stage. (I know I need to stop comparing the 2, but I can’t seem to find any documentation on how to perform the tasks I need in Data Stage and I am more clear in my question if I explain the Data Manager process I am...

Hi I am BRAND NEW to Datastage and am tasked with converting our porcesses from Data Manager to Datastage. >>> In Data Stage, our task is : We are trying to use a table accessed through our ODBC connection to an AS400 system as our input Stream. Our requirement is that the SQL statement...

We are using PPLAY Web and Enterprise SErver Admin version 7.1.341.2 (7.1 MR1) We have several "base" cubes that we build and publish (to refresh the data) everyday. Our users manipulate the cubes and then very often "SAVE AS" to their own Newsbox. Today, all of a sudden, ONE of these base cubes...

The "Database" named Range is ONLY the 8 cells in ROW 1 that contain the heading info. There is no data included. Should there be ?

I am trying to create an Impromptu Report that uses an Excel Spreadsheet as input. Using v7.1 MR2 on WIN 2003 OS. I defined an ODBC using the Excel driver. I created a logical Database name. In the Excel file, the first row has simple column headings (only 8 columns of data) and is a "named"...

drlex, we have a VERY similar problem using Impromptu v7.1 MR2 on a WIN 2003 machine. But we use SQL server 2000 database. Is there a similar file for SQL settings as the .ini you mention in your response ? Thanks

Hello ! We currently have MR1 in our production environment and MR 2 in our test environment. In MR1 -- PPES Server Admin tool, when you go to PROPERTIES of the SERVER level...the first tab is called "GENERAL", the second tab is "SETTINGS". In MR1 - in the SETTINGS tab, there is a section...

Has anyone done this upgrade yet ?? We have been testing MR2 and are just about ready to out it into production. But since it is seems to work just fine, we can't really measure the benefit of upgrading from MR1 to MR2. We just want to be sure we don't make things worse by installing MR2...

Wallst32 -- Thanks for the code. How would I modify it so that I can retrieve the day of the week into a variable I can the use in an IF-THEN-ELSE to control execution ?? I am looking for something along the lines of >Get dayofweek > if dayofweek="Mon" then.... or >if dayofweek=2 then...

Well -- Cognos now says this is a bug -- Issue number 433760. Does anyone know how to look up Enhancement requests or bug numbers on Cognos website ?? Thanks !

drlex - Thanks ! When you say it is a bug -- do you mean it is a DOCUMENTED bug that Cognos knows about ? Do you know of other Cognos users having htis same issue? I couldn't find any reference on their Knowledge base. Would you know any Cognos reference to the bug or the bug number? Thanks !

When we are in a PPLAY WEB Explorer report, we can "export to PDF" and "Export to CSV" without problems UNTIL we use the "SAVE" icon on the bottom, right of the Cognos Toolbar. If we hit "SAVE", then try to "Export to CSV", we get a blue status bar, then nothing happens. We have tested this...

OK - I changed trhe script to below, with the SAME effect. All I am trying to do is force the last sentence to be on a separate line from the first sentence. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Sub Main() Dim objOutlook As Object Dim objOutlookMsg As Object dim msg1 as string rem...