DSXchange

hi amsh76,

You can Use RowProcCompareWithPreviousValue Rotine in SatgeVariable or as Contraint to remove duplictes.

GoodLuck

Hi Bunny,

Your
IsNull(Feild1) And IsNull(Feild2) And IsNull(Feild3)
Will Work If All Feilds In a Entire Row Is Null
Instead If Go With
IsNull(Feild1) Or IsNull(Feild2) Or IsNull(Feild3)
Will Work If Any Feild In A Row Is Null

Try
Martin

Ray..Duke....Chullte....Sainath......You Guys are Amazing .....Simply Great..... And This Forum......I have No Words to Say....Your Contribution To Your Fellow Developers Through This Forum......I Salute You All Guys.

Martin

Hi Luk, I want to use in every 50 jobs 1 parameter (or maybe env variable as you said) but at the momement I have no parameters added in my jobs. I want have name and meaning of my parameter the same in each job but I want to set different default values to them and assign diffrent values to them be...

Sorry.........This Will Not Pick 1st Row, In 100 rows Scenario with Similar Data This will Omitt 1st Row and retuns all rows from 2nd row(99 Rows).

Martin

It doest care 100 rows, but RowProcCompareWithPreviousValue = 1 Will Pick 2nd row.I tested with your Sample input, Its picking 2nd row.

Martin

Define RowProcCompareWithPreviousValue(DSLink3.HHID) = 1 as Transformation Statage CNSTRAINT This will retun 2nd record.
Remeber This Retun 2nd record not Last Record.

Martin

Hi Reddy,

Try RowProcCompareWithPreviousValue.

All The Best
Martin

Hi knowds, Logon to DSAdmin(Make sure you have Admin Privilages) -> Choose Project -> Coomand Line -> run LIST.READU you will find Active Record Locks -> UNLOCK USER <userno> ALL or UNLOCK PID <pid no> ALL or UNLOCK Inode <Inode no> ALL. :lol: Your job is Unlocked. HaveFun Martin

Hi talk2shaanc,

Logon to DataStage From Telnet Service and try HELP

All the best
Martin

Hi ketfos,

To unlock the DataStage job, execute the following command:

UNLOCK USER <Userno> ALL

Martin

Sorry.......... Its STATUS not STSTUS

Hi ewartpm,

From DS Admin -> Select Project -> Command line -> run LISTU / LIST.U / STSTUS.

Or

Using Telnet logon to DataStage Project and you can excute Universe commands

Martin

Hi ewartpm

Try LISTU or LIST.U Universe command, This command display DataStage Users Sharing System.

Martin

Hi vmcburney, Thanks For The Response.

svNewKey : input.f1:input.f2:input.f3:input.f4
svIsDuplicate : svNewKey = svOldKey
svOldKey : svNewKey

I want to count In svIsDuplicate

svIsDuplicate : If svNewKey = svOldKey Then +svIsDuplicate Else svIsDuplicate

Will This Work
Thanks
Martin