DSXchange

Hi,
It appears your string data is being right truncated.
Output buffer is not large enough to retain entire string.
Hence it is being truncated.


Ketfos

Hi, This might help 1. Define enviornmental variables like hostname, database name, project directories. 2. Define SQLPLUS path in the enviornmental variables. 3.Check for the input file if any. 4.Call your SQLPlus Script which has stored preocedure. 5.Call Datastage job to check for any errors as t...

Hi,
I am sure idea of executing through a UNIX script is more than just executing the dsjob command.
User might be controlling the execution, writing results to log files, recording error files, house cleaning, generating emails...


Ketfos

Hi Poorna,
Can you please elaborate on what is your input and processing for the above error message?

Ketfos

Hi,
Try using in Director
LIST DICT FILENAME

Ketfos

Hi,
You can also create CRON job in which you can define day and time of execution of the jobs
Call a shell script in the cron job
In the shell script use ---dsjob-- command to invoke the datastage job.
Of course you will need to define parameters for connecting to datastage.

Ketfos

Hi,
Look into - Scheduling a Job Batch - in DataStage Help.

Ketfos

Hi,
When you are transformoring the input mainframe file, is output a flat file or database table?

Ketfos

Hi,
The list is exhaustive.
You can
-Create Files
-Modify VOC entry
-Build File Dictionary
-Add Data to file
-Modify data in File
-Run command in background

are few things from the list.


Ketfos

Hi, You can use Stored Procedures for data manipulation(insert/update/delete) from and to tables. But you can achieve the similiar functionality in DataStage enviornment itself instead of using the PL/SQL stored procedure (In case of Oracle) and thus avoid PL/SQL statements. Shell Scripts can be use...

Hi,
You can get some information from the following link in the developernet forum.

http://developernet.ascential.com/forum ... php?p=2113

ketfos

Hi,
IN DataStage Administrator, go to the command window and type
CREATE.FILE and hit EXECUTE
It will ask you for file parameters
FILE NAME
FILE TYPE
FILE MODULO
SEPERATION


Ketfos

Hi,
You can use the oconv function to change the date to internal format.
Then pass this to Timestamp function to get the date with time.

Ketfos

In "What's New for DataStage 7[1].5 PDF Document under
Database Management Update It mentions of support of Oracel 10g

But the other trick you have mentioned has worked for me alsofor Oracle 9i.

Ketfos

Orchestrate was formerly produced by Torrent Systems
When Ascential took over in 2001, it became part of Parallel Extender Ascential Software's product suite.
You might something at Torrent Systems old site or ask Ascential Support?

Ketfos