DSXchange

Hi All, I am extracting a timestamp attribute(EFF_DT(nullable), format as '2005-01-30 23:59:59') from oracle connector after join with another oracle connector and passing the value through a transformer and writing to a dataset. I have handled null by using If IsNull(EFF_DT) or Trim(EFF_DT)='' Then...

Hi, I have a sequence wherein I have used 3 routine activity running in parallel with error link to all three.My routine activity stage executes three different shell scripts.Parameters like dbase name,password and script name are passed. The job sequence executes fine but my problem is the director...

Hi, I have a sequence with 3 routine activity stages being used to execute 3 different shell scripts in parallel along with database credentials provided through job parameters. My problem is the job executes fine, but when I see the log in Director I do see the passwords(database) being displayed. ...

Yes, I can view in DS management tool in designer and also Peek stage.


Thank You All for the response.

Hi,

Out of curiosity, I have a question whether we can view data of a particular node in a dataset? If yes,how can we...

If data is loaded to a dataset with 4 node config file, how can I view data of node3 of the dataset.


Thanks in Advance,

Harsha

chulett wrote:Perhaps just?

Code: Select all

FILEDATE = DD : MM : YYYY

You could also simply use Convert() to remove any delimiters that OConv() added to the date rather than chopping it up and reassembling i ...

Hi,

Tried the above but it's not working to the expectation.

Thanks in Advance.

Hi All, Kindly guide me for the below problem. I need to substract a day from to date and carry the value for further processing.Pls help me out. input format of date: DATE_TO=18/02/2010 D1=Iconv(DATE_TO, "D2/") D2=D1-1 TSTAMP1 = oconv(D2,"DDMY[2,2,4]") DD = TSTAMP1[1,2] MM = TST...

How do I look up data which is more than 2gb in size in a server job.

FYI..

Declare 2 stage variables in the transformer-

Constraint StageVariable
------------ --------------------
svCurr svPrev

Input.colname svCurr


Mention the constraint svCurr<>svPrev in the output

Datastage 8 has only 3 client component,i.e DstgManger is merged with Dstg Director and there is additional SDC stage.