DSXchange

Hello, I have a requirement in one of my batch control job to get the value from Hashed file.If the value is present in the hashed file the job should run otherwise(Record Not Found in the hashed file) the job would abort.I have tested the below code in bacth job..but noluck..can you please suggest ...

Thanks for your comments.

The key columns in the hashed files should not be null. So i am confused with IsNull instead of NOTFOUND link variable.


Thanks,
Satheesh

Hi All, I have a problem with the below constraint in one of my jobs IsNULL(Lkp.Column1) AND IsNULL(Lkp.Column2) both Column1 and Column2 in the hashed file are key fields.How to validate the above constraint. I have checked my hashed file,none of the columns are null.Please let me know your thought...

Hi,

Did you try with the below DS macros

DSHostName : ":Notification (" : Substrings(DSProjectName,4,4) : ") - " : Subject





Satheesh.

Hi All, We have the server job which used to check the saletodateagainstdmsale tables. We usually ran the query with parallel hint SELECT /*+ parallel (SALETODATE,8 ) */ (...). The job ran quite good for couple of months but now the job was aborted by below warnings and error ORA-24347: Warning of a...

Hi, I have a problem in unique constraint violation. I have a table Vendor which contain the following unique index CREATE UNIQUE INDEX VENDOR_U01 ON VENDOR(VENDOR_xref_ID, VER_START_DATE) CREATE UNIQUE INDEX VENDOR_U02 ON VENDOR(VENDOR_ID, SUPPLIER_ID, MARKET_CODE, VER_START_DATE) The thing is i am...

Great Thanks ArndW.

Satheesh

Hi, I have a Sequence Job in which we are running multipleinstance jobs.The problem is in parameter concatenation. Parameter Names HdrFileName----HeaderFileName SourceDate------Cycle Date RejctFileName------Rejected Sequential file created as follows(Format #HdrFileName#.#RejFileName#.#SourceDate#) ...

Hi Ray,

Thanks for your input. I have two hashed files like the above mentioned..I need to clear the both..can we have any option to clear both the file by using Clear.File command.


Satheesh.

Hi All, I have a problem in hashed File.I have an hashed file which has 3 input links.All of them write into the same hashed file..Eg;PartitionHash. Input1.SaleDay Partition Information.(PYYYYMMDD) Input2.SaleWeek Partition Information(PYYYYMMDD) Input3.SaleMonth Partition Information.(PYYYYMM) The ...

Hi All, I used OracleStage as an lookup.and i wrote an user-defined sql as: select day_id,store_id, count(*) Record_count from dm_sale group by day_id,store_id. I can able to ran the sql using Toad or sqlplus. But while running the job it throws an error ora:01036:illegal variable/number day_id deci...

Hi ArndW, I checked both the log files..we use the same 4node configuration file.. Some more info from log LookupProductFlags,0: Could not map table file "/PX_Scratch/PX_Scratch1/lookuptable.20071204.kdc5whc (size 30252000 bytes)": Not enough space Error finalizing / saving table /dstage/t...

Hi All, I have a problem with one of my parallel jobs..It ran fine for the past couple of years..We run the jobs through third party scheduling tool..We have enough space at the below specified path..Today it aborted with the below error: Job Design: OracleStg | SrcStg----->LkpStg----->AggStg--->Ora...

Hi Ray, Here is the code which is passed as the InputArg for the Routine ExecSh in RoutineActivity Stage. InputArg ----> 'new=`ls -1 #FilePath#/inbox/#Source#/#FileName#.[0-9][0-9][0-9][0-9][0-1][0-9][0-3][0-9].[0-2][0-9][0-5][0-9][0-5][0-9] | sort -r | head -1`;mv $new #FilePath#/inbox/#Source#/#Fi...

Hi All, While executing the above code by using InputArg in RoutineActivity Stage with Before/After Routine(ExecSh) ..Here is the error Message i got while executing in DS director: Error calling subroutine: DSR_PROJECT(Action=7).check DS is set up correctly.Unable to load subroutine on host(30105)....