DSXchange

Hi, From what i understood, you need to generate date values(rows) between 2 given dates. It is possible in DataStage. You can write a server routine to do this. even an unix script can be called from DS to achive this. But it depends on what is your source, target and how you want to use these valu...

Hi All, What is the difference between ActiveStage and PassiveStage in Datastage? Thanks, Rajesh. Please refer to the 'Designer Guide'. "A passive stage handles access to databases for the extraction or writing of data. Active stages model the flow of data and provide mechanisms for combining ...

Hi Shrinivas,
You need to check all the links that are leading to the Terminator stage
and one of them might have been 'Unconditional'.

Hi,
What are your source and target stages in that job?

Hi Sumati, First step is to understand the file format. Reading from the file will be pretty easy. Can you open the file in textpad and see if it has any delimiters? (comma, space, tab etc) and are the values enclosed in quotes? is the file a fixed width? Also, once you define the fomat and columns ...

Hi Balakrishna,
Are you seeing any warnings or errors in log?
There could be an issue with the xpath specifed.
For example, for an XML of the form:
<a>
<b>123</b>
<c>456</c>
</a>
I would give the xpath as /a/b and /a/c
let me know if you have any questions.

Hi Balakrishna,
Are you seeing any warnings or errors in log?
There could be an issue with the xpath specifed.
For example, for an XML of the form:
<a>
<b>123</b>
<c>456</c>
</a>
I would give the xpath as /a/b and /a/c
let me know if you have any questions.

Hi,
What are your column and row delimiter values.?
If they are other than new line character, I think you can handle
new line values in columns easily.
Do let us know.

Hi, I am trying to generate excel file in data stage. In doing so i have a problem, When i am trying to append leading Zeros to a filed and witting into excel file all the leading zeros are stripped off. Can some one help ma in solving this. Thanks in advance. Hi, You can try using quotes for the f...

Hi I have written on stagevariable but it is giving me wrong result can any help me on this mystagevariable if trans.empno=mast.empno then 1 else 0 both columns are varchar columns trans.empno=00000802 (value coming from hash file) mast.empno=802 (value coming from oracle stage) but data stage show...

rajesh123460 wrote:Hi,

Could you please tell me what are the datastage related technologies?

Thanks,
Rajesh.

Hi,
Your question is too vague.
mention more cleary as to what you want to know.

Hi, I have worked with XML in DataStage, but we havent used the 'validate' option in that. You can use the Validate XML option available in XML Input stage. The invalid records can be captured using a reject link. you can request for XSD from your XML source team or there are lot of tools to generat...

Hi All i need to know about the user varible activity stage. Actually i need to invoke the one varible value which is there in other job.In a sequence i need to get this to compare the varble value. So help me in this. Hi, Can you explain your requirement and what value in the job you want to use i...

Hi, I have a server sequencer job that is running in a loop, creating invocation name by the $counter. The sequencer builds of 3 jobs: 1. write to an hash file one record. 2. Simple transformation job reading from DB and writing to another. this job get a parameter from the function "UtilityHa...

I'm encountering a strange problem calling a Sybase stored procedure in the stored procedure stage. The procedure is returning a result. When I excute the job I get the correct number of rows but all NULLs are written to the file. If I send the result set to a peek stage it shows the colums headers...