DSXchange

Can you explain, on which parameter we have to change in the uvconfig file for switching back to Univerese logging?

We are using Windows Server 2003 for 8.1.

I don't know whether this method will work, but give a try.

Try writing the Values to Userstatus and fetch it when required.

It seems, your requirement is just lookup validation. If a lookup fails, you wanted a negative number sent to the target. If this is you requirement, just create a simple routine which will return some Negative value, and whenever the lookup fails, call the routine and fetch the value. So that it wi...

I have corrected the issue. The issue is , there is no "Perform Command" after the "SET-FILE".

And changed the line

TempVOCName = "JOBS_" : @USERNO

TO

TempVOCName = "JOBS_1"

I am getting errors when executing the above routine. I TESTed it from DS manager. I am using Windows Server 7.5.2. The value for @USERNO is substituted as "-2208". So TempVOCName is formed like JOBS_-2208. I am getting error like ProjectName -- : ANAND_TST_PRJ Command -- SET-FILE ANAND_TS...

Your routine could create a temporary VOC entry that points to DS_JOBS in each other project in turn.

Can you please provide some examples for it?

It depends , what stage you are using for a lookup and also your target Key Structure. You have to use Universe Stage or ODBC stage , to return Multiple row set from the lookup. Search the forum with the keyword "Reference Link with Multi Row Result Set", you will find ways on how to imple...

Thanks for the Replies. Using DCount(Convert(@TM,@FM,RVal),@FM) doent give me the desired results, So I have used two loops one for validating the Keys and one for Validating Non Keys. Read Record From HashVal, CurrID Then RVal = Record ******* Loop and Validate the Key Fields KeyColCount = DCount(C...

And after getting the column count, I will loop all the columns, i want to read the column value like Record<1>, so whether i will be able to read the Key columns and its value also like this.

I am writing a routine , which will get HashedFileName as Input and Check the Values in all columns of it. By default the hashed file will contain 1 row, and i wanted to see all the values of all columns is there in a specified range. I am writing something like this OpenPath FilePath:HashFileName T...

One way to find is, take an export of any job and open the dsx and in the Header Section , you will see Server Version. BEGIN HEADER CharacterSet "CP1252" ExportingTool "Ascential DataStage Export" ToolVersion "4" ServerName "Anand_Local" ToolInstanceID "...

Or Use the supplied KeyMgmt Routines.

We have a Project Level ENvironment Variable, $TGT_DB_CONNECTION, and i was trying to fetch that value from DS Manager.

I am using this routine provided by Ray FUNCTION GetEnvironmentVariable(EnvVarName) If UnAssigned(EnvVarName) Or IsNull(EnvVarName) Then Ans = @NULL End Else Call DSExecute("UV", "ENV", Output, ExitStatus) FindStr EnvVarName In Output Setting FMC,VMC,SMC Then Ans = Field(Output<F...

We have a dimension for capturing all the dates and the corresponding Surrogate ID values , and previously we were using this lookup and got the SIDs from the Hashed File. And later on, we have written a custom routine to convert the given date to the SID value, as it is more like removing the hyphe...