Recent content by donafran

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...