DSXchange

Can anyone tell me how to code a custom routine that will call DSLogFatal subroutine to abort a job that is not in the present job that contains the routine?

Ex. JOB1: running
JOB2: routine that stops JOB1

Thanks,
Angela

fyi...
If anyone runs into this problem--the solution was easy. All I did was define my own SQL Query and used the convert date function in Sybase.

ex. convert( char(8),Asset.tUpdateTime, 112)

Angela

I am pulling data from a SQL server database via ODBC to a flat file. One of the columns is a date column with a format of MM/DD/YYYY. It is defined by Datastage as a timestamp (Imported into Manager), but I receive the following message when I try to view data: DSBrowser..AssetInfo.AssetInfoIn: DSD...

I am pulling data from a SQL server database via ODBC to a flat file. One of the columns is a date column with a format of MM/DD/YYYY. It is defined by Datastage as a timestamp (Imported into Manager), but I receive the following message when I try to view data: DSBrowser..AssetInfo.AssetInfoIn: DSD...

Hello,
We are running Datastage 5.1 on Unix. There are jobs that need to be run every 15 minutes. I didn't see that option on the scheduler. Does anyone do this, or can it be done?

Thanks,
Angela

Hi,
I was wondering if there are any published "best practices" guidelines for building Datastage jobs, naming conventions, etc. I know there is a class offered, but it's $3500. Does anyone have any practical guidelines?

Thanks,
Angela