DSXchange

Hi,

Oconv(49477404.97, "MD2,P")

Ans = 49,477,404.97

You can use Oconv(yourinput, "MD2,P")

Hope this helps

You can do a search on DSGetLogSummary to get many insights on this topic.

Hi Ranga, Please refer PRAJDEF.PDF CHAPTER 24 and CHAPTER 35 The Decode stage is a processing stage. It decodes a data set using a UNIX decoding command, such as gzip, that you supply. It converts a data stream of raw binary data into a data set. Its companion stage, Encode, converts a data set from...

Hi Varsha, You can use the Convert function to convert all the "&" to "," So after conversion your data will look as follows 1,A=B,C=D,E=F,G=H 2,L=M,G=H Then you can use the pivot to pivot the data and get the result in the required format 1, A=B 1, C=D 1, E=F 1, G=H 2, L=M 2...

Hi,

In a database table you do not need a dummy column, you can achieve the same result using CROSS JOIN.

There is very good ppt on ADN called Hash File Tips and Tricks which answers your questions.

Hi Sudharshan, Are you reading the whole input as a single column? When you do view data on the input field you should get Field1 1,A=B&C=D&E=F 2,G=M Then you have to use this single input column Field1 in both the derivations for the stage variables and you will get the required result. Don...

Sudharshan, Stage Variables: StageVar=FIELD(DSLink3.Field1,",",1) StageVar1=EREPLACE(DSLink3.Field2[3,9999],"&",CHAR(10):StageVar:",") You have 2 fields in the input Try reading both the fields in a single column by specifying a delimiter like '|' that is not presen...

Yes the Merge Stage

Hi Sudharshan,
Can you paste a copy your derivation for the stage variables.
As I have achieved the desired result with the derivation specified.

Hi,

I don't think the Parallel Jobs can be executed on Windows Server.
I guess this is soon going to be available on Windows 2000 and Windows Server 2000 as said on Ascential's website but not yet

Hi Sudharshan, :) Remove only char(15) from the derivation for the Stage Variable RestofString also replace the Quote Character to 000 in the Output Format Tab and try and let us know. You will not be able to see the Output File as the Output file is defined for 1 column and the derivation converts ...

Hi Sudharshan, I have tried Arnd's method in a sample job and it has worked for me. Have u created the stage variables? You need to use the value of the KeyNumber stage variable in the RestOfString stage variable Also after you run the job open the sequential file on the server to see the Output as ...

Hi, Can you please explain what does this mean, In pri_asset _type table we have key column pri_asset_type _id but that key filed exists as differnt fileds in source Does this mean that the names of the key fields are different in the source and the lookup tables? If so there is no issue at all Also...

Hi,

This is an unsupported utility shipped with the cd.
Helps in deciding the modulus for the HASH FILE depending on the record size, number of records and the key pattern.

Do a search on the forum for more insights on the same.