DSXchange

Write a Shell script and do all the error handling in the script itself and call that from your Server Routine.

I was trying to setup a user id and password to schedule a DataStage sequencer job at the Schedule tab of DS Administrator client. I entered the User ID and Password values but I noticed the TEST button is disabled. And when I simply saved by clicking on OK button without TESTing, it is not working....

Ray, can you please describe the way you told in a bit elaborately such that it will be easier for implementation? Thanks. Status returns the file status of an open file and assigns it to a dynamic array. field-6 of the dynamic array will give you the file size. Following snipped may help you to un...

Write a DS routine, in which find the size of the file by executing a Unix command and do a check to find if it is more than 5 MB and send a mail notification. Call this after your sequential file creation job . (I think, if there is no intermediary storage on your server, you may have to write a sm...

For me, it seems more like a repository related issue.
Please check your DB2 and see if there is any issue with the database.

yes it is :) Can you pls provide the syntax to wrap the plsql code in unix shell script? Are you serious?? Okay, Firstly you have not provided the full details of your environment mainly the Database. But the below snippet may help you, if your database is Oracle. #!/bin/sh sqlplus -s username/pass...

yes it is

Wrap your PL/SQL code in a Unix shell script and call from After Job subroutine.

Looks like you have not installed the VC++ compiler or installed a wrong version or not configured the necessary ENV variables. Please do a search in this forum to know how to do that.

In that case, (and if I understood your question correctly)I believe it should not work for a direct Fast Export also. But I am able to export the same data in to the same sequential file with same parameters using a stand alone FExport script. And I am able to open that sequential file and read the...

In continuation to my above post, I have made some progress in isolating the error. And I've understood the following: 1. The record size (of each row) in the Database is 22,652 bytes. 2. It is not the problem with FExport because, the log is showing that the data was exported successfully. 3. Not s...

How does it distinguish between multiple '?' markers?. If I have 5 '?' markers and 5 values coming from the input link then how does it map the incoming values to the '?' markers? just basing on the data types?

To quote Walt Disney, "Sometimes dreams do come true". But for DataStage this dream can quickly turn into a nightmare. It depends on the ease of obtaining the changed metadata. Is it from a DBMS? How is the target metadata maintained and updated? The source data is on ORACLE & DB2 and...

I mentioned 'record delimiter' NOT 'field delimiter'
I believe it should work in ur scenario.

specify the record delimiter as '#' in the file format properties.

Hi, My client has a requirment in which, whenever a source table definition changes (when new columns are added or deleted), it should get updated automatically in the DS job (they are using PX), and should reflect in the target tables. This should happen without making any changes to the job/code, ...