DSXchange

kduke

The control chars are form feeds or clear screen codes for your term type. You can SET.TERM.TYPE to any defined at the UNIX level in terminfo. You can also suppress your column headings and regular headings with COL.HDR.SUPP and HDR.SUPP or something close to that. Do HELP COL. and see what comes up...

kduke

There are several routines posted that will do this. I posted one, Ray and Ken also posted routines. A more complete solution is to buy Parameter Manager from www.tools4datastage.com.

kduke

Do a TERM command to see your settings. TERM Terminal Printer Page width: 80 132 Page depth: 65 66 Page skip : 0 LF delay : 0 FF delay : 2 Backspace : 127 xterm then change it with: term 1000,65,0,0,2,127

kduke

I figured that out after the post. How big can make TERM?

I think Ray posted an answer to this.

kduke

Write a job. Use this SQL in a UV stage. Output to a sequential file maybe fixed length.

Please post your JOBTYPE dictionary item. Come to think of it why not have a dictionary item for DEPEND_JOBS.

kduke

Ray posted SQL for hash file names. If you do a search and cannot find it then let me know. I would use this. If a hash file is used in a routine then you need to search DS_ROUTINES as well. I think this should get you close.

kduke

All hash file lookups are outer joins because DataStage does not care if it finds a hash record or not.

kduke

You would have to do some programming tricks. I wrote a job to email you the log file of any job. You could automatically run this at the end of a sequence for every job in the sequence. It is part of EtlStats. You can download this from my tips page.

kduke

Maybe. That is what they asked for.

kduke

You have to cal UtilityAbortToLog() to abort the sequence otherwise you get the warning. We call this last in the exception handler path.

kduke

Code: Select all

select 
   TIMESTAMP, 
   SEVERITY, 
   FULL.TEXT 
from 
   RT_LOG32 
where 
   EVAL \"@ID\" NOT LIKE '//%' 
   AND @ID > CAST(EVAL "FIELD(TRANS('RT_LOG32','//JOB.STARTED.NO',1,'X'), @SVM, 1)" AS DECIMAL)
order by 
   @ID
;

kduke

We do things like this in shell scripts then use ExecSH.

kduke

If you have a memory leak then you can watch the process size grow by using top or ps -ef. At some number of records it will be larger than the OS can support and will core dump. In UNIX a core file can be analyzed to find out why.

kduke

The memory leak appears to be an Oracle client issue. We have 2 versions of 8.1.7. The test and dev versions are the same and there is no leak. The production version is different and does not have the issue. The Oracle 9.2 version works as well. It only works with the Oracle 8 OCI plug in. We do no...

kduke

The EVAL is a column on the fly without creating the dictionary item. I posted dictionary items recently to get the column names and lengths. Do a search if you cannot find them then let me know. Do an exact search for ColNames or MvCols. You already have the job name and link name in the previous S...

Search found 4605 matches