DSXchange

Hi,
Is Oracle 10g supported in DataStage 7.1?
This may be a reason for the error message.

Ketfos

Hi,
Can you specify what errors/messages you encounter while trying to retreive the data?

Ketfos

Hi,
You can use Expression Type and associate Triggers with them.

Ketfos

Hi, 1. You have mentioned that you cannot see the TimeStamp function in Designer and it is marked as red when you use it. ?? What happens when you run the job uisng the TIMESTAMP function in the transformer, even though it is marked as red. I have seen many times, even if their is red signal in the ...

Hi,
The latest version of DataStage (7.5) allows you to use Underscore ("-") character in job names

Ketfos

Hi,
You are having three links - input, output and Reject.
Use Show Performance Statitics option, while running your job.
This will give you records read from source, written to output link and written to Reject link.

Ketfos

Hi,
Are you loading sequential file into a database or writing it to another file?

Ketfos

Hi,
In DS 7x, you can pass parameter to DSGetJobInfo to find if you can run multiple instance of a given job

Ketfos

Hi,
Go to DataStage Director and choose CleanUp resources.

Select the PID# and Release it.

Ketfos

Hi,
It could be PROPATH problem or file permissions.
Make sure file is in PROPATH and is readable to the application under the enviornment it is run.

Ketfos

Hi,
Can you please explain what you are trying to achieve along with inputs ?

Thks
Ketfos

Hi, 20 stands for length of the output string. e.g Ans =Len(FMT("1234567", "20T")) will give a value of 20 Below is from HELP in DataStage Syntax Fmt (string, format) string is the string to be formatted. If string is a null value, null is returned. format is an expression that d...

Hemant,
What values you have in the following fields for one record in table/file

RecordDate
LAST_INCDR_DATE

Then check the result of the following functions

Iconv(RecordDate,"D-YMD[4,2,2]")

Iconv(LAST_INCDR_DATE[1,10],"D-YMD[4,2,2]")

This debugging might help you.

Ketfos

Hi,
I also had the similiar problem.
I set the ARRAY SIZE = 1 and TRANSACTION SIZE = 1 in the input tab of ORACI8 stage.
Earlier the ARRAY SIZE was = 500
By changing Array Size = 1 , it got resolved.

Ketfos

Thanks Ray,
You are correct and I apologize for the same.

Ketfos