DSXchange

Take logic like this,... in transformer define a stage variable if prevrow_dept=current_dept then stgvar1=stgvar1+1 else stgvar1=0 in columns give the below expression.. if stgvar1>inrow.limit then inrow.student else setnull() --for outrow.student and put output constrain outrow.student Not null

I think its a unix question..

file1 contains "I am a very good boy"

then.. a sequence of commands or script like below will give you desired output.

echo "suresh" > file2
cat file1 >>file2
echo "bye" >>file2

I wish admin to edit the question(to get back the previous post) and warn the user.

The edit permissions should be taken off for the Questions after the Question gets replies, to avoid these kind of situations.

ray.wurlod wrote: YELLOW CARD ...

Whats this YELLOW CARD mean ?

Use COUNT function in transformer.
Count(Link.Inputcolumn,"substring") In you case substring is "_"

How do I get the log details of a job (job activity) inside a sequence job ? If I have Sequence job with couple of Job activites.. Job1==>Job2===>Job3 then the log of Sequence Job shows something like below... Job1 Finished,Status=1(Finished OK) Job2 did not finish OK, status = 'Finished with warnin...

I used RDBMS stage and used "before SQL" tab and mentioned just the stored procedure name without call/execute or any other command.

In "Before SQL Tab"
use "SchemaName.StoredProcName"

I think(no sure though) this should work for ODBC stage as well..

Thanks for the reply Vinod, I tried the command, These were the output lines. 117 INFO Mon Nov 10 13:51:03 2008 main_program: Explanation: (...) 118 INFO Mon Nov 10 13:51:04 2008 main_program: Dump: (...) 119 INFO Mon Nov 10 13:51:04 2008 main_program: This step has 1 dataset: (...) 120 INFO Mon Nov...

How to get detail Job Log in email using notification activity in DS 7.5 ?

Right now.. I am using IncludeJobStatus in Notification Activity Stage.
But, It just provides me whether job activity finished sucessfull or Aborted. It doesn't give me the error details if a JobActivity Fails.

Below is the info I found.... Oracle Programmer Oracle Programmer is a separate Oracle product that provides a programmatic interface to any edition of Oracle Database for application programmers. Programmer provides a rich set of interfaces for developers who build enterprise applications that acce...

John Smith wrote: And if it is a banking type transactions again don't use Datastage.

Can you please explain us why ? I didn't understand this point.

Thanks Craig and Nagaraj,

Happy to hear..... about Parameter sets in Datastage 8.0v

HI all, I would like to know.. How to add more than one environment variables at a time ? In my jobs I add more than 5 environment variables and in DS Administrator we have plenty of variables.... each time I have to open the 'ADD ENVIRONMENT VARIABLE' box and find the variables to add. Can anyone s...

I think you cannot use FTP stage for SFTP. Passing password for SFTP is different than that you do FTP. I would suggest the easiest way is to ask your unix admins to have a pairing between two servers (source & your local file server) by sharing keys. With this you don't have to use any username...

converted date is coming as incorrect data which means incorrect year Say for example Input data : 011008 (01-10-2008) After conversion : 01101908 Please use %2000yy instead of %yy since the year is 08 it is taking as 1908. So, please mention %2000yy and this will give you the right output 2008. Th...