DSXchange

[quote="priyadarshikunal"][quote="poonam12"]We access server through citrix, so no client installation on our systems. Can you please help me with where should I look for to check for client installation...[/quote] you can't directly access the server through citrix. :twisted: so...

We access server through citrix, so no client installation on our systems. Can you please help me with where should I look for to check for client installation...

Hi All, Can you please help me with path where dsexport.exe can be found. We access datastage server through citrix, which is on an unix server. Therefore, there is no client installation on our systems. I have checked in server installation directory: /DataStageApp751_dac/Ascential/DataStage/DSEngi...

[quote="ray.wurlod"]That value only has eighteen "9" characters and is therefore legal as a BigInt. ...[/quote] Yeah thats write but if you pass it directly in a BigInt field it is rounded to int32 value by datastage. To retain this value,it need to be passed 1) as a character fi...

[quote="ray.wurlod"]Not unit, but uint, which stands for "unsigned integer". The job is showing it as whatever you (or its designer) programmed it to show. If you imported the Bit type from a database, then the databas ...[/quote]

mistyped while writing...Thanks for help.

In Parallel Job developer guide , underlying data type for Bit is stated as 'Raw'. But when I check in Parallel job, its underlying datatype comes as 'unit16'. I think as a Bit is represented as 1000 0000 , it should be raw which represents 1 byte for each character and not uint16, but why job is sh...

I used following code:
StringToDecimal('999999999999999999')

Now it was not rounded up and correct value was passed.Thanks for your help.

Hi All, I have a problem when dealing with bigint values. In my job in a transformer when itry to assign eighteen 9's i.e 999999999999999999 to a BigInt(19) field it rounds the value to 2808348671. How can i pass the original value to output as i could not find any explicit type conversion function....

if isnull set the date value to 0000-00-00 and try using isValid before transforming like if isValid(col,'date') then transform else

yes i got explanation upto some extent...Thanks

i may sound stupid but what do you mean by online help the one we get by pressing f1 on our datastage canvas or there is some seperate url for accessing online help.

Hi All,
I need to learn about different row generator algos as there is some permutation data to be generated. Please tell/provide the documents to read for learning about these algorithms and their different attributes. I could not find anything in parjdev.pdf.