DSXchange

Hi, Does anybody know how you can get an overview of scheduled jobs, also jobs that are scheduled with a user id different from your own userid ? thanks & regards Luc Luc Huygelen Data Engineering EDS (Electronic Data Systems) Noorderlaan 147 2030 Antwerpen (Belgium) * +32 (0)3 544 6026 or 8932 6026...

Hi Don, in your case u cant use "Reject constraints" because the steps in the transformes stage are executed sequentially from top (i.e. stage variable) to buttom (i.e. output fileds derivation). I suggest u to define a stage variable and use your Routine in the stage variable derivation. Then in th...

In a routine I have the following lines :

If Trim(Output) "" Then
Message = "*** Output from command was: ***":Output

What is the meaning of the ?

Thanks,

Kasia

If you have the Repository tree window open in the Designer, you can drag and drop any stage type from the tree onto the canvas, whether they are also on the palette or not. The help text seems to be out of step - I think the Insert menu has indeed gone away. Cheers.........Len > -----Original Messa...

Not entirely correct Craig. Any link can be marked as a reject link. It is only the reject link which has no constraint which is the catch-all for rows which have not gone down any other link. -----Original Message----- From: Craig Hulett [mailto:Craig_Hulett@rsausa.com] Sent: Tuesday, February 19, ...

Have a look at the sort column in the aggregation stage and make sure it is not set to a number, this error appears when you tell datastage the data that is input to the stage will be sorted in this sequence. -----Original Message----- From: Celeste Lim (COS-HO-IT) [mailto:celeste@kurnia.com.my] Sen...

Dear all, Have any of you encounter such error message? This occurs when I tried to do aggregation on dates. I have changed the SQL type to Varchar and data element to String in the Transformer stage. But the error still exists. Im running on DS 4.1, Windows 2000. The error message is, mtmasttesting...

Ray and Craig, Youve given me a lot of options. Ill implement a simple one now using either the stage variables Craig suggested or the @USER.RETURN.CODE that Ray suggested. However, for future jobs Ill Try some of the other suggestions of having a pre transform stage to do some data cleansing (rejec...

Don, What causes a row to go down a link marked as a Reject Row is the fact that the data has gone down *no other link* in the transform. In other words, the only time data goes out a Reject Row is if it has no place else to go. Now, you can put constraints on the reject row, but typically it would ...

I assume you meant the DSTransformError() function. The purpose of this function is to log a message, including the input argument values for the function. It does not signal back to the Transformer stage at all. You essentially have three choices. 1. On the output link that handles valid rows, set ...

I have written a routine which is called from a Transformer Stage as the derivation of an output column. The routine simply validates and translates an input column to a different value. If the input column is not in a valid range, the Routine calls the DSTransformFunction to log a warning message. ...

Brad, You dont have to use the same names in datastage as are in the access db. You can use your own names for the columns in datastage and then specify the Access names in the derivation field of the ODBC stage. If the column name has a space (or something else undesirable) in it then try putting t...

In an earlier email on this thread Himanshu Patel wrote that you can use the command UNLOCK ALL to reset a locked job. I would counsel most strongly against using this command for this purpose. This is because it will release EVERY lock held by DataStage processes, not just the one that is preventin...

Clicking Help while in the Administrator client gives you access to online help. There is also a manual for DataStage Administration, installed with the other manuals in the DOCS folder wherever you installed your DataStage client software. Ray Wurlod Trainer - Asia Pacific Region IBM Informix Train...

The only additional light the trace has put on this problem is this: Event #:947 Event type:Info Message: GItcFtpFileVipsInt..Ftp_Data_File.IDENT2: Entered row_to_buffer Event #:948 Event type:Info Message: GItcFtpFileVipsInt..Ftp_Data_File.IDENT2: Finished row_to_buffer Everything looks fine in the...