DSXchange

Create a shell script to check the size of the file and based on the return code direct the sequence to act accordingly. [[ -s $IFM_INPUT_001 ]] RC=$? if [ $RC -ne 0 ] ; then return 0 fi if [ RC -eq 0 ] ; then return 1 fi Use the above to check the size. If the filesize is 0Kb then the above will re...

How about the Commit Interval for the current job?

Ok I assume the 'click box auto' that you mean is the Auto partiton. Yes by enabling auto partiton, orchestrate it self will introduce a sort and partiton the data based on the key specifed in the join stage. But based on the previous experience (of all who use this this forum) it is all better and ...

A workaround. ls -1 /dir/filepattern*.txt > xxx.txt; cat /dir/filepattern*.txt >> xxx.txt Add this in before job subroutine. and read xxx.txt as 'specific file'. Now the first line of the xxx.txt will have the filename. In transformer @INROWNUM = 1 can be used to grasp the first line.

opdas wrote:How do I get the file names? Do I have to do some changes in setings?
Coz I get File Column Name as "/dir/filepattern*.txt" the same thing I pass in File Pattern.

If you just want to get the file name, just pass the path name alone, it will read all the filename present in the directory.

Well, in that case, try to restart the server.
Try executing the command in Adminsitrator client.

Make sure you get a valid count number rather than an error.

Two input to a join, emp and emp_chg. Check the same in a transformer.
if( (emp.empno=emp_chg.empno) and
(emp.ename<>emp_chg.empno or
emp.job <> emp_chg.job or
.....
.....
......
)
) then
"y"
......
.....
.......
Load it in to emp.

Some time not all the jobs produced during run time where cleaned. If this is that serious, it may be worth cleaning the tmp directories manually (periodically).

lstsaur wrote:Hi Guys,
Champa's job is running on Windows platform; there is no "CAT" command to concatnate the files. Am I missing something?

Then 'TYPE' would help.

Try to make use of Alais name.
Use user defined SQL. And redefine the the name of the column in the metadata as without '-' (like M_User) and use the SQL as

What is the stage you are using.
A workaround. Try to create a View without any special character and use it.

Nothing mention in release notes about these, upto to my knowledge. Best place to get it confiremed, contact your service provider and rasie a case with IBM tech people.

If you interested in comparing the individual component residing in the job then check out the code available in the following link.
http://www.dsxchange.com/viewtopic.php? ... Properties