DSXchange

Hi, We are using datastage 7.5.1 server Jobs edition in my project. Today we are getting the below error when we tried to connect datastage director. run time error '6':overflow We were able to connect datastage director properly till yesterday. Can any body help us how to solve this error? Thanks

Hi

Thanks for valueble information. It is working fine for parallel jobs.
Is it possible in server jobs?

Thanks
Sreeni

Ray, I have two files with same structure, File names are test1.txt, test2.txt test1.txt file structure is ID Integer Desc Varchar(100) test2.txt file structure is ID Integer Desc Varchar(100) Can I read these two files data in one sequetial file stage? Could you please give us more explanation with...

Thanks, we changed the IP Adress of datastage server is working fine

Hi, we have Datastage server edition 7.5.1 installed on Sun solaris system(sample IP Address: 10.01.01.01) and we are using same system from two years. As per the requirement, we are planning to change the IP Address to 20.01.01.01. After changed IP Adress, Is there any effect to Datastage? Please s...

Restart the datastage server and try to open your Jobs.

We can see the Job is running or not in Datastage Director.

Is there any other way to find out whether Job is running or not by using Administrator command query?

I executed the query in prod and pre-prod datastage. It retruns same date format. So I need to dig into the prod and pre-prod databases.

I got the below entry.

LOC0020 D

Can I know the meaning of the above entry?

Thanks for spending your valueble time, I tried to get the more information regarding date default settings in msg.txt file. I couldn't get any info. I am able to see some sample below entries in msg.txt file. DLM0040 Process sig (%d) has date of %ld\n GNS0002 genser: cannot decode date\n UVR0018 to...

Try to use Job activity stage to call your job in Start loop and End loop activity stages in the Job sequencer. Use Start value = 1 , End Value =4.
Then same input record gets inserted into output stage four times.

Try to use Job activity stage to call your job in Start loop and End loop activity stages in the Job sequencer. Use Start value = 1 , End Value =4.
Then same input record gets inserted into output stage four times.

Thanks for the clarification.

I can see the NLS tab is disabled in datastage administrator.
where can I see the default date format settings in datastage server?

Sorry, I changed column datatype from Char(10) to Date(10).
do I need to verify any datastage specific properties?

Hi, I know it has been posted in the past. These posts helped me to solve my problem. we are using Oracle database as a source, one column data type in Oracle table is "date". when we are trying to retrieve data from this date column by using OCI stage, it is giving error "OCI has fet...