DSXchange

On the NT Platform, you can use AT commands ( on unix, crontab) ...
to schedule jobs instead of the DS schdluer.

It's works on win2k also,
in your case you need to fix some parameters for the MKS Toolkit...

the file is interfaces
generally found in :
/opt/opcl12.5.1/
(the sybase client location)

I'm working with the sybase OC 12.5 plug-in and everything is fine, what version are u using ?

you need to preprocess the file using OS (unix) commands or a datastage routine, personally I use a DS routine to copy the selected lines (count(lines)-1) to a new file...

add in the transformer something like:
if in.field01 = 'NULL' then @NULL

You can use a multiple instance job, setting a different invocation ID in (one invocation ID for each call to the job) the sequencer ...

use the option -param ...

you need to add a sequencer stage, link the inputs to it then generate an output from it...

a transformer with 2 outputs will do the job, selecting the right metadata...

If you are using 7.1 or 7.0 there are still few bugs related to encrypted parameters...

Read the release notes there are some informations concerning the sybase open client versions compatibility with the datastage plug-in...

You can use :
Right(mystring,Len(mystring)-4)

if you hav always 4 zeros at the beginning...

Hi,

When you are using a routine that returns a value inside a sequencer, you need to set the trigger to Failed (Conditional) ie the link will always be red in the sequencer design, this applies when the checkbox - Automatically handle activities that fail - in Job properties/General.

Youssef

Here is a sample routine that works with DS/Solaris/Unix ************************************************************* ** Routine: GetFileNbRows ** Creator: Youssef Loudiyi ** Company: BI Expertise - www.biexpertise.com ************************************************************* **** Get the line ...