DSXchange

Hi chulett,

Thanks for reply. Sorry it is my fault I forgot to commit after I inserted the record in database. After I do a commit parallel job is doing fine with both Varchar and LongVarchar.



Thanks,
Raju

Hi chulett, In oracle it selected the row which I mentioned 123, in datastage oracle Enterprise stage I used the same sql select dbms_lob.substr( TEST, 4000, 1 ) as TEST from Test_CLOB and with sql type as varchar and with no length specified and it is returning no rows and no rows written to a data...

Hi , I'm trying to read a CLOB data type in datastage 7.5.2 using oracle Enterprise stage and my oracle is 10g in oracle DESC Test_CLOB Name Null? Type ----------------------------------------- -------- -------- TEST CLOB select dbms_lob.substr( TEST, 4000, 1 ) as TEST from Test_CLOB; I got output a...

Hi, When I ran the same job from Development (Datastage) server pointing to Preprod Oracle server, job is working fine and when I ran the same job from Preprod (Datastage) server pointing to Preprod Oracle server job Iam facing the above problem as I mentioned and I checked all the environment varia...

Hi Ray,


Iam reading it sequentail so it will have only one node





Thanks,
Somaraju

Hi,


From Job Monitor and Job log. I determined the no of records Iam extracting




Thanks,
Somaraju.

Hi, Iam using oracle Enterprise stage to read data from a table SELECT * FROM EMP WHERE EXISTS (SELECT DEPT FROM DEPT A WHERE A.DEPT_NO = EMP.DEPT_NO) ORDER BY EMP.ENAME When I am using above query to run my job to extract from oracle enterprise stage it is extracting only 5000000 (half million) ins...

My problem was solved by placing \' and \'

before \'EMPNO~Seq \'




Thanks,
Somaraju.

Hi, Iam passing user defined SQL through a job parameter and statement looks like this psql (Parameter) string and its default value = SELECT * from EMP where EMP_NO = 'EMPNO~Seq' and in oracle stage Read Method = user-defined and in SQL Query = #psql#. When this job runs it is failing by throwing t...

This problem was solved by replacing lookups with join stage. This problem is because of large lookups.











Thanks,
Somaraju.

Hi, I had a job which has single lookup stage and 4 lookup datasets. The size of lookup datasets are 4.3GB, 0.23 GB , 0.51 GB and 0.13 and input dataset has 1.95 GB which is stream link. My job is aborting by throwing the following errors LU_Monthly_Data,0: sh: dbx: not found LU_Monthly_Data,0: Oper...

Hi, I have sequencer job . I had two command activities, in command tab I provided command: test -s and parameter tab I provided the file name and in second command activity I did the same thing to check whether second file exists or not. And I had sequencer activity and last I had email notificatio...

Hi, I have a requirement like this, I have input Columns, CLNT, PLN, PQ, YTD C1 P1 5.2 7.4 and I need output as CLNT, PLN, RT, TR C1 , P1 , PQ , 5.2 C1 , P1 , YTD, 7.4 I am getting TR column by using Horizontal pivot but Iam not getting RT output column which should contain input column names, is th...

Hi,

I have requirment like this. I need to send a .csv file attachment in mail when there are records in the file, if there are no records then no need to send the attachment in the mail. Is there a way to find the records present or not in a file before sending an attachment .


Thanks,
Somaraju.

Hi,

Here is the script



#!/bin/ksh/
cd /data/ins/dev/dataset/R1/
orchadmin delete PSRA*_$1.ds



Thanks,
Somaraju