DSXchange

Hi, I want to pass the sysdate value that is generated by sql plus session into my dsjob run command. I tried the below, but it is giving an error. Can some one let me know how to pass this variable from unix to dsjob -run [param] command. sys=`$ORACLE_BIN/sqlplus -s user/pwd@project << eof set head...

Hi all, I have a problem with stored procedure. I have searched the whole forum but I couldn't get an answer. I was trying to use a stored procedure create or replace procedure code_value_procedure as code_value number(10); begin select code_ID into code_value from claims_transaction where claim_cod...

Hi,
I am getting 2 millions records on which Iam using aggregator stage. How can I increase the buffer capacity such that the aggregator can perform its operation on these many number of rows.
thanks

I have a sequential which has to lookup into another file which has duplicate values on a feild. This is the pattern the files are in. seqfile 1 num code 1 1020 2 1030 In the other file are the lookup table which is like seq file 2 num value 1 20 1 30 1 40 2 60 when I do a lookup I need to get the o...

Hi,

How to scehdule datastagejobs using Unix in DEVELOPMENT , QA and PRODUCTION Environment.

Thanks,
Reddy