DSXchange

Hi All,

I need to some help with decimal value comparsion.
Iam having source field col1 as datatype Decimal(38,10)

Requirement value
If col1=0.5Then 5
Else 0

Input Value : 0000000000000000000000000000.5000000000

please advice me how to compare decimal value with 0.5.

Thanks,
chandra

I am using one hash file in 2 -3 server jobs . Column required in all the jobs are different ,so i have selected only required columns in respective jobs. the above three job are running on daily basis . At the time of inserting the hash file ,some how one of the record is getting rejected . To solv...

Hi all, ' Iam trying to use "Job Comparsion utility" from designer in Datastage 8.1 version to compare two jobs .And i checked the report and found the report is not showing the changes in Filter stage link ordering in those two jobs Please advice on below 1)Is there any limitations with t...

Hi ,
I never worked on XML part earlier. So please help me in extracting mentioned XML file

Hi all, Could you please help me in reading below XML file .I need to produce an sequential file from Xml input file . <Employee Place="USA" Status="Active" Date="2012-09-30"> <Name="AAA" No="1" Grade="B" /> <Name="BBB" No="2...

I wonder is there any way to modify the contents in "Dataset" .Can we use UV commands to achieve my requirement?

I used APT_STRING_PADCHAR in job properties and to set the pad character to space in Sequential file stage .

And the records which are short of length are rejected for CHAR datatypes.

please somebody help me on this

I used CHAR datatypes for all fields. But in PADCHAR property it is not allowing me to set 0x20.Then i choosed SPACE property. But all the colums fields the short of length specified are failed are getting dropped.

moulipx wrote:Actally the records are not getting rejected if for varchar fields.

Could someone help me on this..

Actally the records are not getting rejected if for varchar fields.

I did sequential file stage. But for VARCHAR fields if the data length is greater than original column length the row is getting rejected.

plesae guide me on this..

as i said my source file is having 300 columns. it's very tedious to use so many stage variables . Is there anyway to do in transformer.

My Source is Sequentail file . And i can't use CHAR datatype while reading the file Since in some times my columns values length may be less than metadata length specified.

Hi, I need some help regarding rejection of records based on column length for each record. please find sample below file format. And my contains nearly 300 columns . col1,col2,col3,col4 aaa,bbbb,cccc,dddd 111,22,333,datadata And the metadata of file is ColName length col1 3 col2 4 col3 3 col4 4 My ...