DSXchange

It doesnot even say that in the log.

I am getting the following error when I run my job "Unrecognized argument: ) [argvcheck/argvcheck.C:3832]" apart from this it doesn't display anything.Could you please let me know what is the cause of the problem.

It got resolved and here is the solution

trim(a.FIRST_NAME) like trim(ORCHESTRATE.FIRST_NAME) || '%'

oracle Sparse lookup with like option is not working,do we have any alternative method to do the below operation. Here is an exmaple below SELECT PATIENT.FIRST_NAME FROM PATIENT PATIENT WHERE PATIENT.FIRST_NAME LIKE 'ORCHESTRATE.FIRSTNAME%' the input FIRTSNAME is coming from a row generator.The data...

I have a scenario where in I am running the below sparse lookup SELECT PATIENT.FIRST_NAME FROM PATIENT PATIENT WHERE PATIENT.FIRST_NAME LIKE 'ORCHESTRATE.FIRSTNAME%' the input FIRTSNAME is coming from a row generator.The datatype is varchar(15) for both the oracle database table & row generator....

If I run dsjob -report XML where does this gets created on the local directory if no directory is specified while running

If there are three stages for example seq file-->AGG-->Dataset.I want to know how many records are being read from seq file,whats the input records count to aggregator and then with how many records the dataset is getting created.I need the row count of each stage/link.

Used ANY filter and nvl to get that.Its more on the sql query side not the datastage.

The privileges for viewing my job are disabled in designer and I want to capture the statistics of no of records been processed for each stage/link. I have used the dsdesign command below to get that dsdesign.exe /H=192.168.134.75 /U=user1 /P=pass1 project1 job1 /R /RP= C:\new\ /RX when I run this c...

Ray is correct.The stage being used is oracle enterprise stage.I found an work around for that & implemented.Thanks to all of you,appreciate very much your help.

I am writing a query similar to the below select ename from emp where #eno# is null #eno# is a job parameter when I pass the value as '' I am able to view the data from the oracle stage but when I run the job it gives me the error unknown argument IS and job gets aborted. This is the only error msg ...

Run the command dsrecords and it would display the count in the unix box.

I have the data in the below format

empno(field name)
7369
8765
9008
4507

I want it in this format
empno(field name)
7369|8765|9008|4507

how do we merge multiple records into one record as pivot does only horizontal in parallel jobs.

1374: InterVar0_91 = To_Mem_Xfm.CATA_COPAY_MAX_AMT; 1375: InterVar0_92 = replace_substring(InterVar0_67 , InterVar0_0 , InterVar0_91); 1376: To_Lkup_Plan.CATA_COPAY_AMT = (string_of_substring(InterVar0_66 , InterVar0_77) + trimc_string(string_from_decimal(InterVar0_92 , InterVar0_69))); 1377: } else...

0271: string StageVar0_F28; 0272: StageVar0_F28 = ""; 0273: string StageVar0_F31; 0274: StageVar0_F31 = ""; 0275: date StageVar0_StageVar2; 0276: StageVar0_StageVar2 = date_from_string("2001-01-01"); 0277: int32 StageVar0_StageVar3; 0278: StageVar0_StageVar3 = 0; 0279: ...