DSXchange

Hello,
I want to add 100 years for the TimeStamp. How to do it? Thought of adding days, but is there any other way to do this?

Thanks in advance.
Naidu Buddha

Thanks Chulett. Now I could able to learn some thing about Quality and Meta Stages. But still I can't understand the following : 1) Is there any case or necessity where we use all or some of these ie AuditStage, MetaStage, DataStage, ProfileStage etc. in a single project. If so, what is the order of...

Thanks Ray. The problem is as of now I don't have that material. We didn't receive the docs/technical articles. Till that time to have a basic knowledge on all these stages which I can/have to use later in my project. Please let me know where can I get the info abt the different stages or atleast a ...

Hi All, Am sorry if am into a wrong forum. But I can't understand where to put this question. Am new to DataStage and am only only using that. My client he also wants to implement AuditStage and QualityStage. Some how I managed to get some knowledge in DataStage by developing different jobs. Now Aud...

Hi All
I am new to this and just started working on DataStage. Please help me to clarify my doubts.

What is QualityStage?
Why do we use QualityStage?
When do we use QualityStage?
How do we use QuallityStage?
Where do we use QuallityStage?

Thanks in advance.

I have a raw data file, which contains records. I need to process that file and export to DB. The process involves adding a corresponding for each record and for this we have to compare a field (say F1) value. If the value of F1 is 1 insert one more record in DB with almost same values as that first...

Mr Reddy,
Why don't you try LongVarChar in DS? Hope this can solve your problem.

Thanks for the suggestions. Can you please help me how to call that routine?

Thanks for info ArndW. I'll try. But I wonder if there is no function for manipulating dates. Is that are we missing any function or there is no function or API to handle such things.

How do we add a specific number of months to a date?
Similarly Days and Years.

Please help me.

Thanks in advance.

My server job details : Source data file : Text File Target Database : MS Access The problem is when am trying to read part of text from source file (which is of the format YYYYMMDD) and append that value to a date field to the target am getting "Invalid character value for cast specification (...

Thank you guys

When am running a server job am getting this warning and records are not appened to the MS Access table.

[DataStage][SQL Client][ODBC][Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification (null).

There are no any null values or casting am specifying.

Thanks for the info

Thanks Balaji. Can you tell me where can I get the material or tips to clear the exam.