DSXchange

Hi ! ?I need some help How I can to arrange lookup for some values . For example , I need to check if any rows with id =1 and type = 5 or 6 within hash file with keys id and type Specify your keys for the LookUp. In the Transformer you need to check "Returns Multiple Row Set" option for t...

Besides, we all know that the whole " the purpose of Dynamic RDBMS is to load into any database without changing the metadata, by just changing the database name, runtime " thing is a bunch of marketing whoey, right? :wink: Thanks Ray & Chulett. The only reason , we used DynamicRDBMS ...

Hi, We have few jobs that load data into DB2. We used DynamicRDBMS Stage to load the data into DB2. As you know, the purpose of DynamicRDBMS is to load into any database without changing the metadata , by just chagning the database name, runtime. We have a table that has following columns defined li...

I am not sure if this is going to help you. But try to have two passive stages on either side of the link collector. For example join from two sequential files and write to a sequential file before taking to a transformer. We did design some of the jobs that way. We are facing this issue more with ...

What about running the SQL directly via SQL Plus or TOAD. Hi Sainath, We ran the same query in SQL Server - QueryAnalyser, the results were correct. QueryAnalyser ignores only the particular line that is commented out. The remaining lines after that statement are executed without any issue. Thanks

If that's the case I'd say that's a new bug, not something corrected, and it should definitely get presented to IBM/Ascential support. I'm curious, though - not only should it not be sorted but that last constraint (And CT.CASE_REPORTED_SFX > ' ') should also not be happening. Is that true? Thats t...

I agree with Craig. I have done this in the past and it ignored the single line and worked as expected in PLSQL. Hi Kim, Thank you all for the replies. When i remove the comment , the records(are sorted) order is same in both versions. But when i leave the comment as it is, its working fine in 7.1 ...

I have User-Defined SQL in ODBC stage. The same query exists in 2 projects. One with ver 7.1 version and the same job in another project with ver 7.5.1A ************* Select CT.PARTITION_ID, CT.AS_OF_DT, SUBSTRING(CT.CASE_NUM,1,10) As CASE_NUM_10, CT.CASE_REPORTED_SFX From T3_PARTITION_CNTL PCN, T4_...

Hi, Assuming the code is ok. How is this job invoked? Is it via a schedualed task? (check it out) If you changed the job did you unschedual and reschedual it? Inconcistant behaviour might sugest a corrupted repository. (DS.REINDEX ALL when no one is in the project) IHTH, Hi Roy, The Sequencer is ra...

From the log you supplied: Job JC_LD_T1_ICWIS_STAGING started with parameter parmParameterFile set to D:\DWH\Parameter_Files\MasterParameterFile_LoadsPreProcessing_DS3.txt Job JC_LD_T1_AG_PAYMENT started next, but appears not to have any parameters. Have you added the parameter parmParameterFile to...

Sainath.Srinivasan wrote:Can you open the sequencer job stage to confirm that the property is linked correctly.

I checked the Sequencer and ,
'yes' it is linked correctly.


Thanks

Show us the "job starting" entry for the job sequence - maybe it didn't have its parameters set. Hi Ray, Here is the job log ***************** Starting Job SQ_T1_PRIMARY_LOADS. parmMasterParameterFile = D:\DWH\Parameter_Files\MasterParameterFile_LoadsPreProcessing_DS3.txt SQ_T1_PRIMARY_LO...

Sainath.Srinivasan wrote:Can you check whether the parameter is being passed correctly now. Maybe someone tampered with the job 'B' to remove the parameter.

Its Read-Only job in production,which ran fine earlier several times.


Thanks

Maybe you are calling the job in 2 different places or have any logic when deriving or passing the parameter. NO, i don;t have any logic when deriving or passing the parameter. ******************** SQ_T1_PRIMARY_LOADS -> (JC_LD_T1_ICWIS_STAGING): Job run requested Mode (row/warn limits) = 0/0 Job P...

Hi, We have a Sequencer that runs 3 jobs one after the other. Each job has one parameter each (A,B,C). We defined a parameter (X ) at the Sequencer level and used that parameter in the ValueExpression of the jobactivity, for all of the 3 jobs. When we run the Seuencer we pass the value to X, so that...