DSXchange

I tried adding a NULL value in the schema file itself and that worked. Thanks all.

Hi Andrew,
I have multiple files and there are too many fields like field1 in file1, field2 in file 2 so there's no common fieldname in the files. Every file has its own fields and its own field names.
In this case would I be able to handle the transformation through a generic job?

Hi Ray,
Since I am using RCP, I don't even know any of the field names. In that case, how can I use the modify stage to handle any decimal field? Would be really helpful if you can elaborate a bit.

Got my DS access today and the reject link works fine for me. Thanks all for the help.

Hi, I have a generic job which is loading data from sequential file to a database. Sequential_File --> Copy stage --> DB2 connector stage. I have some decimal fields in the sequential file which are blank and I when I try reading the file (through schema file), it gives me the following error; Field...

Hi Thomas, Thanks for the reply. I do not have access to DS right now so I can't check so just a small question. Can I use the reject property of sequential file stage even when I am using the stage as a source stage. I mean, can there be a reject link while reading from a file or a reject link work...

Hi, I have a sequential file stage which reads data from a file and propagates it further to the next stage. The problem is that my job fails whenever there's a bad record in the file (like metadata mismatch, different record type in file from the metadata). Is there a way I can reject bad records a...

Hi All,
I have a multiple instance job which loads data from a table to a file using RCP. I want to run the job for 10 different tables at the same time.How can I do that through
1. Designer and
2. Command line?

Thanks in advance.

I think you are right Ray, because I have a leading space for sign. So that means I first need to remove leading space and then leading '0's or rather stick to DecimalTo String with suppress zero. Thanks Ray. I during this whole time saw this leading Space in the file and it never struck to me that ...

You can use a sort stage to generate key change column. Then in the transformer through stage variables check for change in key change column and assign value accordingly.
If key change column is '0', assign Y. If previous key change column was 0 and current is '1', assign 'Y' else 'N'

Hi, I have a decimal field of length (38,0) in my source table. In the target I want to put it as a varchar field. I am using the TRIM function to remove leading '0's from the source field but '0's are not getting removed. Now I am using DecimalToString function which is working fine. But I am still...

Any help on my issue? Probably it could help 2 people now :)!!!

Hey priyadarshikunal, If suppose I have a policy and 2 corresponding named insured for the policy. My policy record in the source is: Pol_No, Transaction_dt 1234,20150102 Corresponding named insured records are: Policy_no,F_Name,LName 1234,FNAME1,LNAME1 1234,FNAME2,LNAME2 What I want in my output is...

Hi, I have different oracle tables like: -Policy info -Vehicle info -Driver info -Insured info I want to extract data from all these tables and put it in a cobol payout where data will be like -policyinfo -Corresponding vehicle info -Corresponding driver info -corresponding insured info So my target...

Hi Chulett,
Thanks for the suggestion. Just wanted to understand if there's some support E-mail ID where in I need to drop a mail or do I need to contact my company's Datastage administrator?