DSXchange

A LEEthal DBA on the project just came up with the following: SELECT MAIN_DATA.PK, MAIN_DATA DOE, LOOKUP_DATA.CDE, MAX_LOOKUP_DATA_DOE FROM -- Get all combo of PK, CDE and DOE. (SELECT MAIN_DATA.PK AS PK, MAIN_DATA.DOE AS DOE, LOOKUP_DATA.CDE AS CDE, MAX(LOOKUP_DATA.DOE) AS MAX_LOOKUP_DATA_DOE FROM ...

Looking for some advice on the best way to solve a lookup problem. After searching around the forum I think it is similar to previous questions about conditional/range lookups, but always hopeful for any additional insight. I have a DS data set (delta) that is missing an attribute; the required info...

Point conceeded about the incorrect diagram. I adapted it from the other topic and didn't think to replace with JobRoutine. We use the Routine Activity in sequence jobs because we are heavily reliant on RCP. We have many, many jobs that use the same parameters and follow the same design. But if we u...

...determine the values and pass it as hardcoded or as parameter. I know the Invocation ID and would like to do this. But I am not sure how. I should explain further - we are using the UtilityRunJob Routine Activity to call our parallel jobs. I'm sure there is a simple way to get the Invocation Id ...

Hi Guys, (My question is similar to an existing thread on this forum ( http://www.dsxchange.com/viewtopic.php?t=106299 ) but I didn't want to hijack that discussion.) I am trying to get jobs to run in parallel in a sequence: |--> Job_Activity_2 --> Job_Activity_5a ---| | | Job_Activity_1 ---------> ...

G'day Ray, The items I listed that feature "DSX.UTILITYABORTTOLOG" are examples of how DataStage is replacing "_JOB_NAME" wherever it finds it. So: (PREV _JOB_NAME ) turns into (PREV "DSX.UTILITYABORTTOLOG" ), (ABC _JOB_NAME ) turns into (ABC "DSX.UTILITYABORTTOLOG...

Yeah, it appears to be a reserved word. I've burnt a few more brain cells since my initial post (!): I set up the following Job Parameters: PREV_JOB_NAME ABC_JOB_NAME JOB_NAME NAME_JOB JOB__NAME PREP_JOB_NAME_ABC PREP_JOBNAME PREP_ABC_NAME PREP_JOB_ABC with a default value of 'xxx' and got no proble...

Hi Guys, I've had a look through the forum and found a couple of posts related to my warning message, but not in the context of the error I am getting. When I try to compile my sequence job I get the message: "Error compiling Job Control Subroutine" with the following information available...

I am also having problems with this. I can open the Analysis Process Viewer in ProfileStage but cannot find the Kill Process button that is mentioned in the help screens. I can hide the selected jobs but not terminate them I cannot find any reference in the accompanying PDF documentation about this ...

I agree with your comments about RCP, Ray. In practice we are trying to limit it's application to jobs where the same processes need to be ran over and over and over again (i.e. thousands of files to be processed and loaded to a database). The error I described above occurs when trying to load a dat...

I'm trying to test this same issue right now, and I suspect the answer is no. It works fine using the EE stage, but returns the following error when running use API: Fatal Error: Fatal: This SQL statement did not contain the same number of parameters as columns on this link. This usually happens wit...

A dirty solution would be to export your entire project into XML and then do a Search through the text for your variable name. If you are already Generating HTML reports for each job, you can search those. Wherever you find a reference, trawl through the code to find the corresponding job name. If y...

What are the column definitions/data types for ColumnValue1 in the two different jobs? Are they the same? Are you using custom SQL or Auto-generated SQL in the P Job? If the P job is still returning a record when you put in the Where clause, it implies to me that the record is being found in the dat...

Let me ask some stupid questions: 1. Are you connecting to the same ODBC source in both the server and parallel jobs? 1b. If not, have you double, triple checked that the data is the same in each database? 2. What is your job design? 2b. Is there anything in the parallel job that could change the va...

Check out the following link:

http://blogs.ittoolbox.com/bi/websphere ... iled-12320