DSXchange

I have a job sequence that relies on entered parameters. I want to execute this job many times at the same scheduled time. I tried this and the last scheduled job is executed. All other are ignored. It doesn't look like the schedulers stacks the jobs as they are scheduled. Even though I enter the sa...

But A may need to run before B. That's my problem.

Let me clarify this a bit more. Remove Job C from the mix. Job A is the pre-sequence to Job B but is could be possible that Job B can be execute on its own. It is also possible that job A or Job B could run on their own. What I am trying to avoid is having duplicate Job Activities on the pallette. U...

Job A calls Job B, Job B calls Job C. Using a parameter, I tried to set a Custom Conditional IF THEN ELSE so that if the parameter is set to bypass Job B Job A would call Job C. I tried in Job A to say IF Parm = 1 THEN Job B ELSE Job C. Is this possible and what is the command to execute the job tha...

I added the following command to the end of my SQL Script. IF %ERRORLEVEL% == 0 goto EXIT :EXIT and I got a returm code of 0. It solved my problem. SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 26 10:08:18 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Databa...

I generate an Output report that show the statistics from the SQL. It returned with everything running normally but then throws an exception. I insert an EXIT in the SQL thinking that it wasn't closing SQLPLUS before returning back to DS. It did not work. I googled the error with limited results. I ...

I created a job sequences that fire off a SQL script. Set CURRDATE=%TEMP%\CURRDATE.TMP DATE /T > %CURRDATE% Set PARSEARG="eol=; tokens=1,2,3,4* delims=/, " For /F %PARSEARG% %%i in (%CURRDATE%) Do SET YYYYMMDD=%%l%%j%%k CD D:\DATAST~1\DEV\SHELL\LANDSO~1 SQLPLUS LANDSO_MART/LANDSO_MART@EDWD...

In the SORT stage, I hash partition but I do not check the sort checkbox. I assume that it is not needed. I tried checking it and still got the same warnings. Both my sort group and aggregator groups are the same.

More information...The reason I ask is; in place of using a fileset, I would like to convert the following. Code 1 = 'APR', 2='MAY', 3='JUN', 4='JUL' etc. What is the recomended way to implement this. I wanted to create a routine and call it but I am not a C++ programmer and I am not sure if there a...

How can I use this routine in my parallel job?

Does anyone know if IBM dropped Basic Transformer. It no longer shows up in our palette following the subsequent patch load.

I am still confused on how I should be partitioning and sorting data for the aggregator stage. I get this message and I have tried many different scenerios to eliminate it and still it appears. I am sure it's something simple. I get this, Cnt_Instr_Num: When checking operator: User inserted sort &qu...

I added a dummy column to the transformer stage and a dummy column to the Oracle Enterprise stage, used a lookup and voila, I got my added constant column. Where there's a will there's a way.

Thanks

I have dataset that contains fields A,B,C and I want to add D to the dataset. D is a constant that comes from an Oracle sequel statement. Normally I would default it but it come from the database.

Thanks

For those asking how I got it done, I was forced to do it through the Oracle stage. Sql command SELECT A.CIMS_NUMBER, PROVINCE, SUBMISSION_TYPE, FILE_OPEN_TIME_ID, FILE_CLOSED_TIME_ID, BUSINESS_DAYS FROM IMP_ATR_MINISTERIAL_ORDERS A INNER JOIN ( SELECT CIMS_NUMBER, SUM(CASE WHEN TO_CHAR(B.FISCAL_DAT...