DSXchange

What is the source of the file ? Is it coming from mainframe ? You can use CFF or use transformer and split the file

It can be done in unix scripting .Try with AWK

Then is there any way we can acheive this ?

Hi , I have to do transformations on some columns . This transformations will be determined runtime .Can it be possible to pass an expression as parameter and store the value in a file ? Expression1 : A + B -( C * D ) Expression2 : B - E +G Input file contains A, B , ....Z columns . The transformati...

Thats interesting ...I dont that APT_ORACLE_PRESERVE_SPACE wont work for conventional load . Thanks a lot craig for the valuable info. If I am setting that env variable to false and I am receiving a space in a not nullable field then in direct load job will abort . Could anyone confirm if my underst...

Thanks craig for your response .... I have to trim trailing , leading spaces of all varchar fields . When those records loaded into database all varchar fields shouldnt have spaces . I am wondering if this can be acheived without changing the existing jobs . Type of load may be direct or conventiona...

Hi Everyone , I have a requirement to trim all varchar fields . But this requirement came after completion of jobs . I thought of setting the environment variable APT_ORACLE_PRESERVE_BLANKS = FALSE and acheive the requirement .But , there are some not nullable fields . The job will abort if a space ...

as specified by ray , you have to transfer the file anyways so do SFTP or FTP

execute command activity , before / After job routine ...

cd /opt/IBM/InformationServer/Server/DSEngine

. ./dsenv

cd bin

After that execute the command ..

Is there no way to clear a job in my case ?

You can use before / After job rutine and use unix gzip command or in datastage we have stages like compress , encode .

I tried to clear the log but administrator is getting hanged . Can I remove that RT_LOG21 log file from unix system ?

How to find the mapping of a job and its job id ? I believe, RT_LOG_nnn -- nnn is a internal job id . Could you please let me know how to find the value of nnn for a particular job ? I remember we have to query universe tables like ds_jobs or ds_objects .But i dont know the structure and exact query...

Yes craig ..whatever andrew has mentioned is correct ...I remember reading that in one of the post ... Today also i have tried to view the log ..but still giving the same problem ... Is there any way to purge the log through command prompt ?? I cannot clear log through director as clicking that fold...