DSXchange

No, the job in the seqeunce must be started witout waiting..

How can you start a Comand Line interface commando dsjob in a seqeunce?

I just wan to run the job without waiting to finish.....

Hi all, I want to be able to use external functions in Datastage that are written in C++. To test how this should be done, I created COM server dll (or activex library in Delphi) with a few functions in it. When I try to import this dll in the Manager, I get the following error: Error calling subrou...

Hi all, We have build a sequence with a loop that must be run a job every hour. Each running job has it's own unique invocation id to make it possible that the same job can run twise (or more ) at the same time. Each hour the job will be started even if the previous job is still running. After start...

Example was for server job ...

hi all,

\NULL works !

Peter

Hi,

Output is not relevant because the job only needs to set the userstatus in the transformer.

Peter

Hi all,

My simple job has the following stages:

SYBASEOC --> Transformer --> Sequential File

Since writing to the sequential file is irrelevant, I wondered if I can skip this target stage? Or can I use a dummy (non-existent) filename?

Peter

Hello, Can it be that the filter stage does not support the use of brackets in expressions? In the meantime I was experimenting with external filter stage (using awk) and I found it very useful for my purposes. I want to build a job that checks if a field in a given dataset matches a certain (user g...

Hello, I tried to filter records from a table using the following regular expression: idnummer like '[P-Q][0-9][0-9][0-9][0-9][0-9][0-9][0-9]' (to get the idnummers that begin with P or Q directly followed by 7 digits). However, when I run the job I get the following error: Filter_3: Literal regular...

Hello, I followed your advice, but get the following error on the (user-defined) update sql statement: DB_SYB_FILE_REGISTRATION,0: Warning: DB_SYB_FILE_REGISTRATION: Sybase Server warning 102 (severity 15) from stored procedure 'Input_0', line 1: Incorrect syntax near ':'. I created a PX job with 2 ...

Hello

I think I still don't get it...

Do you mean entering a user-defined SQL query like this:

UPDATE THETABLE SET #DATECOL#:2 WHERE file_registration_id=:1

What then should be the second row in the columns tab?

Peter

Yep!

I am writing in PX but if solution is only possible in SE than that's ok to me..

Peter

Hello,

I tried doing it in one job, but I got stuck because datastage does not allow me to enter the column name (as parameter) in the columns tab?

Peter

Hello, I have a table with 4 start/end datetime columns (=8 columns). During jobrun these columns should be filled with the currentdate dependent on run status. One way to do this is by creating 8 jobs, each updating one of the date columns. Another, more elegant option - would be to create 1 job in...

Hello,

The suggestion of ray works fine.

However, I wondered if it is possible to quit the transformer immediately if the direction of difference has changed? How?

Thanks,
Peter