DSXchange

hello dear please post your query in parallel forum.

To avoid warning limits and to run your job, limits needs to be modified.

Director---->Tools--->Option---->Limits tab.

A hash file can simply be described as a file that distributes data throughout a pre-sized and space allocated file.

considering path MOVE and COPY works and REPLACE does not, i have faced the same problem and then i used MOVE for my urgent development.

hello chulett i want to convey that you can't add your custom code in the code already generated by job sequencer, as the Job Control of sequencer is not editable as compared to other simple datastage jobs.

hope locking and deleting of table as mentioned by replies helps you, as you want to create a job which will track your job sequence, you can code in job control following to track job sequencer. Status = DSGetJobInfo( RunJobName, DSJ.JOBINTERIMSTATUS) *Call DSLogFatal("JobControl") Status...

hello, i hope your job sequencer calls job of type A and B.

but i doubt you can custom code job control of job sequencer with basic code,

you cant edit the code of job control that is developed automatically.

hello dear, 1.Imagine your 4 jobs take 2 secs to run ok. 2.start your job with some time and imagine you want be in loop for 2 hours. you have to use UserVariables_Activity,startloop,Job_Activity and EndLoop. job design like below UserVariables_Activity--->startloop------->Job_Activity------>EndLoop...

vice versa works dear !!

sorry for wrong interpretation, i have taken an input file emp.txt with below records 1,sac,10 2,mark,10 3,pras,20 4,sush,20 6,ritu,30 7,ash,40 8,ddd,50 i have dept table with below records SQL> select deptno from dept; DEPTNO ---------- 10 20 30 40 SQL> see that your input record is sorted for look...

bellow job design can help. OCI stage(1)---->transformer1--->aggregator-------> transformer2---->transformer3--->OCI stage(2). i aggregation stage you find out duplication like select deptno,count(deptno) from emp group by deptno. then in transformer 3 apply condition that count > 1 rows should prop...

yes very true the logic works perfectly as mentioned by thiruiitd .

i agree with gateleys, you need to create a routine which will take necessary input parameter and file name, file needs to be in append mode(opened and closed for each record processing). Using stage variable you create a long string with a new line character as separator for each record, then try t...

i think it should create new .csv file for each of file creation link or transformation.

how are you processing your tables, do you have 3 jobs for 3 tables, or just one job for 3 tables, because i think you will be using routine only if your jobs runs successfully and in "After job subroutine", if your extractions is fine you add a record to end of processed file right ?