DSXchange

i have not yet tried

DSJ. JOBPID Integer. Job process id.

process_id = DSGetJobInfo (DSJ.ME, DSJ. JOBPID) can help

below code works for me......

Status_value = DSGetJobInfo (DSJ.ME, DSJ.JOBINTERIMSTATUS)

DSJ.ME is the job handle for current job.

How about using system variable @PATH.

store your incoming date value from oracle to a stage variable and use that variable like below 1.for example ICONV("2008-05-09","D-YMD[4,2,2]") = VAL 2.similary second variable to store time part. .........Iconv("02:46:40", "MTS") 3.then use OCONV function li...

2008-05-08 21:28:26.0:0001 use ":" for concant

you can use DSGetLinkInfo

need to write user defined sql using ":" for input columns for example

select deptno,case when deptno = :1 then dname else 'null' end from deptsb

job design

oci stage---------->transformer---------->oci stage(check key columns for where condition)

i have never used it in unix system,

you can check for help in manager guide pdf, dscmdexport command can help

dscmdexport /H hostname /U username /P password /O omitflag project
pathname /V

or may be searching in forum can help.

i am sorry to post a reply as the topic is already resolved, but i got one solution, so posting it, may raja123 can have a look on it. imagine your entire file format is abc05_05_2008_01.txt. 'abc' is filename that is fixed and can be parameter, '01' is version and '05_05_2008' is date format. i am ...

Tried to implement what you want and OCONV(@DATE,"D_E") is working fine, also just try to compile your job called in sequencer and sequencer, also see getsysdate is string datatype in called job, it works fine.

just check all your input files are located in directory you mentioned, it may be that your merge stage is not able to read one of the input file.

are you creating "BEFORE/AFTER subroutine" or transform function.

Hello Ray is it not possible with row merger stage.

hello just4u_sharath


i am facing the same problem, i am seeing 3 rows in output, but i want them to be in single rows like 123456789 for input

1;2;3
4;5;6
7;8;9

i see
1;2;3
4;5;6
7;8;9 in output.

can you please help.