DSXchange

Yes I did try IsValid("int8",mylink.mystring). But for valid values like 22222 and some of the decimal values like 1.0222, it is throwing 0.

Thanks,
Amar

Hi, I have a source field from file with CHAR10. I need to check if it is a valid integer. I tried using IsValid function. This worked fine non numeric fields, but even for decimal it validates as a valid number. I need to capture other than integer (including decimal) as not a valid numeric field. ...

Hi,

I am writing to a sequential file with a field delimiter \x1E. The delimiter worked fine till certain number of rows and after that it does not populate field level delimiter. Anyone had this issue?

Thanks

Below is the user defined sql that I am using.

SET ENCRYPTION PASSWORD = 'PASSWORD';
INSERT INTO TABLE(FIELD) VALUES(ENCRYPT('ORCHESTRATE.FIELD');

Thanks

Password id handeled in parameter set as an encrypted datatype. But here I am trying to load data into a encrypted field.

Thanks

Hi Ray, removing the quotes from the user defined query did not work.

Hi, I am trying to load an eccrypted field in DB2. I there a function to convert field to encrypted. I loaded directly as varchar but while selecting it says that the field is not encrypted. I also tried to encrypt with user defined insert statement. But for some reason it is skipping this field. Ca...

In the above logic can anybody please tell why should we apply the svRank function in derivation.

The same function was applied as stage variable and I am not geting the exact result as derivation.

Thanks

Hi,

How can I pass multiple values in one parameter.

For example : select * from table where field1 in '#param#'

When I pass one value like 'A', it works fine. But how do I pass two values like 'A','B'.

Thanks,

Hi, I am trying to load a csv file. For some reason I am not capturing double quotes. For example I have a field value like I DON'T "KNOW",ENGLISH In the above example I need to capture all the charcters like " ' and , to a csv. I tried using Dquote but not working. Can you please hel...

Hi, I have a simple sql used in a DB2 enterprise stage. When I view data I am geting proper values for couple of date field. But when the same job accessing the same table in a different environment gives some default values like '1901-01-01' for those two date fields.The datatype is date for these ...

Hi, I have a question regarding partition in join stage. My job design is to join two datasets. My question is, should I hash partition during this join in join stage. Because when we join two database stages the join stage will wait till all the records are read form the table and so we will get co...

Tahnk you for your reply.

I will concadenate and will follow as suggested. But how do I handle the rank in stage variable. I need to rank third record as '3' if first two records are same.

Thanks

You can remove special characters in datastage using Convert function.

Hi, I need help in implementing the ranking logic in datastage version 8.0. In my logic, I need to rank based on three columns. Example :- column1, column2, column3. The first set will be ranked as 1 and the second set with same value will also be ranked 1 and third set with different value will be ...